public override string ToSql()
{
string sql = "CREATE FUNCTION " + FullName + "";
string param = "";
parameters.ForEach(item => param += item.ToSql() + ",");
if (!String.IsNullOrEmpty(param))
{
param = param.Substring(0, param.Length - 1);
sql += " (" + param + ")\r\n";
}
else
{
sql += "()\r\n";
}
sql += "RETURNS " + returnType.ToSql() + " ";
sql += "WITH EXECUTE AS " + AssemblyExecuteAs + "\r\n";
sql += "AS\r\n";
sql += "EXTERNAL NAME [" + AssemblyName + "].[" + AssemblyClass + "].[" + AssemblyMethod + "]\r\n";
sql += "GO\r\n";
return(sql);
}
