how to get value from var in linq

Question

var teamDetails = from m in db.con_teamdetails where m.tea_teamname == User select m.tea_id;var teamDetails = from m in db.con_teamdetails where m.tea_teamname == User select m.tea_id;

how to get value from teamdetails which means tea_id

Apurva · Answer

You can use: var tea_id = db.con_teamdetails.Where(x=>x.tea_teamname == User).Select(x=>x.tea_id).ToList();

Govinda Rajulu Yemineni · Answer

Hi sreepathy var query = from c in customers join o in orders on c.ID equals o.ID select new { c.Name o.Product }; just assume that the above query returns some records( Name and Product) to display that htose records use this foreach (var group in query) { Console.WriteLine({0} bought {1} group.Name group.Product); } result: Sam Book Dave Game Julia Computer

Ramesh Maruthi · Answer

Hi Prabhu 1) If you want to get the Id directly from db context use this : var teamDetails = db.con_teamdetails.where(x =>x.tea_teamname ==User).Select(y =>y.tea_id); you can use linq foreach teamDetails.ToList().ForEach(i => i.y.tea_id); Or else as @ Nanhe Siddique code you can do foreach loop for var items and get the value.

Nanhe Siddique · Answer

hi pabhu foreach(var v in teamDetails ) { //here you can read by v.tea_id int a=v. tea_id ; } i think it may help you

Shuvojit Halder · Answer

var teamDetails =db.con_teamdetails.where(m=>m.tea_teamname == User).firstorDeafult(); var teaid= teamDetails.tea_id;