Top10ProductsByPrice.cs

[OperationContract]
public List<ProductModel> GetTop10ProductsByPrice()
{
    var prodList = new List<ProductModel>();
    string connectionString = ConfigurationManager.ConnectionStrings["NorthwindConnection"] as string;
    string query = "SELECT TOP 10 ProductID, Name, UnitPrice FROM Product ORDER BY UnitPrice DESC";
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(query, connection);
        command.CommandType = System.Data.CommandType.Text;
        var reader = command.ExecuteReader();
        if (reader != null)
            while (reader.Read())
            {
                var cust = new ProductModel
                {
                    ProductID = reader.GetInt32(0),
                    ProductName = reader.GetString(1),
                    Price = reader.GetDecimal(2)
                };
                prodList.Add(cust);
            }
        return prodList;
    }
}