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); } } } } }