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.
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 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..
|