mini-software/pococlassgenerator

Mini POCO Class Generator (Support POCO, DTO, Dapper Contrib)

---

PocoClassGenerator is started with Necroskillz's POCO Generator Generate C# POCOs from SQL statement in LINQPad

Features

• Support current DataBase all tables and views generate POCO class code
• Support Dapper.Contrib
• Support mutiple RDBMS : sqlserver,oracle,mysql,postgresql
• mini and faster (only in 5 seconds generate 100 tables code)
• Use appropriate dialect schema table SQL for each database query

DEMO

• POCOGenerator Generate Class By Dynamic SQL | .NET Fiddle
• POCO Class Generator GenerateAllTables | .NET Fiddle
• DataTable POCO Class Generator | .NET Fiddle

GetStart

👇First : Copy&Paste PocoClassGenerator.cs Code to your project or LINQPad.
or Install from NuGet

PM> install-package PocoClassGenerator

👇Second : Use Connection to call GenerateAllTables and then print it.

using (var connection = Connection)
{
	Console.WriteLine(connection.GenerateAllTables());
}

Support Dapper Contrib POCO Class

• Just call method with GeneratorBehavior.DapperContrib

using (var conn = GetConnection())
{
    var result = conn.GenerateAllTables(GeneratorBehavior.DapperContrib);
    Console.WriteLine(result);
}

The Online Demo : POCO Dapper Contrib Class Generator GenerateAllTables | .NET Fiddle

Generate Comment

using (var conn = GetConnection())
{
    var result = conn.GenerateAllTables(GeneratorBehavior.Comment);
    Console.WriteLine(result);
}

Generate View

using (var conn = GetConnection())
{
    var result = conn.GenerateAllTables(GeneratorBehavior.View);
    Console.WriteLine(result);
}

Generate View and Comment and Dapper.Contrib

using (var conn = GetConnection())
{
    var result = conn.GenerateAllTables(GeneratorBehavior.View | GeneratorBehavior.Comment | GeneratorBehavior.DapperContrib);
    Console.WriteLine(result);
}

Generate one class by sql

1. Generate one class

using (var connection = Connection)
{
	var classCode = connection.GenerateClass("select * from Table");
	Console.WriteLine(classCode);
}

2. Specify class name

using (var connection = Connection)
{
	var classCode = connection.GenerateClass("with EMP as (select 1 ID,'WeiHan' Name,25 Age) select * from EMP", className: "EMP");
	Console.WriteLine(classCode);
}

DataTablePocoClass

Code at DataTablePocoClassGenerator.cs

var dt = new DataTable();
dt.TableName = "TestTable";
dt.Columns.Add(new DataColumn() { ColumnName = "ID", DataType = typeof(string) });

var result = dt.GenerateClass();
var expect =
@"public class TestTable
{
public string ID { get; set; }
}";
Assert.Equal(expect, result);

pococlassgenerator's Issues

support net5.0

Add partial and remark generate code

If the table/view name contains white space then trim it

e.g sql server northwind view : Order Details Extended

Packget to PocoClassGenerator CLI

dotnet poco generate -cs "connectionString" -sql "select * from table"

Support EF.Core property attribute

Table name with space

Support Dapper FK POCO

e.g

    [Table("Report")]
    public class Report
    {
        [Key]
        public string Id { get; set; }
        public string Name { get; set; }
        public string Type { get; set; }
        public string Sql { get; set; }
        public string Updatetime { get; set; }
        public string ReportDataBaseId { get; set; }

        public ReportDataBase ReportDataBase { get; set; }
    }

    [Table("ReportDataBase")]
    public class ReportDataBase
    {
        [Key]
        public string Id { get; set; }
        public string Name { get; set; }
        public string DbType { get; set; }
        public string ConnectionString { get; set; }
    }

Query by

	var sql = "SELECT * FROM Report A left JOIN ReportDataBase B on A.ReportDataBaseId = B.ID";
	var result = Connection.Query<Report, ReportDataBase, Report>(sql,
	(b, a) => { b.ReportDataBase = a; return b; });

Fix View Use BaseTableName Not ViewName

below code in pococlassgenerator will get test class not viewtest

create view ViewTest as select * from Test

Fix Generate Class Name By Full Name To Avoid Not Using Problem

0.9.2 version :

public class MyClass {
    public DateTime? BirthDate { get; set; }
}

should fix like

public class MyClass {
    public System.DateTime? BirthDate { get; set; }
}

資料行 'IsAutoIncrement' 不屬於資料表 SchemaTable。

HI

請問我新增PocoClassGenerator 這個CS檔，但是實際實行後出現錯誤訊息:[資料行 'IsAutoIncrement' 不屬於資料表 SchemaTable。]

經查詢為 generatorBehavior.HasFlag(GeneratorBehavior.Comment) 與 generatorBehavior.HasFlag(GeneratorBehavior.DapperContrib)
不一致導致 在 (bool)row["IsAutoIncrement"] 找不到元素。然後引發錯誤，請問該如何處理?

DB:oracle

Support x86 x64 mac linux single exe file

Support Firebird database

support Dapper.Contrib

public class Employee
{
    [Key]
    public int EmployeeId { get; set; }
    public string Name { get; set; }
}

Support C# 9 record generate

When View using CommandBehavior.KeyInfo will get duplicate columns

Support code-gen value valid