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);
}
}