python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language

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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions