dotnetcore3.1EF连接达梦数据库demo

共83个文件

dll：33个

cache：15个

json：8个

1星需积分: 43 146 浏览量 2020-10-28 16:42:17 上传评论 1 收藏 1.79MB 7Z 举报

在本示例中，我们将深入探讨如何在 .NET Core 3.1 框架下使用 Entity Framework Core (EF Core) 连接国产达梦数据库。由于达梦数据库是国产数据库系统，它可能不支持像 SQL Server 或 MySQL 那样的通用驱动，因此通常需要通过 ODBC 连接。然而，为了提供更高效、更直接的访问方式，达梦提供了官方的 EF Core 驱动，使得开发者可以更加便捷地进行数据操作。确保你已经安装了 .NET Core 3.1 开发环境，并且在项目中添加了对 EF Core 的依赖。可以通过以下命令在 `ConsoleApp1` 项目中安装 EF Core： ```sh dotnet add package Microsoft.EntityFrameworkCore ``` 接下来，我们需要安装达梦数据库的 EF Core 驱动。这个驱动可能不在 NuGet 官方源中，需要从达梦官方网站或者其指定的第三方库源获取。安装命令如下： ```sh dotnet add package Dm.EntityFrameworkCore ``` 在安装了驱动后，我们就可以开始创建数据库上下文类。这个类将继承自 `DbContext` 并且定义用于数据库操作的实体。假设我们有一个 `Employee` 实体，代码如下： ```csharp public class DmDbContext : DbContext { public DbSet<Employee> Employees { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var connectionString = "Server=your_server;Database=DMHR;User Id=your_user;Password=your_password;"; optionsBuilder.UseDmSqlite(connectionString); } } ``` 在 `OnConfiguring` 方法中，我们配置了数据库连接字符串，包括服务器地址、数据库名、用户名和密码。`UseDmSqlite` 是达梦数据库 EF Core 驱动提供的方法，用来指定使用达梦数据库。现在，我们可以创建 `Employee` 类来表示 DMHR 示例数据库中的员工表： ```csharp public class Employee { public int Id { get; set; } public string Name { get; set; } public string Position { get; set; } // 其他字段... } ``` 接下来，我们可以使用 EF Core 提供的命令行工具 `dotnet ef` 来迁移数据库结构，确保数据库与我们的实体模型匹配。在项目目录下运行以下命令： ```sh dotnet ef migrations add InitialCreate dotnet ef database update ``` 这两个命令会创建一个初始的数据库迁移，并应用这个迁移来创建数据库表。在实际开发中，你可能需要进行查询、插入、更新或删除等操作。下面是一些基本操作的例子： ```csharp using (var context = new DmDbContext()) { // 查询所有员工 var employees = context.Employees.ToList(); // 插入新员工 var newEmployee = new Employee { Name = "张三", Position = "经理" }; context.Employees.Add(newEmployee); context.SaveChanges(); // 更新员工信息 var employeeToUpdate = context.Employees.First(e => e.Name == "张三"); employeeToUpdate.Position = "总监"; context.SaveChanges(); // 删除员工 var employeeToDelete = context.Employees.First(); context.Employees.Remove(employeeToDelete); context.SaveChanges(); } ``` 以上代码展示了如何利用 EF Core 对达梦数据库进行基本的 CRUD 操作。请注意，你需要根据实际数据库连接信息和业务需求调整代码。通过这个示例，我们了解了如何在 .NET Core 3.1 项目中使用 EF Core 与达梦数据库进行交互，避免了通过 ODBC 连接的复杂性。这种方式简化了数据库操作，提高了开发效率，同时符合国产化项目的需求。

资源推荐

资源详情

资源评论

收起资源包目录

EFCore3.1 EF连接达梦8数据库例子.7z （83个子文件）

ConsoleApp1

.vs

ConsoleApp1

v16

.suo 28KB

Server

sqlite3

storage.ide 1.89MB

db.lock 0B

DesignTimeBuild

.dtbcache 234KB

.dtbcache.v2 61KB

bin

Debug

netcoreapp3.0

ConsoleApp1.runtimeconfig.json 172B

ConsoleApp1.pdb 444B

ConsoleApp1.runtimeconfig.dev.json 240B

ConsoleApp1.deps.json 425B

ConsoleApp1.exe 156KB

ConsoleApp1.dll 5KB

netcoreapp3.1

Microsoft.Bcl.AsyncInterfaces.dll 15KB

Microsoft.Extensions.Logging.dll 33KB

runtimes

freebsd

lib

netcoreapp2.0

System.Data.Odbc.dll 253KB

linux

lib

netcoreapp2.0

System.Data.Odbc.dll 253KB

win

lib

netcoreapp2.0

System.Data.Odbc.dll 255KB

System.Text.Encoding.CodePages.dll 738KB

osx

lib

netcoreapp2.0

System.Data.Odbc.dll 254KB

DmProvider.dll 557KB

Microsoft.EntityFrameworkCore.Relational.dll 838KB

Microsoft.EntityFrameworkCore.Abstractions.dll 21KB

Microsoft.EntityFrameworkCore.Dm.dll 241KB

ConsoleApp1.runtimeconfig.json 154B

System.Data.Odbc.dll 92KB

DmProvider.resources.dll 22KB

ConsoleApp1.pdb 11KB

