Using Model First

The following procedure uses the Oracle ADO.NET Entity Framework data provider, and assumes that you already have the database schema available.

1. Create a new application, such as Windows Console, Windows Forms, or ASP.NET, in Visual Studio.

2. Expand the project in Solution Explorer.

   

3. Right-click the project and select Add / New Item.

   

4. Select ADO.NET EntityDataModel, and then click Add. The Entity Data Model Wizard is displayed.

   

5. Select Empty Model, and then click Finish. An empty model is added to your application.

6. Right-click the empty model and select Properties / DDL Generation Template. Click the drop-down menu and set the value to DataDirect SSDLToOracle.tt (VS).

   

7. Design your model (refer to MSDN for a wide assortment of tutorials).

   

8. When you are satisfied with the model design, right-click the model and select Generate database from model. The Generate Database wizard is displayed.

9. On the Choose Your Data Connection window, do the following steps:
   a. Select or create a connection:
      * Select an existing connection from the drop-down list
      * Click New Connection to create a new connection.
   b. Choose whether to include sensitive information.
   c. Click Next. The DDL is generated.

10. Click Finish. SQL is added to your application.

    

11. Copy the DDL and execute against the connection using any tool.

    

After executing the DDL, the backend database is ready for use, with all of the database objects mapped to your model.