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(); 

Answer 1

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.