Entity framework how to reset auto_increment
private static ContextName getContext()
{
var contextOptions = new DbContextOptionsBuilder<ContextName>()
.UseSqlServer("ConnectionString")
.Options;
return new ContextName(contextOptions);
}
//This is ran somewhere, I run mine in Main in its own seeder program
public void SeedData()
{
var context = getContext();
context.Database.EnsureCreated();
context.DbSet.RemoveRange(context.DbSet.ToList());
context.Database.ExecuteSqlRaw("DBCC CHECKIDENT('table.path', RESEED, 0)"); //Reset AUTO_INCREMENT
context.PricePageDatas.AddRange(_someCollection); // This comes from a modified list of what you want to poopulate database with
context.SaveChanges();
}
Are there any code examples left?
New code examples in category C#
-
C# 2022-03-27 22:40:23 c# movement script
-
C# 2022-03-27 22:15:17 Delete last modification on EntityFramework Core
-
C# 2022-03-27 22:15:02 file.create folder c#
-
C# 2022-03-27 19:25:04 Error inflating class android.support.constraint.ConstraintLayout
-
C# 2022-03-27 19:15:02 top down shooting in unity 2D
-
C# 2022-03-27 18:50:02 c# remove invalid directory characters
-
C# 2022-03-27 18:30:07 how to use K2 games Games parallax background
-
C# 2022-03-27 18:25:10 c# replace crlf
-
C# 2022-03-27 18:25:09 keycode for left mouse click unity