In the Solution Explorer window, select and click Model Browser.
Type in the highlighted code below or copy the code from the from the section labeled "LINQ using lambda expressions --" and paste it in after the previous code statements.
Entity Framework allows developers to define their own . This is done by creating function imports in the conceptual model that map to stored procedures.
To return the resultset, you will provide the resultset parameter information in a . You will then insert and delete data to the database without using a stored procedure.Lastly, you will show how to use Model-First with Oracle database.Note: Press Enter to continue after viewing the first resultset.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 then create the code to execute a LINQ query and return the results to the console window. The code executes a LINQ query against the EDM you just created.
Type the namespace references highlighted in the graphic below. It then accesses the result and outputs it to the screen.Then, copy the code including the namespace references and paste them at the top of the NET, Entity Framework and Object Services namespaces. Make sure you include an end curly brace to terminate the USING scope. Updates, inserts, and deletes can be executed on an entity by mapping Oracle stored procedures to these operations in the EDM.In this portion of the lab, you will execute a LINQ query with a lambda expression against the EMPLOYEE entity, then map a stored procedure to execute an update against all rows selected.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. Model-First allows the conceptual model to be created first by the developer.