`IDENTITY_INSERT` is a Sql Server database option which permits values for an identity column on a table to be explicitly specified during an Insert operation.
I've searched for this, but threads in which it appeared tended to have answers from people who didn't understand the …
sql sql-server identity-insertI am using the SqlBulkCopy object to insert a couple million generated rows into a database. The only problem is …
c# sql-server sqlbulkcopy identity-insertFor a sql script I'm working on, I need to programmatically remove the identity, identity seed, and identity increment for …
sql-server identity-insertI have a SQL Server database. This database has a table called Item. Item has a property called "ID". ID …
c# .net linq-to-sql identity-insertI recently migrated from a PostgreSQL database to a SQL Server database. To switch the data over I had to …
sql-server identity identity-insertWhat I need to do is have a SET IDENTITY_INSERT dbo.myTable ON statement, what's the syntax of using …
c# sql-server identity-insertI'm using Linq to SQL. I have a DataContext against which I am .SubmitChanges()'ing. There is an error inserting …
c# linq linq-to-sql identity-insertThis is the query: using (var db = new AppDbContext()) { var item = new IdentityItem {Id = 418, Name = "Abrahadabra" }; db.IdentityItems.Add(item); …
c# entity-framework entity-framework-6 identity-insertI'm trying to insert records in a table that has got an identity column. For various reasons, this should not …
sql insert identity-insertI am trying to create a record in the db that has a predefined primary key value. I know how …
entity-framework identity-insert