public static void ClearDataTables(this IDbContextCore context, params string[] tables)
{
if (tables == null)
{
var tableList = new List <string>();
var types = context.GetAllEntityTypes();
if (types.Any())
{
foreach (var type in types)
{
var tableName = type.ClrType.GetCustomAttribute <TableAttribute>()?.Name;
if (tableName.IsNullOrWhiteSpace())
{
tableName = type.ClrType.Name;
}
tableList.Add(tableName);
}
}
else
{
tableList.AddRange(context.GetCurrentDatabaseTableList().Select(m => m.TableName));
}
tables = tableList.ToArray();
}
var sql = new StringBuilder();
foreach (var table in tables)
{
sql.AppendLine($"delete from {table};");
}
context.ExecuteSqlWithNonQuery(sql.ToString());
}
public int AddBySql(string sql)
{
return(DbContext.ExecuteSqlWithNonQuery(sql));
}
public int AddBySql(string sql, bool useTran = false)
{
return(DbContext.ExecuteSqlWithNonQuery(sql));
}
public void ExecuteSql(string sql)
{
DbContext.ExecuteSqlWithNonQuery(sql);
}