i am new to linq to sql

ravindarjobs

Hi friends

i am using Linq to sql
and my code is

Expand|Select|Wrap|Line Numbers

  
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

insertAlias

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

Expand|Select|Wrap|Line Numbers

 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:

Expand|Select|Wrap|Line Numbers

 
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.

i am new to linq to sql

re: i am new to linq to sql

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about