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();

              }  

  }