C# 操作国产数据库【 人大金仓 】之四大模式

SqlSugarCore
SqlSugarCore.Kdbndp

//SqlSugarCore 5.1.4.143-preview08 支持
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
    DbType = DbType.Kdbndp,
    ConnectionString ="Server=127.0.0.1;Port=54321;UID=SYSTEM;PWD=system;database=SQLSUGAR4XTEST1", 
    IsAutoCloseConnection = true, 
    MoreSettings=new ConnMoreSettings()
    { 
        //SqlSugarCore 5.1.4.143
        DataBaseModel= DbType.PostgreSQL//配置PG模式主要是兼容系统表差异
    }
})

SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
    DbType = DbType.Kdbndp,
    ConnectionString ="Server=127.0.0.1;Port=54321;UID=SYSTEM;PWD=system;database=SQLSUGAR4XTEST1", 
    IsAutoCloseConnection = true, 
    MoreSettings=new ConnMoreSettings()
    { 
        //SqlSugarCore 5.1.4.144-preview16+ 支持
        DataBaseModel= DbType.SqlServer//配置SqlServer模式主要是兼容CodeFirst报错
    }
})

 SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
 {
       DbType = DbType.Kdbndp,
       ConnectionString ="Server=127.0.0.1;Port=54321;UID=SYSTEM;PWD=system;database=SQLSUGAR4XTEST1",
       IsAutoCloseConnection = true
 });
  //自动生成下划线看PostgreSQL文档用法差不多

 SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
 {
       DbType = DbType.Kdbndp,
       ConnectionString = "Server=127.0.0.1;Port=54321;UID=SYSTEM;PWD=system;database=SQLSUGAR4XTEST1",
       IsAutoCloseConnection = true,
       MoreSettings=new ConnMoreSettings() { 
           IsAutoToUpper=false //禁用自动转成大写表 5.1.3.41-preview08
       }
   });
  //注意:请升级到 5.1.3.41-preview08 以上版本　　

using SqlSugar;
 

SqlSugarCl服务器托管网ient Db = new SqlSugarClient(new ConnectionConfig()
{
    ConnectionString = "datasource=demo.db",
    DbType = DbType.Kdbndp,//MySql和SqlServer模式看上面需要配置DatabaseModel
    IsAutoCloseConnection = true
});
 
//建库
Db.DbMaintenance.CreateDatabase();//达梦和Oracle不支持建库
 
//建表（看文档迁移）
Db.CodeFirst.InitTables(); //所有库都支持     
 
//查询表的所有
var list = Db.Queryable().ToList();
 
//插入
Db.Insertable(new Student() { SchoolId = 1, Name = "jack" }).ExecuteCommand();
 
//更新
Db.Updateable(new Student() { Id = 1, SchoolId = 2, Name = "jack2" }).ExecuteCommand();
 
//删除
Db.Deleteable().Where(it => it.Id == 1).ExecuteCommand();
  
 
//实体与数据库结构一样
public class Student
{
    //数据是自增需要加上IsIdentity 
    //数据库是主键需要加上IsPrimaryKey 
    //注意：要完全和数据库一致2个属性
    [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
    public int Id { get; set; }
    public int? SchoolId { get; set; }
    public string? Name { get; set; }
}