public CLRFunction(ISchemaBase parent)
: base(parent, Enums.ObjectType.CLRFunction, Enums.ScripActionType.AddFunction, Enums.ScripActionType.DropFunction)
{
parameters = new List<Parameter>();
returnType = new Parameter();
isAggrFunc = false;
}
//private static string GetSQLParameters()
//{
// string sql = "";
// sql += "select AP.is_output, AP.scale, AP.precision, '[' + SCHEMA_NAME(O.schema_id) + '].['+ O.name + ']' AS ObjectName, AP.name, TT.name AS TypeName, AP.max_length from sys.all_parameters AP ";
// sql += "INNER JOIN sys.types TT ON TT.user_type_id = AP.user_type_id ";
// sql += "INNER JOIN sys.objects O ON O.object_id = AP.object_id ";
// sql += "WHERE type = 'PC' ORDER BY O.object_id, AP.parameter_id ";
// return sql;
//}
//private static string GetSQL()
//{
// string sql = "";
// sql += "select ISNULL(CONVERT(varchar,AM.execute_as_principal_id),'CALLER') as ExecuteAs, P.type, AF.name AS assembly_name, AM.assembly_class, AM.assembly_id, AM.assembly_method, P.object_id, S.name as owner, P.name as name from sys.procedures P ";
// sql += "INNER JOIN sys.schemas S ON S.schema_id = P.schema_id ";
// sql += "LEFT JOIN sys.assembly_modules AM ON AM.object_id = P.object_id ";
// sql += "LEFT JOIN sys.assemblies AF ON AF.assembly_id = AM.assembly_id";
// return sql;
//}
private static void FillParameters(Database database, string connectionString)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(StoreProcedureSQLCommand.GetParameters(database.Info.Version), conn))
{
conn.Open();
command.CommandTimeout = 0;
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Parameter param = new Parameter();
param.Name = reader["Name"].ToString();
param.Type = reader["TypeName"].ToString();
param.Size = (short)reader["max_length"];
param.Scale = (byte)reader["scale"];
param.Precision = (byte)reader["precision"];
param.Output = (bool)reader["is_output"];
if (param.Type.Equals("nchar") || param.Type.Equals("nvarchar"))
{
if (param.Size != -1)
param.Size = param.Size / 2;
}
database.CLRProcedures[reader["ObjectName"].ToString()].Parameters.Add(param);
}
}
}
}
}
