CODEWITHSUNDEEP
c#.netsql-serverlinq-to-sql
KyelJmD
KyelJmD

Reputation: 4732

Linq-to-SQL seeing if the are no results

How come my code is showing a syntax error on this block of code

public string getPassword()
{
   DataClasses1DataContext myDbContext = new DataClasses1DataContext(dbPath);

   var password = (from user in myDbContext.Accounts
                   where user.accnt_User == txtUser.Text
                   select user.accnt_Pass).First();

   if (password == 0) 
   { }

   return password;
}

I want to know if the result of query is 0, if it is 0 I will close the operation or something like that. but It keeps showing an error how would I know if the result is 0? also if you have suggestions regarding my approach feel free to put it in

Upvotes: 2

Views: 747

Answers (1)

marc_s
marc_s

Reputation: 754230

Calling .First() will result in an exception if there is no data returned...

Calling .FirstOrDefault() will return null if there is no data

public string getPassword()
{
   DataClasses1DataContext myDbContext = new DataClasses1DataContext(dbPath);

   var password = (from user in myDbContext.Accounts
                   where user.accnt_User == txtUser.Text
                   select user.accnt_Pass).FirstOrDefault();

   if (password == null) 
   {
      // no data found - do whatever is needed in that case...
   }

   return password;
}

Upvotes: 4

Related Questions