Map to a Table-value function

Posts   
 
    
EdMontalvo
User
Posts: 2
Joined: 07-Oct-2010
# Posted on: 07-Oct-2010 23:01:45   

I have used FunctionMappingStore to map a simple function, but now I have a need to map to a table-value function. Is this possible?

Thanks, Ed

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 08-Oct-2010 05:36:07   

I never tried, but I think it should be possible. The tricky part would be that the function mapping should return the correct type (DataTable?). Please give it a try,

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39905
Joined: 17-Aug-2003
# Posted on: 08-Oct-2010 11:04:26   

If you want to join with the table function it's not going to work however. Table functions for joins aren't supported.

Frans Bouma | Lead developer LLBLGen Pro
EdMontalvo
User
Posts: 2
Joined: 07-Oct-2010
# Posted on: 08-Oct-2010 15:07:08   

Perhaps there is another way to do it?

Is there a way to populate a datatable with the results using the DataAccessAdapter?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 09-Oct-2010 02:56:37   

You can use DynamicList or Stored Procedures (the SP call you table-function). Maybe if you post some approximate SQL or some code of the function and what data you can fetch, we can give you some options.

David Elizondo | LLBLGen Support Team