how to get value from var in linq

sreepathy s prabhu

11y1.5kLINQ

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Govinda Rajulu Yemineni11y ago
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

0
Apurva11y ago
You can use:
var tea_id = db.con_teamdetails.Where(x=>x.tea_teamname == User).Select(x=>x.tea_id).ToList();
0
Ramesh Maruthi11y ago
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 Siddiquecode you can do foreach loop for var items and get the value.
0
Nanhe Siddique11y ago
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
0
Shuvojit Halder11y ago
var teamDetails =db.con_teamdetails.where(m=>m.tea_teamname == User).firstorDeafult(); var teaid= teamDetails.tea_id;
0