AsyncDatabaseCall.Models.GalleryContext.GetCarsViaSP C# (CSharp) Method

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