gadjov

Call a Stored Procedure

Mar 16th, 2017
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.89 KB | None | 0 0
  1. private static void CallStoredProcedure(SoftUniContext context)
  2.         {
  3.             var inputText = Console.ReadLine().Split(new[] {' '}, StringSplitOptions.RemoveEmptyEntries);
  4.             var firstName = new SqlParameter("@firstName", SqlDbType.VarChar) {Value = inputText[0]};
  5.             var lastName = new SqlParameter("@lastName", SqlDbType.VarChar) {Value = inputText[1]};
  6.             var projects = context.Database.SqlQuery<GetProjectByEmployee>("usp_GetProjectsByEmployee @firstName, @lastName", firstName, lastName);
  7.             foreach (var project in projects)
  8.             {
  9.                 Console.WriteLine($"{project.Name} - {project.Description}, {project.StartDate}");
  10.             }
  11.         }
  12.  
  13. public class GetProjectByEmployee
  14.     {
  15.         public string Name { get; set; }
  16.         public string Description { get; set; }
  17.         public DateTime StartDate { get; set; }
  18.     }
Advertisement
Add Comment
Please, Sign In to add comment