search

DotNetNext / SqlSugar

.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
https://www.donet5.com/Home/Doc
MIT License
5.24k stars 1.33k forks source link

PostgreSql获取字段列表时排序问题 #1138

Closed nexthero closed 1 year ago

nexthero commented 1 year ago

PostgreSql获取字段列表：DbMaintenance.GetColumnInfosByTableName() 返回结果能否按ordinal_position排序，或者把ordinal_position加到DbColumnInfo里

DotNetNext commented 1 year ago

默认就是按数据来排序的

DotNetNext commented 1 year ago

如果你查出来不是按数据库排序你可以提供一个建表语句给我

nexthero commented 1 year ago

CREATE TABLE "public"."bas_error_cause" ( "id" varchar(40) COLLATE "pg_catalog"."default" NOT NULL, "error_cause_code" varchar(40) COLLATE "pg_catalog"."default" NOT NULL, "error_cause_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL, "org_id" varchar(40) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying, "remark" varchar(400) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying, "create_id" varchar(40) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying, "create_time" timestamp(6) NOT NULL, "modify_id" varchar(40) COLLATE "pg_catalog"."default" DEFAULT NULL::character varying, "modify_time" timestamp(6), "extras" text COLLATE "pg_catalog"."default", CONSTRAINT "bas_error_cause_pkey" PRIMARY KEY ("id") );

DotNetNext commented 1 year ago

源码已修复

DotNetNext commented 1 year ago

SqlSugarCore 5.1.4.61-preview01 预览版本已修复

DotNetNext commented 1 year ago

还有疑问发布新的ISSUES，先关闭