In this section, you will query the same rows as in the previous section to show that the stored procedure successfully updated the selected rows.You will query using another query method available in Entity Framework called Entity SQL.
Unfortunately, the various installments are not easy to follow when starting from Part 1 and going onward, so I've decided to gather and organize the links here for myself and for anyone else interested in his tutorial.
You may define your own stored procedures to override default behavior.
Note: Press Enter to continue after viewing the first resultset.
Type the namespace references highlighted in the graphic below. It then accesses the result and outputs it to the screen.
Alternatively, you can copy and paste this information. The LINQ query retrieves all employee information with EMPLOYEE_ID less than the max_id variable.