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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.