forum

Home / DeveloperSection / Forums / How to update Linq different table after join process

How to update Linq different table after join process

Norman Reedus 1953 29-Jan-2015

I have combined 3 of my tables by using linq join. After that i want to update this table by using data that i get from webform. How can i do this ? My implementation is below

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
                {
                    s.ShoeID,
                    s.Size,
                    s.PrimaryColor,
                    s.SecondaryColor,
                    s.Quantity,
                    m.ModelName,
                    m.Price,
                    b.BrandName
                };
}


Updated on 29-Jan-2015

Can you answer this question?


Answer

1 Answers

Liked By