Click here to Skip to main content
15,790,267 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Guys,

I am doing MVC Coding and using LLBLGEN Pro 3.5 version with it. I am using repository pattern and kind of need some guidance:

I have this code which returns me an IEnumerable(of T)

_repositoryExtMailCost.FindByCondition(Function(x) x.EndDate Is Nothing Or x.EndDate >= DateTime.Now)

The result contains a foreign key that i need to use to filter the results on the other table like this

_repositoryExtMailItem.FindByCondition(Function(x) x.ID ----)

this findbycondition is a custom function and takes a func(of t, boolean). now i want to use the result (foreign key) returned in the first statement and then apply that in the last statement but i am not sure how can i do that? Can you guys help?

Is there something similar to Entity Framework or LINQ To SQL like i can use Table joins and then say this foreign key is primary key of the other table and so give me all the results where primary key is in the list?

Thanks Guys.
Updated 11-Oct-12 18:15pm

1 solution

You need some reading on how to use joins using LINQ for that you may go up with this.

Additional links:

Linq to SQL Tutorial[^]

Linq to Entities[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900