Entity Framework v4, v5, and v6 allow you to use Model First feature to generate database, and the SSDL, and MSL. In this article we consider how to use this functionality.
Note that this functionality is not supported in Entity Framework Core.
This feature provides a possibility to start from a conceptual model and then to generate the other parts of the EDM (Entity Data Model) and the database. Create Database from Model wizard can be used for database generation from an Entity Data Model in Visual Studio 2010 - 2022.
Entity Framework workflow for DDL generating from CSDL includes two actions. The first one generates SSDL and MSL from CSDL. It is common for all providers and cannot be customized independently. The second action is specific to Entity Framework provider and can be modified for specific DBMS.
Devart offers additional templates for database script generation.
The following steps will guide you through database generation wizard:
As a result of these steps you will obtain a valid database-specific DDL script. You can run this script against your database to create a valid database schema.
Please also note that dotConnect for PostgreSQL goes with its own ORM designer - Entity Developer. It provides advanced Model First support and a number of other features, not available in Visual Studio EDM designer.