Visual Studio 2010 includes many improvements to the entity framework most notably the ability to create a database based upon a data model. This allows developers to use the Entity Designer to create the model for the database and then generate the appropriate SQL script to create the tables in a database. This is referred to as a model first design.
Version 10 of the Advantage .NET Data Provider fully supports the Visual Studio 2010 development environment along with support for model first. The .NET data provider includes a Text Transformation Template (SSDLToADS.tt) which can translate the model definition into appropriate SQL statements.
The data definition language (DDL) script that is generated can be saved and the opened with Advantage Data Architect. After creating or connecting to an existing data dictionary the generated script can be run which will create tables and referential integrity rules as defined in the data model.