Getting value from VAR

Question

For the following code

var validate = from P in this.DataContext.Persons
                         where P.UserName.Equals(login) && P.Password.Equals(password)
                         select new
                         {
                             P.FirstName,
                             P.LastName,
                             P.EmailAddress
                         };

If record exists i want to get the first name and return it. How can i get the firstName from var validate?

Answer 1

validate here is going to be a set (IQueryable<T>) of data. You may need to use FirstOrDefault(), for example:

var record = validate.FirstOrDefault();
if(record != null) {
    string firstName = record.FirstName;
}

Answer 2

Console.WriteLine(validate.FirstOrDefault().FirstName);

Otherwise you'll have to loop through the set since that what your query is returning Likely a set of one but it's still a set.

Answer 3

Try the following:

var validate = (from P in this.DataContext.Persons
                where P.UserName.Equals(login) && P.Password.Equals(password)
                select new
                {
                  P.FirstName,
                  P.LastName,
                  P.EmailAddress
                }).FirstOrDefault();

if (validate != null) 
{ 
  var firstName = validate.FirstName;
  ...
}