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 = AccessIPAddres
Angular, React, JavaScript, Java, PHP, SQL, C#, Vue, NodeJs, TypeScript and Interview Questions Answers