public IEnumerable<Car> GetCarsViaSP() {
using (var conn = new SqlConnection(_connectionString)) {
using (var cmd = new SqlCommand()) {
cmd.Connection = conn;
cmd.CommandText = _spName;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
using (var reader = cmd.ExecuteReader()) {
return reader.Select(r => carBuilder(r)).ToList();
}
}
}
}