---

---

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(varconnection=Connection){Console.WriteLine(connection.GenerateAllTables());}

Support Dapper Contrib POCO Class

• Just call method with GeneratorBehavior.DapperContrib

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

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

Generate Comment

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

Generate View

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

Generate View and Comment and Dapper.Contrib

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

Generate one class by sql

1. Generate one class

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

2. Specify class name

using(varconnection=Connection){varclassCode=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

vardt=newDataTable();dt.TableName="TestTable";dt.Columns.Add(newDataColumn(){ColumnName="ID",DataType=typeof(string)});varresult=dt.GenerateClass();varexpect=@"public class TestTable{public string ID { get; set; }}";Assert.Equal(expect,result);