JCoder.Db4Net.ORM 2.13.3

JCoder.Db4Net.ORM

目录

[TOC]

介绍

1. JCoder = Jackie who a coder.;
2. C#库;
3. Database类库，一个基于JCoder.Db4Net的ORM库。

架构说明

.Net框架

引用类库

相关类库

获取方式

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

使用说明

创建实例

1. 参考JCoder.Db4Net

实例使用

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

   // ToEntity1st（查询数据，并将首条数据转换为数据实例）
   using JCoder.Db4Net;
   using JCoder.Db4Net.ORM;
   
   IDbOperator _operator = new SqlServerFactoryOperator()
   {
       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 SqlServerFactoryOperator()
   {
       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 SqlServerFactoryOperator()
   {
       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 SqlServerFactoryOperator()
   {
       ConnectionString = "Server=127.0.0.1;Database=test;Uid = user; Pwd=testpassword;"
   };
   
   this.Operator.CreateTable<TestEntity>();
   this.Operator.DropTable<TestEntity>();