Here is a good example for creating a left outer join in LINQ for entities;<\/p>\n
var myQuery = (from x in db.tAXModelKitXref\r\n join p in db.vPRODUCTSTKDBs on x.ProdCode equals p.ProdCode into kits let k = kits.FirstOrDefault()\r\n orderby x.UniqueId\r\n select new\r\n {\r\n UniqueId = x.UniqueId,\r\n ProdCode = x.ProdCode,\r\n ProdCodeDesc = k.ProdCodeDesc, \r\n KitCode = x.KitCode,\r\n KitCodeDesc = \"\",\r\n ModelKitStatus = x.ModelKitStatus,\r\n ModelKitNotes = x.ModelKitNotes\r\n }).ToList();<\/pre>\n <\/p>\n
If you need to perform other queries to get extra data for your main query list, first perform your main query first and convert the results to a list (see above query). You can then perform extra queries on this list to populate more fields. (see query below).<\/p>\n
var myResults = (from items in myQuery\r\n select new\r\n {\r\n items.UniqueId,\r\n items.ProdCode,\r\n items.ProdCodeDesc,\r\n items.KitCode,\r\n KitCodeDesc = ((from k in db.tCARKITS where k.KitCode.Equals(items.KitCode) select new { KitCodeDesc = k.KitCodeDesc }).FirstOrDefault() == null ? \"\" : (from k in db.tCARKITS where k.KitCode.Equals(items.KitCode) select new { KitCodeDesc = k.KitCodeDesc }).FirstOrDefault().KitCodeDesc ),\r\n items.ModelKitStatus,\r\n items.ModelKitNotes\r\n }).ToList();<\/pre>\n <\/p>\n
Then just do this to display the results onto a grid;<\/p>\n
MainGrid.DataSource = myResults;\r\n foreach (Telerik.WinControls.UI.GridViewDataColumn cols in MainGrid.Columns)\r\n cols.BestFit();<\/pre>\n","protected":false},"excerpt":{"rendered":"Here is a good example for creating a left outer join in LINQ for entities; var myQuery = (from x in db.tAXModelKitXref join p in db.vPRODUCTSTKDBs on x.ProdCode equals p.ProdCode into kits let k = kits.FirstOrDefault() orderby x.UniqueId select new … Continue reading