Silverlight Data Grid - Binding Data using WCF and LINQ to SQL Classes

[computerboy86031]

var ProductList = from TBLP in objEntityClass.tblProducts join TBLB in objEntityClass.tblBusinesses on TBLP.BusinessID equals TBLB.BusinessID join TBLI in objEntityClass.tblImageFiles on TBLP.ProductID equals TBLI.ProductID into TBLP_TBLI where (TBLP.Status == 'A' && BusienssID.Contains(TBLB.Busin­essID)) from TBLI in TBLP_TBLI.DefaultIfEmpty() select new { TBLP.Product, TBLP.ProductID, TBLP.Description, };

[computerboy86031]

Hi Thank you so much. It is so help full. now i have one problem i want to use query with joins of multiple tables so please help me or please suggest me any link of your video. here is my query sample.

var ProductList = from TBLP in objEntityClass.tblProducts

where (TBLP.Status == 'A' && BusienssID.Contains(TBLB.Busin­essID)) from TBLI in TBLP_TBLI.DefaultIfEmpty() select new { Product=TBLP.Product };

[adikamin22]

Your tutorial has untangled the confusion and difficulty cluster that i was facing for the past 4 days!! Thank you so so so so very much !!! Love you and god bless :D

[adikamin22]

Thank you sooooooooooooooooooooooooooooo­ooooooooooooo MUCH!!!!!!!!!!