i am new to linq to sql

[ravindarjobs]

Hi friends

i am using Linq to sql
and my code is

 
public class AccountSettings
    {
       NewCustomerDataContext _dbAccounts = new NewCustomerDataContext();
 
 
       public int UpdateAccountSettigs(int iUserLoginID,string strUserMailID, string strPassword)
       {
 
           var UpdateUser = _dbAccounts.UserLoginInfs.Single(e => e.UserLoginInfID == iUserLoginID);
 
 
 
           UpdateUser.UserMailID = strUserMailID;
           UpdateUser.Password = strPassword;
           _dbAccounts.SubmitChanges();
 
 
 
 
 
       }
    }
 

at the code

var UpdateUser = _dbAccounts.UserLoginInfs.Single(e => e.UserLoginInfID == iUserLoginID);

if no records are there with that criteria i am getting error.
so how do i validate this?

With earlier technology, when no records are found, we used to get 0 or something.

but how do we handle it in this case


also after executing
_dbAccounts.SubmitChanges();
how do i confirm that the update is success?
its return type is void
so how do i capture the result


thank you
Ravindar

[Curtis Rutland]

There are two ways of going about this.
You could use a try/catch:

try
{
  var UpdateUser = _dbAccounts.UserLoginInfs.Single(e => e.UserLoginInfID == iUserLoginID);
}
catch (Exception ex) //change this to the exact exception thrown
{
  //exception handling here
}

Or you could do a count before you do your select:

var UpdateUser;
if(_dbAccounts.UserLoginInfs.Count(e => e.UserLoginInfID == iUserLoginID) > 0)
  UpdateUser = _dbAccounts.UserLoginInfs.Single(e => e.UserLoginInfID == iUserLoginID);
else
  //exception handling here

As to the last question, it will throw an error if unsuccessful. So you should probably catch that error and do something if it fails.