Mixing LINQ and ol' fashioned Predicates

Posts   
 
    
worldspawn avatar
worldspawn
User
Posts: 321
Joined: 26-Aug-2006
# Posted on: 10-Jan-2011 10:25:51   

I'm using llbl 3.

If my initial query is in linq is there some way to tap into the provider to get the generated relation predicate bucket and add to it (mix linq with llbl queries). I ask this because I would like to append some common join on to my queries but I am finding that difficult to abstract in LINQ.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 10-Jan-2011 15:52:35   

Could you give an example code of what you need to apply?

worldspawn avatar
worldspawn
User
Posts: 321
Joined: 26-Aug-2006
# Posted on: 11-Jan-2011 00:02:59   

Like the query in this thread http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=19230

I want to join a query onto my ContextPermissions table to filter out records the user is not supposed to have access to.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 11-Jan-2011 12:37:05   

It's been requested before, but at this point it's not possible to do so. One of the main painpoints is aliasing, as linq queries use aliasing for entities everywhere, so when you add your own predicates you have to use the same aliases: problem is, you don't know them when you write your code.

Frans Bouma | Lead developer LLBLGen Pro