1        怎么在EF框架下使用达梦

1.1    环境

数据库环境：直接在官网下载安装达梦数据库即可，初始化实例时，需要新建DMHR示例库。

开发环境：Visual Studio 2019

1.2    具体步骤

1.2.1 创建解决方案

1.2.2 引用达梦类库DmProvider.dll和EFDmProvider.EF6.dll

相关文件，请在安装目录的drivers目录下找。

1.2.3 在NuGet中引用EF6

1.2.4 配置App.config

<? xml version = " 1.0 " encoding = " utf-8 " ?>

< configuration >

  < configSections >

    < section name = " entityFramework " type = " System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " requirePermission = " false " />

    < section name = " EFDm " type = " EFDmProvider.config.EFDmConfigurationSection, EFDmProvider.EF6, Version=1.0.0.0, Culture=neutral, PublicKeyToken=514fc861b4bfc6c6 " requirePermission = " false " />

  </ configSections >

  < connectionStrings >

    < add name = " DMHREntities " connectionString = " Server=localhost; User Id=SYSDBA; PWD=123456789;SCHEMA=DMHR;PORT=5236;CONNPOOLING=TRUE; " providerName = " EFDmProvider " />

  </ connectionStrings >

  < system.data >

    < DbProviderFactories >

      < add name = " EF Dm Data Provider " invariant = " EFDmProvider " description = " EF Provider for Dm Server " type = " EFDmProvider.EFDmProviderFactory, EFDmProvider.EF6 " />

    </ DbProviderFactories >

  </ system.data >

  < EFDm >

    < varcharMaxToClob value = " true " />

  </ EFDm >

  < startup >

    < supportedRuntime version = " v4.0 " sku = " .NETFramework,Version=v4.5 " />

  </ startup >

  < entityFramework >

    < defaultConnectionFactory type = " EFDmProvider.EFDmConnectionFactory, EFDmProvider.EF6 " />

    < providers >

      < provider invariantName = " EFDmProvider " type = " EFDmProvider.EFDmProviderServices, EFDmProvider.EF6 " />

    </ providers >

  </ entityFramework >

</ configuration >

截图如下图所示：

1.2.5 创建DMHREntities

1.2.6 创建数据库中对应的实体类：此处举例：REGION

1.2.7 调用：

1.2.8 结果