Enhanced DDEX Provider for Adaptive Server

You can now use Entity Framework to create data models with Adaptive Server databases. This enhancement is supported in Visual Studio 2008 SP1 and Visual Studio 2010.

StepsCreating an Adaptive Server Entity Data Model using Entity Framework

Create data access classes using the Microsoft Entity Framework.

You need a valid connection to an active Adaptive Server to perform this task.

  1. Create a new application project.

  2. In the Solution Explorer window, right-click the project and select Add | New Item.

  3. Select Data as the category and ADO.NET Entity Data Model as the template.

  4. Enter a name for the entity data model and click Add.

    The Data Model wizard launches.

  5. Choose Generate from database. Click Next.

  6. Select an existing Adaptive Server connection or click New Connection. If you chose New Connection, enter the name of the connection settings. Click Next.

  7. Select an Adaptive Server object. Click Finish.

Use the Entity Designer to modify the model. Data access classes are automatically generated by the Entity Framework when you save the model.