JCoder.Db4Net.ORM 2.21.2211.2117

JCoder.Db4Net.ORM

[TOC]

架构说明

引用类库

相关类库

获取方式

1. 版本要求：>=2.21.4
2. 以版本2.21.4为例

使用说明

主要类与接口

函数名称说明

特性说明

扩展使用

1. ToEntity1st（查询数据，并将首条数据转换为数据实例）

   // ToEntity1st（查询数据，并将首条数据转换为数据实例）
   using JCoder.Db4Net;
   using JCoder.Db4Net.ORM;
   
   IDbOperator _operator = new MsSqlFactoryOperator()
   {
       ConnectionString = "Server=127.0.0.1;Database=test;Uid = user; Pwd=testpassword;"
   };
   return this.Operator.ToEntity1st<T>("select top 1 * from table1;");
   

2. ToEntities（查询数据，并转换为数据实体列表）

   // ToEntities（查询数据，并转换为数据实体列表）
   using JCoder.Db4Net;
   using JCoder.Db4Net.ORM;
   
   IDbOperator _operator = new MsSqlFactoryOperator()
   {
       ConnectionString = "Server=127.0.0.1;Database=test;Uid = user; Pwd=testpassword;"
   };
   return this.Operator.ToEntities<T>("select top 10 * from table1;");
   

3. CRUD（增删查改）

   using JCoder.Db4Net;
   using JCoder.Db4Net.ORM;
   
   // Test Entity Class
   [DbTable("t_table_test")]
    public class TestEntity
    {
        [DbPrimaryKey]
        [DbAutoIncrement]
        public int Key001 { get; set; }
        [DbPrimaryKey]
        [DbField(IsUnique=true)]
        public string Key002 { get; set; }
   
        [DbIndex("idx01")]
        public string C003 { get; set; }
    }
   
   IDbOperator _operator = new MsSqlFactoryOperator()
   {
       ConnectionString = "Server=127.0.0.1;Database=test;Uid = user; Pwd=testpassword;"
   };
   
   TestEntity x = new TestEntity()
   {
       Key001 = 101,
       Key002 = "Test PK",
   };
   
   // Insert Data（新增数据）
   this.Operator.Insert<TestEntity>(x);
   
   // Update Data（更新数据）
   x.C003 = "Update Test";
   this.Operator.Update<TestEntity>(x);
   
   // Delete Data（删除数据）
   this.Operator.Delete<TestEntity>(x);
   
   // Select Data（查询数据）
   this.Operator.Select1st<TEntity>(" and Key001=101 and Key002-'Test PK'");
   

4. Create\Drop Table From Entity（由实体类创建\删除数据库的数据表）

   using JCoder.Db4Net;
   using JCoder.Db4Net.ORM;
   
   // Test Entity Class
    [DbTable("t_table_test")]
    public class TestEntity
    {
        [DbPrimaryKey]
        [DbAutoIncrement]
        public int Key001 { get; set; }
        [DbPrimaryKey]
        [DbField(IsUnique =true)]
        public string Key002 { get; set; }
        [DbIgnore]
        public string Key003 { get; set; }
   
        [DbIndex]
        [DbField(AllowNull = false, Default = "", Description = "Test Comment")]
        public string C001 { get; set; }
        [DbIndex("idx01")]
        public string C002 { get; set; }
        [DbIndex("idx01")]
        public string C003 { get; set; }
   
        [DbIgnore]
        public int C004 { get; set; }
        [DbField(AllowNull = false, Default = "0", Description = "Test Comment2")]
        public int C005 { get; set; }
        [DbNumberFieldExt(Precision = 11, Scale = 2)]
        public double C006 { get; set; }
   
        [DbField(AllowNull = false, Default = "", Description = "Test Comment2")]
        public string C007 { get; set; }
        public string C008 { get; set; }
        [DbTimeFieldExt(UpdateTimeOnCreate = true, UpdateTimeOnUpdate = true)]
        public DateTime C009 { get; set; }
    }
   
   IDbOperator _operator = new MsSqlFactoryOperator()
   {
       ConnectionString = "Server=127.0.0.1;Database=test;Uid = user; Pwd=testpassword;"
   };
   
   this.Operator.CreateTable<TestEntity>();
   this.Operator.DropTable<TestEntity>();
      
   

Orm工具类使用

1. 转换首条数据为实体对象(支持DbDataReader、DataTable)

   var _table = new DataTable();
   
   // ToEntity1st
   JCoder.Db4Net.ORM.Orm.ToEntity1st<T>(_table);
   
   // ToObject1st
   JCoder.Db4Net.ORM.Orm.ToObject1st<T>(_table);
   JCoder.Db4Net.ORM.Orm.ToObject1st<T>(_table, OrmMappingMode.OnlyProperty);
   JCoder.Db4Net.ORM.Orm.ToObject1st<T>(_table, OrmMappingMode.OnlyDbAttribute);
   JCoder.Db4Net.ORM.Orm.ToObject1st<T>(_table, OrmMappingMode.DbAttributeFirst);
   
   

