C# (CSharp) Northwind.Data NorthwindEntities.Sales_by_Year Beispiele

Sales_by_Year() public method

public Sales_by_Year ( Nullable beginning_Date, Nullable ending_Date ) : ObjectResult
beginning_Date	Nullable
ending_Date	Nullable
return	ObjectResult

Beispiel #1

Datei: 02-05.DAOManipulations.cs Projekt: sabrie/TelerikAcademy

        // Task 05.
        // Write a method that finds all the sales by specified region
        // and period (start / end dates).
        public static IEnumerable<Sales_by_Year_Result> FindSalesByRegionAndPeriod(string shipRegion, DateTime startYear, DateTime endYear)
        {
            NorthwindEntities context = new NorthwindEntities();

            var salesByRegionAndYear =
                from salesByYear in context.Sales_by_Year(startYear, endYear)
                join order in context.Orders
                .Where(o => o.ShipRegion == shipRegion)
                on salesByYear.OrderID equals order.OrderID
                select salesByYear;

            return salesByRegionAndYear;
        }