The stored procedure will also return the modified data using an implicit resultset.The resultset metadata is defined by the developer in a . Now, you have defined the metadata for retrieving the stored procedure resultset.Entity SQL Next, you will call a stored procedure added to the EDM via a function import.
Click (Start Debugging) In the application, you will notice that the result. Under the covers, Entity Framework is executing the stored procedure as well.
The salary is set to 18000, then increased by 10 in the stored procedure, providing custom logic in addition to the default behavior.
This section will demonstrate three common EDM querying methods: LINQ, LINQ with lambda expressions, and Entity SQL.
To execute a LINQ query against an Oracle database, you will add a reference to an Entity Framework assembly.
You will query using another query method available in Entity Framework called Entity SQL.