Table1 ID Legal Name TypeFK. 1 S1 2 2 S2 1 Table2 ID Type Name 1 type1 2 type2 Required Result ID Legal Name Type Name 1 S1 type2 2 S2 type1 how to use linq to get this ans...
var query = from t1 in db.Table1 join t2 in db.Table2 on t1.ID equals t2.ID select new { t1.ID, t1.LegalName, t2.TypeName}
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)