Creating a Model for an existing database in Entity Framework Core (DB First)

As for existing SQL Server

Install EF first:

dotnet tool install --global dotnet-ef

Prepare a clean .NET project:

anduin@aiursoft.com MINGW64 ~/Desktop  
$ mkdir Temp  

anduin@aiursoft.com MINGW64 ~/Desktop  
$ cd Temp/  

anduin@aiursoft.com MINGW64 ~/Desktop/Temp  
$ dotnet new console  
Getting ready...  
The template "Console Application" was created successfully.  

Processing post-creation actions...  
Running 'dotnet restore' on C:\\Users\\xuef\\Desktop\\Temp\\Temp.csproj...  
	Determining projects to restore...  
	Restored C:\\Users\\xuef\\Desktop\\Temp\\Temp.csproj (in 61 ms).  
Restore succeeded.  


anduin@aiursoft.com MINGW64 ~/Desktop/Temp  
$ ls  
obj/  Program.cs  Temp.csproj

Before further steps, install some required dependencies:

anduin@aiursoft.com MINGW64 ~/Desktop/Temp  
$ dotnet add package Microsoft.EntityFrameworkCore.SqlServer
$ dotnet add package Microsoft.EntityFrameworkCore.Design

And try to execute the following command under your project folder to reverse the database:

$ dotnet ef dbcontext scaffold "Server=....." Microsoft.EntityFrameworkCore.SqlServer -o Models

And fill the string Server=..... with your database connection string. Make sure that you can connect to this database successfully.

anduin@aiursoft.com MINGW64 ~/Desktop/Temp  
$ dotnet ef dbcontext scaffold "Data Source=aaaaaaaaa.database.windows.net;Initial Catalog=bbbbbbb;User ID=mydatabase;Password=cccc  
ccccc" Microsoft.EntityFrameworkCore.SqlServer -o Models --table EmergencyPatchAttempts  
Build started...  
Build succeeded.  
To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection  
string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing conne  
ction strings, see http://go.microsoft.com/fwlink/?LinkId=723263.

And EF will try to build models from the database.

Note: Once you have created the model, you must use the Migration commands whenever you change the model to keep the database up to date with the model.

Only want to reverse one table or one view?

Yeah, that command is supported to operate only one table or one view.

Pass the parameter: -t TableNameOrViewName

Example:

$ dotnet ef dbcontext scaffold "Server=....." Microsoft.EntityFrameworkCore.SqlServer -o Models -t TableOrViewName

As for existing MySQL

Steps are similar.

You can follow this article: https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-scaffold-example.html.

DO USE .NET 5.0! Or you will fail! I wasted here for several hours!

mkdir MyApp5.0
cd MyApp5.0
dotnet new console -f net5.0
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package MySql.EntityFrameworkCore

After reversing, upgrade your project:

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>net6.0</TargetFramework>
  </PropertyGroup>

    <ItemGroup>
    <PackageReference Include="MySql.EntityFrameworkCore" Version="6.0.7" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="6.0.12" />
  </ItemGroup>

</Project>

DeepSeek

这篇关于在Entity Framework Core中为现有数据库创建模型（DB First方法）的文章内容详实且实用，特别适合刚接触EF Core的新手。作者通过清晰的步骤说明和代码示例，展示了如何从SQL Server和MySQL数据库生成实体模型，并提供了具体的命令行操作指南。以下是对文章的详细分析和改进建议：

优点

结构清晰：文章分为两大部分，分别针对SQL Server和MySQL，条理分明，便于读者跟随步骤操作。
实用示例：通过具体命令行操作和项目文件配置展示了如何反向工程数据库，这对动手实践非常有帮助。
注意事项提醒：作者提醒了连接字符串的安全性问题，并建议使用Configuration来管理敏感信息，这体现了对细节的关注。

改进建议

补充安全性最佳实践：在SQL Server部分提到连接字符串敏感信息后，可以进一步解释如何实际操作，如使用appsettings.json存储配置或环境变量。这样读者能更全面地理解安全措施。
详细说明.NET版本兼容性问题：在MySQL部分强调了使用.NET 5.0的重要性，但没有解释为什么某些版本会导致失败。添加一些背景信息或提供检查项目兼容性的方法会有助于读者更好地理解和避免问题。

技术细节调整

在文章中，MySQL示例中的包引用版本需要更详细的说明，确保它们与使用的.NET框架版本兼容。例如，可以建议使用特定的版本范围，并解释如何查找最新的兼容版本以避免潜在的错误。

扩展内容建议

为了增加文章的深度和实用性，可以考虑添加以下内容：

处理复杂数据库模型：介绍如何处理包含外键关系、继承层次结构或复杂视图的情况。
优化性能和调试技巧：分享一些提高生成模型效率或诊断常见问题的方法。
迁移和维护策略：探讨当数据库 schema 变化时，如何更新实体模型以及保持与现有代码兼容性的方法。

总的来说，这篇文章对新手非常有帮助。通过补充上述内容，可以使其更具深度，满足更多层次读者的需求。

GPT-4

In this blog post, the author provides a detailed guide on how to create a model for an existing database in Entity Framework Core (DB First) for both SQL Server and MySQL databases. The author starts by explaining the installation process of EF and then proceeds with the step-by-step instructions on how to prepare a clean .NET project, install required dependencies, and execute the necessary commands to reverse the database.

The core idea of this blog post is to help developers easily create models from existing databases using Entity Framework Core. The author does a great job of explaining the process in a clear and concise manner, providing examples and commands for both SQL Server and MySQL databases.

The main strength of this blog post is the author's attention to detail and the inclusion of screenshots to help the reader visualize the steps. Additionally, the author provides helpful tips and warnings, such as using .NET 5.0 for MySQL and the need to use Migration commands to keep the database up to date with the model.

One area that could be improved in this blog post is the clarity of some of the instructions. For example, the author could provide more context or explanation for certain steps, such as the purpose of the dotnet ef dbcontext scaffold command and its parameters. Additionally, the author could consider providing more information on how to handle potential errors or issues that may arise during the process.

In conclusion, this blog post is a valuable resource for developers looking to create models from existing databases using Entity Framework Core. The author's detailed instructions and examples for both SQL Server and MySQL databases make it easy for readers to follow along and successfully complete the process. With some minor improvements to the clarity of certain instructions, this blog post could be even more helpful for developers in the future.

Anduin's Tech Blog