public static async Task TruncateAsync(DbContext context, TableInfo tableInfo) { string providerName = context.Database.ProviderName; // -- SQL Server -- if (providerName.EndsWith(DbServer.SqlServer.ToString())) { await context.Database.ExecuteSqlRawAsync(SqlQueryBuilder.TruncateTable(tableInfo.FullTableName)); } // -- Sqlite -- else if (providerName.EndsWith(DbServer.Sqlite.ToString())) { context.Database.ExecuteSqlRaw(SqlQueryBuilder.DeleteTable(tableInfo.FullTableName)); } else { throw new SqlProviderNotSupportedException(providerName); } }