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