Retrieve hierarchical entities based on Relationship to UDF via LINQ?

Posts   
 
    
pat
User
Posts: 215
Joined: 02-Mar-2006
# Posted on: 25-Mar-2009 03:10:14   

Hi,

I build a workaround which was dependent on overriding OnFetchEntityCollection in the DataAccessAdapter and then manipulating the generated SQL http://llblgen.com/TinyForum/Messages.aspx?ThreadID=11573

This works fine in LLBLGen 2.6 but it doesn't work with LINQ as the method is not called. What would I need to override with LINQ to LLBLGen to allow me to manipulate the generated SQL please?

Thanks, Patrick

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 25-Mar-2009 03:58:20   

Hi Patrick,

Did you try with Function mappings?

David Elizondo | LLBLGen Support Team
pat
User
Posts: 215
Joined: 02-Mar-2006
# Posted on: 02-Apr-2009 20:21:05   

daelmo wrote:

Did you try with Function mappings?

I would love to use them but function mapping only works with scalar values unfortunately not with with functions returning a table.

Thanks, Patrick

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 03-Apr-2009 11:13:19   

Table returning functions aren't supported at the moment, the main reason is that there's no facility to specify the layout of the table returned in a way that our query system will accept it.

The main reason for that is: what to do with a table being returned: is that the resultset or is that a variable (== single value)... the resultset route could be solved with additional code perhaps, the other one, not really...

Additionally, there's the problem with specifying mapping info for each column.

I also don't expect us writing support for this in the near future.

Frans Bouma | Lead developer LLBLGen Pro