How to add Timestamp value in SQL database by using LINQ

Question

My database table have a Timestamp column and i am using LINQ for insert, update data in SQL database. Now i want to add the timestamp value in my database but i don't know how?

I seems various examples on net and they didn't write any code for inserting value in database it automatically inserted on insertion data. while i saw in the table there is also no default value assign then how timestamp insert into database by uisng LINQ??

Randy Minder · Accepted Answer · 2011-07-07 12:15:03Z

1

I assume you mean that you have a table with a column that has a Timestamp data type. My answer assumes this is what you mean.

You do not provide values for columns with a Timestamp (Rowversion) data type. SQL Server will provide a value for you automatically (and it won't be a datetime value). Therefore you do not need to be concerned with having Linq To SQL insert a Timestamp value for you. In fact, you cannot do it. SQL Server will do it for you. You can however, retrieve the value of a Timestamp column. I believe the corresponding C# type will be System.Data.Linq.Binary.

answered Jul 7, 2011 at 12:15

Randy Minder

48.8k56 gold badges222 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Randy Minder Over a year ago

@Gaurav - I don't know, but why would you want to do this? This column simply contains an internal (to SQL Server) row version number for concurrency purposes. You shouldn't need or care to know what this value is. L2S can use it for concurrency checking however.

Muhammad Adeel Zahid · Accepted Answer · 2011-07-07 10:51:10Z

0

for example you have following model class creted for Table User

public partial class User
{
    public int UserID{get;set;}
    public string UserName{get;set;}
    public DateTiem TimeStamp{get;set;}
}

you can write something like

User user = new User{UserName = "xyz", TimeStamp = DateTime.Now};
MyDataContext context = new MyDataContext();
context.Users.InsertOnSubmit(user);
context.SubmitChanges();

answered Jul 7, 2011 at 10:51

Muhammad Adeel Zahid

17.8k16 gold badges95 silver badges160 bronze badges

6 Comments

Gaurav Agrawal Over a year ago

but in many examples timestamp value inserted automatically. How?

Simon Halsey Over a year ago

If you wanted to be clever, you could implement INotifyPropertyChanged and have the properties update the TimeStamp when they change rather doing it by hand

Simon Halsey Over a year ago

Could be a trigger in the SQL Server?

Muhammad Adeel Zahid Over a year ago

@Guarav i normally set default value of TimeStamp to getdate() or similar function in sql server and then if you do not provide an explicit value, default value is used instead

Gaurav Agrawal Over a year ago

I checked this but in LINQ Timestamp SQL datatyper converts into System.Data.Linq.Binary in c# LINQ so how would be we can use Datetime here???

|

Collectives™ on Stack Overflow

How to add Timestamp value in SQL database by using LINQ

2 Answers 2

1 Comment

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related