insert query in linq to sql in c#

Hi Everyone,

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

Today, I have a requirement to insert the log details in the DB using asp.net, entity framework and c# as well.


/// <summary>
/// Insert the user device logs details using to linq to sql with c# .net
/// </summary>
using (ExceptionLogDataContext dbContext = new ExceptionLogDataContext())
{           
            if (!string.IsNullOrEmpty(UserId))
            {           
                 // create the table object.
                  UserDeviceAccessLog AccessLog = new UserDeviceAccessLog();

                  AccessLog.CreatedDate = DateTime.UtcNow;
                  AccessLog.UserId = Convert.ToInt32(UserId);
                  AccessLog.ApplicationVersion = "5S.1.0";
                  AccessLog.AppName = "DempApp";
                  AccessLog.DeviceId = "iPhone";
                  AccessLog.DeviceType = DeviceType;
                  AccessLog.LastAccessed = DateTime.UtcNow;
                  AccessLog.LatestAccessIP = AccessIPAddress;

                 // Insert the table object.
                  dbContext.UserDeviceAccessLogs.InsertOnSubmit(AccessLog);

                  //Submit changes to the db context.
                  dbContext.SubmitChanges();
              }  
  }









ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^