Exemplo n.º 1
0
        public static void Main()
        {
            using (var db = new NORTHWNDEntities())
            {
                string supplierFullName = "Steven Buchanan";
                DateTime startDate = new DateTime(1995, 1, 1);
                DateTime endDate = new DateTime(1996, 8, 1);

                // After creating stored procedure in Managment studio
                // you should add this procedure and after that update model from DB.
                var result = db.uspTotalIncomesForPeriod(supplierFullName, startDate, endDate);
                Console.WriteLine(result.FirstOrDefault());
            }
        }