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