static string AlterOrCreate(HuntingDog.Config.EAlterOrCreate alterOrCreate)
{
if (alterOrCreate == HuntingDog.Config.EAlterOrCreate.Alter)
{
return("ALTER");
}
else
{
return("CREATE");
}
}
public static void OpenFunctionForModification(UserDefinedFunction userDefinedFunction, SqlConnectionInfo connInfo, HuntingDog.Config.EAlterOrCreate alterOrCreate)
{
try
{
var builder = new StringBuilder(1000);
lock (userDefinedFunction)
{
userDefinedFunction.Refresh();
builder.AppendLine(UseDataBaseGo(userDefinedFunction.Parent));
builder.Append(userDefinedFunction.ScriptHeader(alterOrCreate == EAlterOrCreate.Alter));
builder.Append(userDefinedFunction.TextBody);
}
CreateSQLDocumentWithHeader(builder.ToString(), connInfo);
}
catch (Exception ex)
{
log.Error("OpenFunctionForModification failed.", ex);
}
}
