Advertisement
Guest User

Untitled

a guest
Jul 15th, 2013
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.63 KB | None | 0 0
  1. static void GetTotalIncome(int startYear, int endYear, string companyName)
  2.     {
  3.         NORTHWNDEntities db = new NORTHWNDEntities();
  4.  
  5.         using (db)
  6.         {
  7.             SqlParameter startYearParam = new SqlParameter("@startYear", startYear);
  8.             SqlParameter endYearParam = new SqlParameter("@endYear", endYear);
  9.             SqlParameter name = new SqlParameter("@companyName", companyName);
  10.  
  11.             var income = db.Database.ExecuteSqlCommand("usp_FindTotalIncome @startYear, @endYear, @companyName", startYearParam, endYearParam, name);
  12.  
  13.             Console.WriteLine("Total income is {0}", income);
  14.         }    
  15.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement