CREATE PROCEDURE GetCarsForEdit
AS   
SELECT
 c.IdCar,
 Brands=b.brandOfCar,
 Models=m.nameModel, 
 c.color,
 c.volumeOfEngine,
 c.Description,
 p.price
FROM Cars c
JOIN Models m on c.ModelId=m.IdModel
JOIN Brands b on c.brandId=b.IdBrand
CROSS APPLY(SELECT TOP(1) * FROM Prices p WHERE p.CarId=c.IdCar ORDER BY p.datePrice DESC) p
ORDER BY Models, Brands;

public List<EditDetails> GetCarsForEdit()
        {           
            SqlCommand cmd = new SqlCommand("GetCarsForEdit", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            ListCars = new List<EditDetails>();

            try
            {
                connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    EditDetails editDetails = new EditDetails((int)reader["IdCar"], (string)reader["brandOfCar"], (string)reader["model"], (string)reader["color"], (int)reader["volumeOfEngine"], (string)reader["description"], (int)reader["price"]);
                    ListCars.Add(editDetails);
                }

                reader.Close();
                return ListCars;
            }
            .........

 brandOfCar
Описание: Необработанное исключение при выполнении текущего веб-запроса.

Строка 33:                 while (reader.Read())
Строка 34:                 {
Строка 35:                     EditDetails editDetails = new EditDetails((int)reader["IdCar"], (string)reader["brandOfCar"], (string)reader["model"], (string)reader["color"], (int)reader["volumeOfEngine"], (string)reader["description"], (int)reader["price"]);
Строка 36:                     ListCars.Add(editDetails);
Строка 37:                 }

[IndexOutOfRangeException: brandOfCar]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +5002922
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +67
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +15