shps951023/pococlassgenerator

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

pococlassgenerator's Issues

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

e.g sql server northwind view : Order Details Extended

Table name with space

When View using CommandBehavior.KeyInfo will get duplicate columns

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

HI

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

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

DB:oracle

Support EF.Core property attribute

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; });

Support code-gen value valid

Support x86 x64 mac linux single exe file

Fix View Use BaseTableName Not ViewName

below code in pococlassgenerator will get test class not viewtest

create view ViewTest as select * from Test

Support Firebird database

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; }
}

support Dapper.Contrib

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

support net5.0

Support C# 9 record generate

Add partial and remark generate code

Packget to PocoClassGenerator CLI

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