update query in linq to sql

Hi Everyone,

I'm going to share the code sample for update query in linq to sql in c# asp.net

Today, I have a requirement to update the log details in the DB with respect to the UserId.

 /// <summary>

 /// Update to user device access log table using linq to sql in c# .net

 /// </summary>

 using (ExceptionLogDataContext dbContext = new ExceptionLogDataContext())

 {           

     if (!string.IsNullOrEmpty(UserId))

     {           

        var IsExistedUser = (from user in dbContext.UserDeviceAccessLogs

              where user.UserId == Convert.ToInt32(UserId)

              select user).FirstOrDefault();

        if (IsExistedUser.UserId != null)

        {

                  IsExistedUser.CreatedDate = DateTime.UtcNow;

                  IsExistedUser.DeviceType = DeviceType;

                  IsExistedUser.LastAccessed = DateTime.UtcNow;

                  IsExistedUser.LatestAccessIP = AccessIPAddress; 

               

                  dbContext.SubmitChanges();

         }

     }

 }