SQL GETDATE() in insert operations using Linq To Sql

Question

Say i have the following table:

create table T (
    ID int not null primary key,
    Name varchar(10) not null,
    CreatedAt datetime not null default GETDATE(),
    UpdatedAt datetime not null default GETDATE()
)

and want to use with Linq 2 Sql. It perfectly generates type safe class with both CreatedAt and UpdatedAt properties non-nullable. Now i want to insert a new entry and want them both to be populated by a value from Sql Server, not with DateTime.Now which may differ. Is there a way to somehow send null to Sql Server without making the properties nullable? Also, i don't want to follow this solution as it requires additional network trip. It's very easy with good old SQL - just omit CreatedAt/UpdatedAt columns in the insert statement and you're fine but what are my options with Linq 2 Sql?

Once you've solved your insert issue, you're likely to stumble when you want UpdatedAt to be set to GETDATE() on each subsequent update. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jun 23, 2011 at 7:02
You're right. Possible solution can be completely ignoring values sent from clients and use triggers. — UserControl
– UserControl, Commented Jun 23, 2011 at 7:11
The accepted answer here may be a suitable workaround for you. — Stephen Kennedy
– Stephen Kennedy, Commented Jul 11, 2011 at 19:34
No, it works with select queries only. I tried it and saw that for insert operations it generates extra trip to the server. — UserControl
– UserControl, Commented Jul 12, 2011 at 3:36

DSharper · Accepted Answer · 2011-06-23 06:17:16Z

1

Can you check this link. there is a attribute called IsDbGenerated which can be annotated with your LINQ partial classes.

http://msdn.microsoft.com/en-us/library/system.data.linq.mapping.columnattribute.isdbgenerated.aspx#Y456

edited Jun 23, 2011 at 6:17

answered Jun 23, 2011 at 6:01

DSharper

3,2279 gold badges32 silver badges47 bronze badges

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

1 Comment

UserControl Over a year ago

Wow! I'm giving it a try (need to find out how to automate this)

Collectives™ on Stack Overflow

SQL GETDATE() in insert operations using Linq To Sql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related