Accelist.EntityGenerator
The official Accelist Technology .NET development tool for cleanly generating Entity Framework Core C# classes from an existing SQL Server database. (Stand-alone Reverse Engineering tool and API)
Install / Use
/learn @ryanelian/Accelist.EntityGeneratorREADME
Accelist.EntityGenerator
The official Accelist Technology .NET development tool for cleanly generating Entity Framework Core C# classes from an existing SQL Server database. (stand-alone Reverse Engineering tool and API)
Getting Started
-
When running on Windows (WPF desktop application), have at least .NET Framework 4.5.1.
Features
-
Designed with love for SQL Server and C#, when developing using database-first approach.
-
Most SQL server basic data types are supported:
- String-like types:
VARCHAR,CHAR,NVARCHAR,NCHAR,XML - Ordinal types:
BIGINT,INT,SMALLINT,TINYINT,BIT - Decimal types:
NUMERIC,DECIMAL,SMALLMONEY,MONEY - Floating-point types:
REAL,FLOAT - Blob types:
VARBINARY,BINARY - Date and time data structures:
DATETIMEOFFSET,SMALLDATETIME,DATETIME,DATETIME2,TIME - Unique types:
UNIQUEIDENTIFIER,ROWVERSION,TIMESTAMP
- String-like types:
-
Maps the type in accordance to appropriate C# data type. Provides null
?hint for nullable columns. -
Supports composite primary keys.
-
Supports non-standard (non-
dbo) table schema. -
Generates the Entity Framework Core DbContext class, without requiring you to install extra / unwanted packages on your project / solution!
-
Save your configurations for later!
-
Blazing fast and easy to use!
Not (Yet) Implemented
-
Navigation and inversion relational properties. (Hint: improve your multi-join queries performance using Dapper instead!)
-
Spatial data types such as:
GEOMETRY,GEOGRAPHY, andHIERARCHYID, because they are not yet supported by Entity Framework Core... -
Retired data types:
TEXT,NTEXT,IMAGE. -
Custom type mapping for
XMLtoXElement,CHAR(1)to C#char.
Credits
- Tie Tieantono for developing the WPF application, and the testing console application.
