private static void CallStoredProcedure(SoftUniContext context)
{
// Solution I - the context has a method which returns the result;
var projectsInfo = context.FindAllProjectsForGivenEmployee("Ruth", "Ellerbrock");
// Solution II - we can directly run the procedure using SQL query with parameters;
//var projectsInfo = context.Database.SqlQuery<ProjectInfo>("EXEC FindAllProjectsForGivenEmployee 'Ruth', 'Ellerbrock'");
foreach (ProjectInfo projectInfo in projectsInfo)
{
Console.WriteLine($"{projectInfo.Name} - {projectInfo.Description.Substring(0, 20)}... {projectInfo.StartDate}");
}
}