public Form_Request_GuidSetIdentityFields() { InitializeComponent(); var connection = (EffortConnection)DbConnectionFactory.CreateTransient(); // MUST initialize first with the context with identity (Required for SetIdentityFields(false) using (var context = new EntityContext(connection)) { context.Database.CreateIfNotExists(); } // MUST open connection first (Required for SetIdentityFields(false) connection.Open(); connection.DbManager.SetIdentityFields(false); connection.Close(); // SEED using (var context = new EntityContextNoIdentity(connection)) { //context.EntitySimples.Add(new EntitySimple { Id = 10, ColumnInt = 1 }); //context.EntitySimples.Add(new EntitySimple { Id = 11, ColumnInt = 2 }); //context.EntitySimples.Add(new EntitySimple { Id = 12, ColumnInt = 3 }); context.EntitySimples.Add(new EntitySimple { Id = new Guid("0FA0F3D7-57CB-42BB-819A-BB9C4D0645CC"), ColumnInt = 1 }); context.EntitySimples.Add(new EntitySimple { Id = new Guid("C3E9517D-B444-4F56-B459-5B9804C03FE1"), ColumnInt = 2 }); context.EntitySimples.Add(new EntitySimple { Id = new Guid("A02E175C-C050-4996-AD42-B722BE1E7FF1"), ColumnInt = 3 }); context.SaveChanges(); } // MUST open connection first (Required for SetIdentityFields(false) connection.Open(); connection.DbManager.SetIdentityFields(true); connection.Close(); // TEST using (var context = new EntityContext(connection)) { context.EntitySimples.Add(new EntitySimple() { ColumnInt = 4 }); context.SaveChanges(); var list = context.EntitySimples.ToList(); } }
public Form_Request_Identity() { InitializeComponent(); var connection = (EffortConnection)DbConnectionFactory.CreateTransient(); // MUST initialize first with the context with identity (Required for SetIdentityFields(false) using (var context = new EntityContext(connection)) { context.Database.CreateIfNotExists(); } // MUST open connection first (Required for SetIdentityFields(false) connection.Open(); connection.DbManager.SetIdentityFields(false); connection.Close(); // SEED using (var context = new EntityContextNoIdentity(connection)) { context.EntitySimples.Add(new EntitySimple { ID = -44, ColumnInt = 1 }); context.EntitySimples.Add(new EntitySimple { ID = -4, ColumnInt = 2 }); context.EntitySimples.Add(new EntitySimple { ID = -5, ColumnInt = 3 }); context.SaveChanges(); } // MUST open connection first (Required for SetIdentityFields(false) connection.Open(); connection.DbManager.SetIdentityFields(true); connection.Close(); // TEST using (var context = new EntityContext(connection)) { context.EntitySimples.Add(new EntitySimple() { ColumnInt = 4 }); context.EntitySimples.Add(new EntitySimple() { ColumnInt = 4 }); context.SaveChanges(); var list = context.EntitySimples.ToList(); } }