Linq To Sql - SQL Default Constraint Problem

Question

I have a USER table in database. The table has a RegistrationDate column which has a default constraint as GETDATE().

When using LINQ, I don't provide any data for RegistrationDate column to make it default. But SQL Server raises error. I think LINQ tries to insert NULL into the column.

How can I make LINQ not to try to insert in the column RegistrationDate, because it has default value?

Oleks · Accepted Answer · 2010-04-30 10:26:07Z

13

Set Auto Generated Value property to true in the designer.

Or IsDbGenerated="true" in .dbml file.

answered Apr 30, 2010 at 10:26

Oleks

32.4k11 gold badges80 silver badges134 bronze badges

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

Comments

leppie · Accepted Answer · 2010-04-30 10:24:05Z

0

I am not 100% sure, but you could make the property read-only in the DBML designer.

answered Apr 30, 2010 at 10:24

leppie

118k18 gold badges201 silver badges300 bronze badges

Collectives™ on Stack Overflow

Linq To Sql - SQL Default Constraint Problem

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related