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

In this video, we'll tak a look at how to access SQL Data using a WCF Web Service; retrieve data using LINQ, and display it using the AgDataGrid control.

Category:

Science & Technology

Tags:

• Developer
• Express
• Microsoft
• Visual
• Studio
• .NET
• C#
• VB.NET
• Basic
• DevExpress
• Control
• Components
• Software
• Tools
• Development
• Application
• Windows
• IDE
• CLR
• Framework
• UI
• User
• Interface
• DXperience
• Tutorial
• Training
• Video
• Screencast
• Code
• Silverlight
• Data
• Grid
• Bind
• WCF
• LINQ
• SQL

[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!!!!!!!!!!