How do I use Linqpad to insert record with specified primary key?

Question

So when I run the following, the role is inserted but the ID column is auto generated. How do I stop this from happening when using Linqpad?

Roles.InsertOnSubmit(new Role(){ID = 26, Name = "TheRole", Created = DateTime.Now, Updated = DateTime.Now});    
SubmitChanges();

I was looking for the function name, got from your question. Thanks — FindOutIslamNow, Aug 27 '18 at 11:26

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

2

The ID column is set to AUTO INCREMENT in database, you can't override that from LINQ, you have to modify your database table schema to remove AUTO INCREMENT from table.

You can also enable IDENTITY_INSERT if you are using ADO.Net, see this question for related SQL details.

edited May 23 '17 at 11:51

Community

1
1

answered Aug 23 '13 at 15:49

Habib

219,104
29
407
436

How do I use Linqpad to insert record with specified primary key?

1 Answers1