auto generate in LINQ to SQL

Question

hi.

I have a table whit 2 columns , ID and name .I set 'YES' Identity for ID column .

I want to insert data to table whit LINQ .I want to get only name column from user in my application , and then ID column fill automatic to database and I can't give data that column and fill whitout I give it .

What should I do ?

I write in c# and work whit LINQ .

Answer 1

If you used the DBML designer, that should be setup correctly.

The 'id' will be populated after you call SubmitChanges.

Answer 2

Make sure your database table is setup correctly and that your ID is set as the primary key field and to auto increment. Regenerate your DBML if you need to by deleting the object and re-adding it. It should know that the ID is not needed adn the auto fill it once the insert has succeeded.