public static void Function(this IExecuteExpressionRoot execute, string functionName)
{
if (string.IsNullOrWhiteSpace(functionName))
{
throw new Exception($"Function name can't be null or empty");
}
var preScriptFunction = BasicScriptsResources.PreFunctionScript.Replace("#SCRIPT_NAME#", functionName);
var rm = FunctionResources.ResourceManager;
var script = rm.GetString(functionName);
if (string.IsNullOrWhiteSpace(script))
{
throw new Exception(
$"Function \"{functionName}\" not found in {FunctionResources.ResourceManager.BaseName}");
}
var finalScript = string.Concat(preScriptFunction, script);
execute.Sql(finalScript);
}
public static void SqlFormat(this IExecuteExpressionRoot execute, string format, params object[] args)
{
execute.Sql(string.Format(format, args));
}
public static void DropTableIfExists(this IExecuteExpressionRoot execute, string tableName)
{
execute.Sql(string.Format("IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '{0}')) BEGIN DROP TABLE [{0}] END", tableName));
}
public static void DropViewIfExists(this IExecuteExpressionRoot execute, string viewName)
{
execute.Sql(string.Format("IF EXISTS(select * FROM sys.views where name = '{0}') DROP VIEW [{0}]", viewName));
}
public static void DropViewsIfExists(this IExecuteExpressionRoot execute, string views)
{
execute.Sql(string.Format("IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = '{0}')) BEGIN DROP VIEW [{0}] END", views));
}
public static void DropSPIfExists(this IExecuteExpressionRoot execute, string sp)
{
execute.Sql(string.Format("IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = '{0}')) BEGIN DROP PROCEDURE [{0}] END", sp));
}
