NXDO.Data 4.2.6080.2

简述

数据库实体类应用，速度优于官方 EntityFramework<br> 实体类生成请采用 nxdo 提供的插件 NXDO.Addin2022.vsix

示例

1.实体类定义

    [Table("AUser")]
    public class AUser : NXDO.Data.Entity {
        [Field(Flag = FieldFlag.IsKey | FieldFlag.IsAutoValue)]
        public long UserId { get; set; }

        [Field]public String UserName { get; set; }

        [Field]public String Password { get; set; }

        [Field]public bool Sex { get; set; }

        [Field]public long? RoleId { get; set; }
    }

2.连接与关闭

    //装载
    NXDO.Data.Factory.DbContext.Load(); //显示调用环境装载，最好显示调用关闭
    
    //显示调用关闭
    (DbContext.Current as IDisposable).Dispose();
    
    using(var ctxt = NXDO.Data.Factory.DbContext.Load()){
        //...
    }

3.插入与查询

    using NXDO.Data.Extension;  //扩展方法在此命名空间下
    new AUser {
        UserName = "xx",
        Password = "***",
        Sex = true,
        RoleId = 1L,
    }.DBExecute().DataCreate();

    //linq
    var rs = new AUser().DBLinq().ToPage().TakeAny(0);
    var rs = (from m in new AUser().DBLinq() select m).ToList();

配置

文件名：NXDO.Data.Provider.json<br> 保证该配置文件在 “应用程序环境的根目录”

{
    "active": 0,
    "providers": [
        {
            "key": 0,
            "providerName": "MySql.Data.MySqlClient",
            "providerAssemblyFileName": "MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data.dll",
            "providerAssemblyQualifiedName": "MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=8.0.27.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d", //8.0.27.0 按使用的版本修改

            "connectionString": "server=localhost;port=3308;database=AUserSys;user id=root;password=***;allowuservariables=True;characterset=utf8;",
            //ling格式化类型，可空，框架自动匹配
            //"linqFormatterType": "NXDO.Data.Linq.Formatter.DbMySqlFormatter, NXDO.Data.N6, Version=4.0.60.1, Culture=neutral, PublicKeyToken=a3a15b70fe786e3e", //4.0.60.1 按使用的版本修改
            "dbType": "MySqlDbType",
            "parameter": "@",
            "syncAutoID": "select last_insert_id()",
            "quotePrefix": "`",
            "quoteSuffix": "`",

            "usedAS": true,
            "usedJSON": false,
            "usedSnowId": false,
            "snowIdTables": "",

            "alias": "t1", //分页时的别名,用于$SelectFields
            "pageRowCount": "pageIndex * pageSize",
            "pageMaxCount": "",

            //支持linq查询
            //"pageSQL": "SELECT $SelectFields FROM $Table WHERE $Filter $Order LIMIT $PageRowCount, $PageSize" 

            //此语句，不支持 linq的DbPage查询
            "pageSQL": "SELECT $SelectFields FROM $Table t1 join (select $Field from $BaseTable WHERE $Filter $Order LIMIT $PageRowCount, $PageSize) t2 WHERE t1.$Field=t2.$Field and $Filter"
        },
        {
            "key" : 1,
            //ms sqlserver ...
        },
        {
            "key" : 2,
            //oracle ...
        }
    ]
}