Writing Join Query Using Linq In VB.net

Question

Im trying to convert a SQL Query to a linq query in vb. But Im have some trouble getting the syntax correct.

Original Query

SELECT b.* 
FROM History_Table_B b 
INNER JOIN Employee e ON b.EmployeeId = e.EmployeeId 
INNER JOIN Company c ON e.CompanyId = c.CompanyId 
WHERE e.AncillaryId = @AncillaryPersonId 
AND c.AncillaryId = @AncillaryCompanyId
AND (b.EndDate is null OR b.EndDate >= convert(date, GetDate()))

My Linq

Dim result = From b In context.H_Table_B
             Join employee In context.Employees
             On b.EmployeeId Equals (employee.EmployeeId)
             Join company In context.Companies
             On employee.CompanyId Equals (company.CompanyId) 
             Where employee.AncillaryId Equals(iPerId) 
             And company.AncillaryId Equals (iCompanyId) 
             And ((b.EndDate Is Nothing) Or (b.EndDate Equals(DateTime.Today)))

Jignesh Thakker · Accepted Answer · 2012-09-13 16:59:13Z

6

On where condition you can not use Equals (Operator) like Join LINQ query. Here Equals is a method of object class so you can access using '.' e.g. employee.AncillaryId.Equals(iCompanyId)

And Also one more thing in Where condition for new line VB.net required '_'.

e.g.

From b In context.H_Table_B
         Join employee In context.Employees
         On b.EmployeeId Equals (employee.EmployeeId)
         Join company In context.Companies
         On employee.CompanyId Equals (company.CompanyId) 
         Where employee.AncillaryId.Equals(iPerId) _ 
         And company.AncillaryId.Equals(iCompanyId) _
         And ((b.EndDate Is Nothing) Or (b.EndDate.Equals(DateTime.Today)))

edited Sep 13, 2012 at 16:59

answered Sep 13, 2012 at 16:42

Jignesh Thakker

3,7082 gold badges31 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave Doknjas · Accepted Answer · 2012-09-13 16:35:10Z

2

I think you're just missing a dot - try:

...b.EndDate.Equals(DateTime.Today)

answered Sep 13, 2012 at 16:35

Dave Doknjas

6,6001 gold badge20 silver badges35 bronze badges

Collectives™ on Stack Overflow

Writing Join Query Using Linq In VB.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related