© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•16mo ago•
16 replies
Jiry_XD

Reset identity colums EF Core error.

Hi all,

This is my seeding method:
public async Task Seed()
{
    dbContext.Database.Migrate();

    string dbName = dbContext.Database.GetDbConnection().Database;
    if (!dbName.EndsWith("_Tests"))
    {
        var tableNames = dbContext.Model.GetEntityTypes()
                .Select(t => t.GetTableName())
                .Distinct()
                .ToList();



        tableNames.ForEach(tableName =>
        {

            dbContext.Database.ExecuteSqlRaw($"ALTER TABLE {tableName} NOCHECK CONSTRAINT ALL;");
        });

        tableNames.ForEach(tableName =>
        {
            dbContext.Database.ExecuteSqlRaw($"DELETE FROM {tableName};");
            dbContext.Database.ExecuteSqlRaw(
                            $"IF EXISTS (SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('{tableName}') AND is_identity = 1) " +
                            $"BEGIN DBCC CHECKIDENT ('{tableName}', RESEED, 0); END");
   

        });



        tableNames.ForEach(tableName =>
        {
            dbContext.Database.ExecuteSqlRaw($"ALTER TABLE {tableName} CHECK CONSTRAINT ALL;");
        });

        //Seed/insert data
        await SeedTable1();
        await SeedTable2();
        await SeedTable3();

    }
}
public async Task Seed()
{
    dbContext.Database.Migrate();

    string dbName = dbContext.Database.GetDbConnection().Database;
    if (!dbName.EndsWith("_Tests"))
    {
        var tableNames = dbContext.Model.GetEntityTypes()
                .Select(t => t.GetTableName())
                .Distinct()
                .ToList();



        tableNames.ForEach(tableName =>
        {

            dbContext.Database.ExecuteSqlRaw($"ALTER TABLE {tableName} NOCHECK CONSTRAINT ALL;");
        });

        tableNames.ForEach(tableName =>
        {
            dbContext.Database.ExecuteSqlRaw($"DELETE FROM {tableName};");
            dbContext.Database.ExecuteSqlRaw(
                            $"IF EXISTS (SELECT 1 FROM sys.columns WHERE object_id = OBJECT_ID('{tableName}') AND is_identity = 1) " +
                            $"BEGIN DBCC CHECKIDENT ('{tableName}', RESEED, 0); END");
   

        });



        tableNames.ForEach(tableName =>
        {
            dbContext.Database.ExecuteSqlRaw($"ALTER TABLE {tableName} CHECK CONSTRAINT ALL;");
        });

        //Seed/insert data
        await SeedTable1();
        await SeedTable2();
        await SeedTable3();

    }
}
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

EF core error
C#CC# / help
2y ago
✅ EF Core delete error
C#CC# / help
3y ago
EF Core
C#CC# / help
2y ago
✅ Adding EF Core Migration Error
C#CC# / help
4y ago