2. 将数据转换为实体对象(支持DataRow、IDictionary<string, string>、IDictionary<string, object>))

   var _dict = new Dictionary<string, string>();
   
   // ToEntity
   JCoder.Db4Net.ORM.Orm.ToEntity<T>(_dict);
   
   // ToObject
   JCoder.Db4Net.ORM.Orm.ToObject<T>(_dict);
   JCoder.Db4Net.ORM.Orm.ToObject<T>(_dict, OrmMappingMode.OnlyProperty);
   JCoder.Db4Net.ORM.Orm.ToObject<T>(_dict, OrmMappingMode.OnlyDbAttribute);
   JCoder.Db4Net.ORM.Orm.ToObject<T>(_dict, OrmMappingMode.DbAttributeFirst);
   
   

3. 将数据源转换为实体对象列表(支持DbDataReader、DataTable)

   var _table = new DataTable();
   
   // ToEntities
   JCoder.Db4Net.ORM.Orm.ToEntities<T>(_table);
   
   // ToObjects
   JCoder.Db4Net.ORM.Orm.ToObjects<T>(_table);
   JCoder.Db4Net.ORM.Orm.ToObjects<T>(_table, OrmMappingMode.OnlyProperty);
   JCoder.Db4Net.ORM.Orm.ToObjects<T>(_table, OrmMappingMode.OnlyDbAttribute);
   JCoder.Db4Net.ORM.Orm.ToObjects<T>(_table, OrmMappingMode.DbAttributeFirst);
   
   

4. 将数据填充到已有的实体对象里(支持DbDataReader、DataRow、IDictionary<string, string>、IDictionary<string, object>)

   var _source = new DbDataReader();
   var _target = new T();
   
   JCoder.Db4Net.ORM.Orm.FillToObject<T>(_target, OrmMappingMode.OnlyProperty, _source);
   JCoder.Db4Net.ORM.Orm.FillToObject<T>(_target, OrmMappingMode.OnlyDbAttribute, _source);
   JCoder.Db4Net.ORM.Orm.FillToObject<T>(_target, OrmMappingMode.DbAttributeFirst, _source);
   
   

5. 将实体对象转换为DataTable

   // 实体对象转换为DataTable
   DataTable _table = JCoder.Db4Net.ORM.Orm.EntityToDataTable(new T());
   DataTable _table = JCoder.Db4Net.ORM.Orm.ObjectToDataTable(new T());
   
   // 实体对象列表转换为DataTable
   DataTable _table = JCoder.Db4Net.ORM.Orm.EntitiesToDataTable(new List<T>());
   DataTable _table = JCoder.Db4Net.ORM.Orm.ObjectsToDataTable(new List<T>());
   
   

6. 将List转换为DataTable

   // 将List转换为DataTable（使用特性进行排序，自定义名称等）
   public class BoTest
   {
        [DbSubField("Width", "S001-Width", Sort = 2120)]//获取Size对象里的Width属性值，并显示为"S001-Width"
        [DbSubField("Height", "S001-Height", Sort = 2121)]//获取Size对象里的Height属性值，并显示为"S001-Height"
        public Size S001 { get; set; }
        public string Key { get; set; }
        [DbEnumName]//枚举显示为文本
        public AttributeTargets AT { get; set; }
        public AttributeTargets AT2 { get; set; }
        [DbSort(100)]
        public string P100 { get; set; }
        [DbSort(111)]//设置排序值（从小到大依次排序）
        public string P111 { get; set; }
        public DateTime CreateTime { get; set; }
        [DbIgnoreConvertion]//转换时忽略
        public int Z001 { get; set; }
   }
   
    var _list = new List<BoTest>();
    for (int i = 0; i < 100; i++)
    {
        _list.Add(new()
        {
            S001 = new(i * 100, i * 1000),
            Key = $"Key_{i}",
            P100 = $"P100_{i}",
            P111 = $"P111_{i}",
            CreateTime = DateTime.Now,
            Z001 = i,
            AT = AttributeTargets.Interface,
            AT2 = AttributeTargets.Delegate,
        });
    }
    var _table = JCoder.Db4Net.ORM.Orm.EntitiesToDataTable(_list);
   

7. 将实体对象转换为Dictionary<string,string>

   // 实体对象转换为Dictionary<string,string>
   Dictionary<string, string> _dict = JCoder.Db4Net.ORM.Orm.EntityToDict(new T());
   Dictionary<string, string> _dict = JCoder.Db4Net.ORM.Orm.ObjectToDict(new T());