can someone tells me what is .First ?

Question

Hi experts,

I have this rather stupid question yet I duno the answer. Hope someone can let me know the answer :

public AzolaDL.Account getAccount(string userName, string type){
AzolaDL.Account account = new AzolaDL.Account();
try{
account = db.Accounts.First(e => e.userName == userName && e.type == type);
}catch (Exception e){
return null;
}
return account;
}

Can I know why do we need to put .First ?

Tapan Patel · Answer

Without LINQ, foreach (var item in db.Accounts) { if (item.userName==userName && item.type==type) { account=item; break ; } } if (account== null ) return null ; else return account;

Tangara G · Answer

Thank you Tapan. This LINQ is really mysterious....

Tangara G · Answer

Tks Mihun and Vasu for clarifying my doubt. I had no idea that statement I had doubt is a LINQ.... Wonder if it is possible not to use LINQ and we can get the same result also ?

Vasu Gadhiya · Answer

as Midhun T Tp Says first() return first element from result of expression but if you dont want to raise Exception than use .FirstOrDefault() function instead of using .First() ---------------------------------------------- try { account = db.Accounts.where(e => e.userName == userName && e.type == type).FirstOrDefault(); if(account == null) { // consider that your account is null } else { // your account object have some data } } catch { }

Midhun Tp · Answer

Hi Karen, First() returns the first element from the result of expression. If there is no record corresponding to the expression, First() method will throw an exception. Just go through below links for more details - https://msdn.microsoft.com/en-us/library/bb291976(v=vs.110).aspx http://www.c-sharpcorner.com/blogs/difference-between-first-and-firstordefault-in-linq1

Mark Tabor · Answer

I think google can assists you batter its not an issue to define some thing :) happy Googling

can someone tells me what is .First ?

Answers (6)