Can't insert NULL value after db export

Question

this is my problem. i changed db position, first it was on an external server and i exported it on my local position (./SQLEXPRESS) now i can't make insert record because it says that the record contain NULL id value. But it is correct because it is an auto-increment and i pass "0" or null for tell my db to insert a row (it is db.mytable.add(myrow) and it is the base behavior). why now it tells me to pass a row with setted id?

this is the simply code

db.Company.Add(company);
db.SaveChanges();

and it give error on SaveChanges

i think it is a db owner problem

From what type of external server (full instance, Azure) using what tool (SSIS, other)? — Marc L.
– Marc L., Commented Nov 1, 2012 at 14:50
i'm using EF, the serve is sql server 2008 r2. i used the tool inside sql managment studio, export database and i copied it inside my local — NinoEmma
– NinoEmma, Commented Nov 1, 2012 at 15:55

Rory McCrossan · Accepted Answer · 2012-12-10 16:20:50Z

2

You should check your DB again. Maybe the code is looking at the wrong DB, like dbo.YourDB instead of NinoEmma.YourDB. Because it can't find your DB, EF Code First will create one and the id column doesn't auto-increment anymore.

edited Dec 10, 2012 at 16:20

Rory McCrossan

338k41 gold badges322 silver badges353 bronze badges

answered Dec 10, 2012 at 15:57

windian

214 bronze badges

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

Collectives™ on Stack Overflow

Can't insert NULL value after db export

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related