FreeSql.Provider.Odbc.dll 679KB

Microsoft.Extensions.Configuration.Binder.dll 25KB

ConsoleApp1.runtimeconfig.dev.json 231B

Microsoft.Extensions.Configuration.dll 27KB

Microsoft.Extensions.Options.dll 49KB

Microsoft.Extensions.Primitives.dll 38KB

Microsoft.Extensions.Logging.Abstractions.dll 47KB

ConsoleApp1.deps.json 20KB

zh-CN

DmProvider.resources.dll 23KB

Microsoft.EntityFrameworkCore.dll 1.48MB

Microsoft.Extensions.Configuration.Abstractions.dll 21KB

Microsoft.Extensions.DependencyInjection.Abstractions.dll 37KB

Microsoft.Extensions.Caching.Abstractions.dll 26KB

Microsoft.Bcl.HashCode.dll 14KB

Microsoft.Extensions.DependencyInjection.dll 71KB

System.Text.Encoding.CodePages.dll 734KB

ConsoleApp1.exe 171KB

FreeSql.dll 939KB

ConsoleApp1.dll 8KB

Microsoft.Extensions.Caching.Memory.dll 32KB

netcoreapp2.2

Program.cs 1KB

ConsoleApp1.csproj 374B

obj

ConsoleApp1.csproj.nuget.g.props 1KB

ConsoleApp1.csproj.nuget.g.targets 294B

project.assets.json 41KB

project.nuget.cache 4KB

ConsoleApp1.csproj.nuget.dgspec.json 3KB

ConsoleApp1.csproj.nuget.cache 149B

Debug

netcoreapp3.0

ConsoleApp1.AssemblyInfoInputs.cache 42B

ConsoleApp1.csprojAssemblyReference.cache 102KB

ConsoleApp1.pdb 444B

ConsoleApp1.csproj.CoreCompileInputs.cache 42B

ConsoleApp1.AssemblyInfo.cs 1016B

ConsoleApp1.assets.cache 185B

.NETCoreApp,Version=v3.0.AssemblyAttributes.cs 190B

ConsoleApp1.csproj.FileListAbsolute.txt 1KB

ConsoleApp1.exe 156KB

ConsoleApp1.dll 5KB

netcoreapp3.1

ConsoleApp1.AssemblyInfoInputs.cache 42B

ConsoleApp1.csprojAssemblyReference.cache 424B

ConsoleApp1.genruntimeconfig.cache 42B

ConsoleApp1.pdb 11KB

ConsoleApp1.csproj.CoreCompileInputs.cache 42B

ConsoleApp1.AssemblyInfo.cs 1016B

ConsoleApp1.assets.cache 16KB

ConsoleApp1.csproj.FileListAbsolute.txt 4KB

ConsoleApp1.exe 171KB

.NETCoreApp,Version=v3.1.AssemblyAttributes.cs 190B

ConsoleApp1.dll 8KB

ConsoleApp1.csproj.CopyComplete 0B

netcoreapp2.2

ConsoleApp1.AssemblyInfoInputs.cache 42B

ConsoleApp1.csprojAssemblyReference.cache 100KB

ConsoleApp1.csproj.CoreCompileInputs.cache 42B

ConsoleApp1.AssemblyInfo.cs 1016B

ConsoleApp1.assets.cache 30KB

ConsoleApp1.sln 1KB

Class1.cs 1KB

C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\ConsoleApp1.exe C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\ConsoleApp1.deps.json C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\ConsoleApp1.runtimeconfig.json C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\ConsoleApp1.runtimeconfig.dev.json C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\ConsoleApp1.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\ConsoleApp1.pdb C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.csprojAssemblyReference.cache C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.AssemblyInfoInputs.cache C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.AssemblyInfo.cs C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.dll C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.pdb C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.genruntimeconfig.cache C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.csproj.CopyComplete C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\FreeSql.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\FreeSql.Provider.Odbc.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\System.Data.Odbc.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\runtimes\freebsd\lib\netcoreapp2.0\System.Data.Odbc.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\runtimes\linux\lib\netcoreapp2.0\System.Data.Odbc.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\runtimes\osx\lib\netcoreapp2.0\System.Data.Odbc.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\runtimes\win\lib\netcoreapp2.0\System.Data.Odbc.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\DmProvider.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Bcl.AsyncInterfaces.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Bcl.HashCode.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.EntityFrameworkCore.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.EntityFrameworkCore.Abstractions.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.EntityFrameworkCore.Dm.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.EntityFrameworkCore.Relational.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Caching.Abstractions.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Caching.Memory.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Configuration.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Configuration.Abstractions.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Configuration.Binder.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.DependencyInjection.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.DependencyInjection.Abstractions.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Logging.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Logging.Abstractions.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Options.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\Microsoft.Extensions.Primitives.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\System.Text.Encoding.CodePages.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\en\DmProvider.resources.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\zh-CN\DmProvider.resources.dll C:\Users\xiufeng\source\repos\ConsoleApp1\bin\Debug\netcoreapp3.1\runtimes\win\lib\netcoreapp2.0\System.Text.Encoding.CodePages.dll C:\Users\xiufeng\source\repos\ConsoleApp1\obj\Debug\netcoreapp3.1\ConsoleApp1.csproj.CoreCompileInputs.cache

评论收藏

内容反馈