Convert SQL Server query to LINQ lambda query for two different cols from two different table that are related

Question

I have two tables TABLE_A and TABLE_B which are related.

I need to convert this SQL Server query to a LINQ lambda query in C#:

SELECT a.COL1, a.COL2, b.COL2
FROM TABLE_A a, TABLE_B b
WHERE b.COL1 = A.COL3

Actually b.col1 is pk in table_b and a.col3 is fk of that in table_a

Generally, a "please write my code for me" type of question is considered off-topic here. You should include your attempt(s) so users can help you improve on them. — Jacob H
– Jacob H, Commented Apr 30, 2018 at 17:01
Probably, these might help you stackoverflow.com/questions/17638625/… stackoverflow.com/questions/24197602/… stackoverflow.com/questions/3854146/… — mallela prakash
– mallela prakash, Commented Apr 30, 2018 at 17:01
@JacobH thank you for tip and respond ... but unfortunately in this case i have no idea how to start ..... im new in linq query ..i have done some things but not different cols from different tables — Rouzbeh Zarandi
– Rouzbeh Zarandi, Commented Apr 30, 2018 at 17:28

dani herrera · Accepted Answer · 2018-04-30 17:06:33Z

1

table_a.Select( a=> new {a.COL1 , a.COL2 , a.b.COL2} )

Also, you can learn how to write better questions at "How to create a Minimal, Complete, and Verifiable example" I suggest to you to read post carefully.

answered Apr 30, 2018 at 17:06

dani herrera

52.1k11 gold badges133 silver badges188 bronze badges

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

1 Comment

so how to define that a.b.col2 is for table_b and apply condition on col of table_b ... this is where i confused

grishma shah · Accepted Answer · 2018-04-30 21:51:32Z

0

var q = (from a in table_A join b in table_B on b.col1 equals a.col3 select new {a.COL1, a.COL2, b.COL2}).ToList();

answered Apr 30, 2018 at 21:51

grishma shah

455 bronze badges

OP asked for 'LINQ lambda query'