public Procedure Get(Database database, string schema, string name)
{
Procedure procedure;
using (var db = getDbConnection.Get(database)) {
procedure = db.QueryFirst <Procedure>(GetCommandDefinition(schema, name));
}
procedure.Database = database;
procedure.Parameters = listProcedureParameter.List(procedure);
procedure.CreateScript = getProcedureDefinition.Get(procedure);
procedure.Permissions = getDatabasePermission.Get(procedure);
return(procedure);
}
public IEnumerable <Procedure> Get(Database database, string criteria)
{
string name, schema;
parseCriteria.Parse(criteria, out schema, out name);
IEnumerable <Procedure> procedures;
using (var db = getDbConnection.Get(database)) {
procedures = db.Query <Procedure>(GetCommandDefinition(schema, name));
}
foreach (var item in procedures)
{
item.Database = database;
item.Parameters = listProcedureParameter.List(item);
}
return(procedures);
}