Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- static void GetTotalIncome(int startYear, int endYear, string companyName)
- {
- NORTHWNDEntities db = new NORTHWNDEntities();
- using (db)
- {
- SqlParameter startYearParam = new SqlParameter("@startYear", startYear);
- SqlParameter endYearParam = new SqlParameter("@endYear", endYear);
- SqlParameter name = new SqlParameter("@companyName", companyName);
- var income = db.Database.ExecuteSqlCommand("usp_FindTotalIncome @startYear, @endYear, @companyName", startYearParam, endYearParam, name);
- Console.WriteLine("Total income is {0}", income);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement