DataModeler

DataModeler acts as a super ORM generating SQL scripts, data access layer and Web API, based on simple entities. If you are familiar with Entity Framework and Code first, DataModeler is similar but using the powerful Dapper to increase performance and stability for data access.

Example of features included :

• Generates Web API
• Generates View models
• Generate SQL scripts (Tables, Stored procedures, Indexes)
• Generates Swagger documentation
• Generates integration test
• Sending Email
• Api Versionning
• Multiple primary keys
• Foreign keys (1 to 1, 1 to n, n to n)
• Multilanguage facilities
• Data context classes
• Data encryption (AES)
• Data caching (Redis Azure, MemoryCache)
• System columns (owner, dates)

Learn more!

DataModeler is currently in preview and documentation is updated every day, feel free to use the Q&A section...

Installation

Just follow these steps:

• Install any edition of **Visual Studio 2019 16.4.0 **.
• Download and install the DataModeler extension.

All scripts generated are compatible with SQL server 2008 minimum

Quick Start

1. Create a new DataModeler project

File > New > Project and select DataModeler in Visual C# category

3 projects are created by default :

• An empty Database project
• An empty Datacontext project
• A DataModel project containing one simple entity

2. Right-click on the DataModel project

3. Select the menu DataModeler then Generate All

Congratulations !!

Your Database project contains all SQL scripts related to your entity (Create table, Stored Procedures...). Your Datacontext project contains usable C# methods to request your database using Dapper.