Retrieve from multiple tables and update with LINQ

Question

How to implement with ***LINQ to update whole record to database.

Please note everybody, I want to but edit button link in gridview and if I click link , I want to update my whole record to database.

In one row of gridview , there are retrieved from multiple tables. Not only one table.

If possible please help me in this problem as soon as possible.

Thanks a lot for viewing my post :-)

Shuvojit Halder · Answer

You can use in your link button click event. public void updateShoes ( Shoe shoe ) { var query = from b in db . BrandTbls . AsQueryable () join m in db . ShoeModelTbls on b . BrandID equals m . BrandID join s in db . ShoeTbls on m . ModelID equals s . ModelID where shoe . ShoeID == s . ShoeID orderby m . ModelName select new { Shoe = shoe  Brand = b  Model = m }; foreach ( var o in query ) { o . Shoe . ColorName = Black ; o . Brand . BrandName = New Branding ; o . Model . ModelName = Something else ; } db . SaveChanges (); }