Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static void CallStoredProcedure(SoftUniContext context)
- {
- var inputText = Console.ReadLine().Split(new[] {' '}, StringSplitOptions.RemoveEmptyEntries);
- var firstName = new SqlParameter("@firstName", SqlDbType.VarChar) {Value = inputText[0]};
- var lastName = new SqlParameter("@lastName", SqlDbType.VarChar) {Value = inputText[1]};
- var projects = context.Database.SqlQuery<GetProjectByEmployee>("usp_GetProjectsByEmployee @firstName, @lastName", firstName, lastName);
- foreach (var project in projects)
- {
- Console.WriteLine($"{project.Name} - {project.Description}, {project.StartDate}");
- }
- }
- public class GetProjectByEmployee
- {
- public string Name { get; set; }
- public string Description { get; set; }
- public DateTime StartDate { get; set; }
- }
Advertisement
Add Comment
Please, Sign In to add comment