.NET Model Generator from SQL

A VS Code extension that generates .NET 8 model classes from SQL CREATE TABLE statements (supports SQL Server, MySQL, and SQLite).

Features

• 🚀 Multi-Database Support: Works with SQL Server, MySQL, and SQLite syntax
• 🛠 Accurate Type Mapping: Converts SQL types to proper C# types (.NET 8)
• 🔍 Comprehensive Annotations:
  • [Table] and [Column] attributes
  • [Key] for primary keys
  • [MaxLength] for string fields
  • [Required] for non-nullable fields
• ⚙ Configurable:
  • Default namespace
  • Nullable reference types
• 📂 Automatic File Creation: Generates files in the correct Models folder

Installation

1. Open VS Code
2. Go to Extensions view (Ctrl+Shift+X)
3. Search for ".NET Model Generator from SQL"
4. Click Install

Usage

1. Open your .NET project in VS Code
2. Press Ctrl+Shift+P to open Command Palette
3. Search for and run: Generate .NET Model from SQL
4. Select your database type (SQL Server, MySQL, or SQLite)
5. Paste your CREATE TABLE statement
6. The model will be generated in your Models folder

Example Input (SQL Server):

CREATE TABLE [dbo].[Customers] (
    [CustomerID] int PRIMARY KEY,
    [Name] nvarchar(100) NOT NULL,
    [Email] nvarchar(255),
    [Age] int,
    [JoinDate] datetime2 NOT NULL,
    [IsActive] bit DEFAULT 1
)