using WeApp.EF;

namespace WeApp.SeedData
{
    public static class ExecuteSql
    {
        public static void TruncateTable(this WeAppDbContext context, string tableName)
        {
            if (string.IsNullOrEmpty(tableName))
            {
                return;
            }
            var sql = $"TRUNCATE TABLE {tableName}";
            context.Sql(sql);
        }
        public static void Sql(this WeAppDbContext context, string sql)
        {
            if (string.IsNullOrEmpty(sql))
            {
                return;
            }
            context.Database.ExecuteSqlCommand(sql);
        }
    }
}