public async Task <Person> GetPerson(int id) { await using var connection = new SqlConnection(_dbConfig.ConnectionString); await using var command = new SqlCommand("GetPersonById", connection) { CommandType = CommandType.StoredProcedure }; connection.Open(); command.Parameters.AddWithValue("id", id); await using var reader = await command.ExecuteReaderAsync(); var person = DbHelper.CreatePerson(reader); return(person); }
public async Task <Person> GetPersonAsync(int id) { var person = new Person(); using (var connection = new SqlConnection(_dbConfig.ConnectionString)) using (var command = new SqlCommand("GetPersonById", connection) { CommandType = CommandType.StoredProcedure }) { connection.Open(); command.Parameters.AddWithValue("Id", id); using (var reader = command.ExecuteReader()) { while (reader.Read()) { await Task.Run(() => person = DbHelper.CreatePerson(reader)); } } } return(person); }
public async Task <IEnumerable <Person> > GetPersonsAsync(int roleId) { var persons = new List <Person>(); using (var connection = new SqlConnection(_dbConfig.ConnectionString)) using (var command = new SqlCommand("GetPersonsByRoleId", connection) { CommandType = CommandType.StoredProcedure }) { connection.Open(); command.Parameters.AddWithValue("roleId", roleId); using (var reader = command.ExecuteReader()) { while (reader.Read()) { await Task.Run(() => persons.Add(DbHelper.CreatePerson(reader))); } } } return(persons); }