DateTime Insert via LINQ

Question

I have a column in my table which has a DataType of 'timestamp'. Now I am inserting a row through LINQ2SQL. Now what should I write here:

Entity_Product_Point ev = new Entity_Product_Point();
ev.DateCreated = ???

Thanks!

Do you mean SQL server `timestamp`? That really has very little to do with time... — Marc Gravell, Apr 07 '11 at 19:33
So what should be the datatype if I want the time and date to be inserted? — RG-3, Apr 07 '11 at 19:40
NET-SLUT (fun to type!), you want DateTime as mentioned below. — Pete M, Apr 07 '11 at 19:43

Pete M · Accepted Answer · 2011-04-07T19:48:54.950

5

Are you SURE you wanted timestamp? It has nothing to do with dates... If you'd like to store "DateCreated", I think you probably want to use either a DateTime or just Date datatype in MSSQL. If that's what you really intended, then you can pass in DateTime.Now for a value.

edited Apr 07 '11 at 19:48

answered Apr 07 '11 at 19:35

Pete M

2,008
11
17

easiest +4 you'll ever get hah – Jack Marchetti Apr 07 '11 at 20:01

score 2 · Answer 2 · edited May 23 '17 at 12:11

2

Well the corresponding type would be byte[], but this type is used internally by SQL Server for row versioning—and by ORMs for optimistic locking. You should never (can't) write a value out for a timestamp column manually.

For a more complete listing of which type correspond to what, check out this question

edited May 23 '17 at 12:11

Community

1
1

answered Apr 07 '11 at 19:34

Adam Rackis

82,527
56
270
393

DateTime Insert via LINQ

2 Answers2