Overview Q & A Rating & Review
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
Multiple primary keys
Foreign keys (1 to 1, 1 to n, n to n)
Data context classes
Data encryption (AES)
Data caching (Redis Azure, MemoryCache)
System columns (owner, dates)
DataModeler is currently in preview and documentation is updated every day, feel free to use the Q&A section...
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
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
Right-click on the DataModel project
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.