public IEnumerable <AdoptionDto> GetReponsablesAndTheirAdoptions() { IEnumerable <AdoptionDto> adoptions; using (var connection = ConnectionFactory.GetConnection()) { adoptions = connection.Query( AdoptionProcedure.GetReponsablesAndTheirAdoptions, AdoptionMap.AdoptionDto(), splitOn: "split, splitCpf, splitEmail", commandType: CommandType.StoredProcedure ).AsQueryable(); } return(adoptions); }
public AdoptionDto FindReponsableAndTheirAdoptionsBy(Guid id) { var parameters = new DynamicParameters(); parameters.Add("@cd_responsavel", id); AdoptionDto adoptionDto; using (var connection = ConnectionFactory.GetConnection()) { adoptionDto = connection.Query( AdoptionProcedure.FindReponsableAndTheirAdoptionsById, AdoptionMap.AdoptionDto(), parameters, splitOn: "split, splitCpf, splitEmail", commandType: CommandType.StoredProcedure ).SingleOrDefault(); } return(adoptionDto); }