无实体建表进行分表

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

无实体建表进行分表 #1146

Closed alinayaa closed 1 year ago

alinayaa commented 1 year ago

希望增加无实体建表进行分表功能。

无实体建表会有一个DateTime字段
需要指定此列进行按照年、月、日、时进行分表可在SugarColumn或DynamicBuilder中增加功能呢

DotNetNext commented 1 year ago

5.1.4.67-preview03 最新预览版本已经支持

     var type = db.DynamicBuilder().CreateClass("axx", new SugarTable()
                {
                     TableName= "azaDy_{year}{month}{day}"
                },null,null, new SplitTableAttribute(SplitType.Year))
                .CreateProperty("Id", typeof(long), new SugarColumn() { IsPrimaryKey = true })
                .CreateProperty("CreateTime", typeof(DateTime), new SugarColumn() { }, isSplitField:true)
                .WithCache()//缓存起来根据表名和字段名组合的KEY    
                .BuilderType();

                db.CodeFirst.InitTables(type);

DotNetNext commented 1 year ago

长时间未回复，还有疑问请发新的issue