blocks|key|1730844|text|您应该使用框架作为Microsoft.NETCore.App。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1730845|来自NuGet包管理器的包|1730846|Microsoft.EntityFrameworkCore|ordered-list-item|1730847|Microsoft.EntityFrameworkCore.SqlServer|1730848|现在可以运行以下命令：|1730849|支架-DbContext+"Server=10.10.10.123;Database=Testdb；user+id=sa；password=Sa1234“Microsoft.EntityFrameworkCore.SqlServer+-OutputDir+Models+-Context+TestDBContext+-Tables雇员|blockquote|1730850|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|R|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|U|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|O|$]]

You should use Frameworks as Microsoft.NETCore.App
Packages from NuGet Package Manager
<ol>
<li>Microsoft.EntityFrameworkCore</li>
<li>Microsoft.EntityFrameworkCore.SqlServer</li>
</ol>
Now you can run the command:
<blockquote>
Scaffold-DbContext &quot;Server=10.10.10.123;Database=Testdb; user id=sa;
password=Sa1234&quot; Microsoft.EntityFrameworkCore.SqlServer -OutputDir
Models -Context TestDBContext -Tables employee
</blockquote>

blocks|key|1730872|text|此示例命令应该可以工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1730873|dotnet+ef+dbcontext+scaffold+"Data+Source=(localdb)MSSQLLocalDB;Initial+Catalog=ShopDB"+Microsoft.EntityFrameworkCore.SqlServer+--output-dir+Models|code-block|syntax|javascript|1730874|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This sample command should work
<pre><code>dotnet ef dbcontext scaffold &quot;Data Source=(localdb)MSSQLLocalDB;Initial Catalog=ShopDB&quot; Microsoft.EntityFrameworkCore.SqlServer --output-dir Models
</code></pre>

blocks|key|1730887|text|我刚刚完成了这个练习，并遵循了以下步骤。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1730888|首先使用nuget软件包管理器安装以下程序：Microsoft.EntityFrameworkCore.Design和Microsoft.EntityFrameworkCore.SqlServer|offset|length|style|CODE|1730889|然后在包管理器控制台中运行以下命令：|1730890|dotnet+ef+dbcontext+scaffold+"Data+Source=.;Initial+Catalog=databaseName;Trusted_Connection=true"+Microsoft.EntityFrameworkCore.SqlServer+--output-dir+Entities|code-block|syntax|javascript|1730891|我得到了下面的错误|1730892|The+Entity+Framework+tools+version+'5.0.14'+is+older+than+that+of+the+runtime+'6.0.8'.+Update+the+tools+for+the+latest+features+and+bug+fixes.+See+https://aka.ms/AAc1fbw+|1730893|然后在包管理器控制台中运行以下脚本：|1730894|dotnet+tool+update+--global+dotnet-ef+--version+6.0.8|1730895|entityMap^0|0|M|10|1N|13|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]|$D|12|E|13|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|17|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|V|5|L|7|19|8|@]|9|@]|A|$M|N]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

I just went through that exercise, and followed the following steps.
First Using nuget package manager install the following: <code>Microsoft.EntityFrameworkCore.Design</code> and
<code>Microsoft.EntityFrameworkCore.SqlServer</code>
Then run the following in package manager console:
<pre><code>dotnet ef dbcontext scaffold &quot;Data Source=.;Initial Catalog=databaseName;Trusted_Connection=true&quot; Microsoft.EntityFrameworkCore.SqlServer --output-dir Entities
</code></pre>
I did get the error below
<pre><code>The Entity Framework tools version '5.0.14' is older than that of the runtime '6.0.8'. Update the tools for the latest features and bug fixes. See https://aka.ms/AAc1fbw 
</code></pre>
Then I run the following script in package manager console:
<pre><code>dotnet tool update --global dotnet-ef --version 6.0.8
</code></pre>

blocks|key|1718974|text|正如评论中提到的，我也在使用EF核心动力工具。有时，EF核心动力工具会给出关于失败的错误，你可以看到你错过了什么。绝对应该给你一次机会。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1718975|在MS学习网站上，他们说“为DbContext生成代码，为数据库生成实体类型。为了使这个命令生成一个实体类型，数据库表必须有一个主键”。还有很多信息。|1718976|很少情况下，我们会忘记给我们的桌子加钥匙。表的字段类型可能不兼容。|1718977|EF核心MS学习|offset|length|1718978|entityMap|0|LINK|mutability|MUTABLE|url|https://learn.microsoft.com/en-us/ef/core/cli/dotnet#dotnet-ef-dbcontext-scaffold^0|0|0|0|0|8|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

As mentioned in the comments, I'm using EF Core Power Tools, too. Sometimes, EF Core Power Tools gives errors about failure and you can see what you are missing. Definitely should be given a chance...
At the MS EF learn website, they said that &quot;Generates code for a DbContext and entity types for a database. In order for this command to generate an entity type, the database table must have a primary key&quot;. Also there are a lot of informations.
Rarely, we can forget to add keys to our tables. Tables' fields' types maybe incompatible.
<a href="https://learn.microsoft.com/en-us/ef/core/cli/dotnet#dotnet-ef-dbcontext-scaffold" rel="nofollow noreferrer">EF Core | MS Learn</a>

I try to use Entity Framework in a minimal API running in a .NET Core 6 project. As far as I understand I should run <code>dotnet ef dbcontext scaffold xxxx</code> which I do, I don't get any errors but no models are added to my project.
Can someone please explain how I can use DB first approach with CRUD functionality?

How can I use DB first approach in .NET Core 6?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我尝试在运行在.NET核心6项目中的最小API中使用实体框架。据我所知，我应该运行dotnet ef dbcontext scaffold xxxx，但我没有收到任何错误，但是没有向我的项目添加任何模型。有人能解释一下我如何使用DB第一方法和CRUD功能吗？

问如何在.NET核心6中使用DB第一方法？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在.NET核心6中使用DB第一方法？EN