visual studio 2019从mysql数据库表通过命令自动生成实体类模型
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了visual studio 2019从mysql数据库表通过命令自动生成实体类模型,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含14404字,纯文字阅读大概需要21分钟。
内容图文
![visual studio 2019从mysql数据库表通过命令自动生成实体类模型](/upload/InfoBanner/zyjiaocheng/526/4529ec87475a420996a867a04c6f932a.jpg)
一、通过Nuget 安装依赖包,命令如下:
Install-package mysql.data.entity -Version 6.8.8
Install-package mysql.data -Version 6.10.9
Install-package mysqlConnector -Version 0.68.0
install-package pomelo.entityFrameWorkCore.mysql
install-package Microsoft.EntityFrameworkCore
install-package Microsoft.EntityFrameworkCore.Tool
二、 Scaffold-DbContext "Server=MysqlServerIP;Database=MysqlDatabaseName;UserID=YourMysqlUserID;Password=YourMysqlUserPassword;port=3306;Charset=utf8;pooling=true;Allow User Variables=True;" Pomelo.EntityFrameworkCore.MySql -OutputDir YourOutputdirPath -tables YourTableName
最后,强调一点,这个windows下测试成功的,命令不区分大小写,linux下面是区分大小写的。最重要的是版本冲突的解决。附上所有测试依赖包(get-package):
Id Versions ProjectName
BouncyCastle {1.8.3.1} testframework2
EntityFramework {6.2.0} testframework2
EntityFramework.zh-Hans {6.2.0} testframework2
Google.Protobuf {3.6.1} testframework2
K4os.Compression.LZ4 {1.1.11} testframework2
K4os.Compression.LZ4.Streams {1.1.11} testframework2
K4os.Hash.xxHash {1.0.6} testframework2
Microsoft.AspNet.Mvc {5.2.7} testframework2
Microsoft.AspNet.Mvc.zh-Hans {5.2.7} testframework2
Microsoft.AspNet.Razor {3.2.7} testframework2
Microsoft.AspNet.Razor.zh-Hans {3.2.7} testframework2
Microsoft.AspNet.WebApi {5.2.7} testframework2
Microsoft.AspNet.WebApi.Client {5.2.7} testframework2
Microsoft.AspNet.WebApi.Client.z... {5.2.7} testframework2
Microsoft.AspNet.WebApi.Core {5.2.7} testframework2
Microsoft.AspNet.WebApi.Core.zh-... {5.2.7} testframework2
Microsoft.AspNet.WebApi.WebHost {5.2.7} testframework2
Microsoft.AspNet.WebApi.WebHost.... {5.2.7} testframework2
Microsoft.AspNet.WebPages {3.2.7} testframework2
Microsoft.AspNet.WebPages.zh-Hans {3.2.7} testframework2
Microsoft.Bcl.AsyncInterfaces {1.1.1} testframework2
Microsoft.Bcl.HashCode {1.1.0} testframework2
Microsoft.CodeDom.Providers.DotN... {2.0.1} testframework2
Microsoft.CSharp {4.7.0} testframework2
Microsoft.EntityFrameworkCore {3.1.6} testframework2
Microsoft.EntityFrameworkCore.Ab... {3.1.6} testframework2
Microsoft.EntityFrameworkCore.An... {3.1.6} testframework2
Microsoft.EntityFrameworkCore.De... {3.1.6} testframework2
Microsoft.EntityFrameworkCore.Re... {3.1.6} testframework2
Microsoft.EntityFrameworkCore.Tools {3.1.6} testframework2
Microsoft.Extensions.Caching.Abs... {3.1.6} testframework2
Microsoft.Extensions.Caching.Memory {3.1.6} testframework2
Microsoft.Extensions.Configuration {3.1.6} testframework2
Microsoft.Extensions.Configurati... {3.1.6} testframework2
Microsoft.Extensions.Configurati... {3.1.6} testframework2
Microsoft.Extensions.DependencyI... {3.1.6} testframework2
Microsoft.Extensions.DependencyI... {3.1.6} testframework2
Microsoft.Extensions.Logging {3.1.6} testframework2
Microsoft.Extensions.Logging.Abs... {3.1.6} testframework2
Microsoft.Extensions.Options {3.1.6} testframework2
Microsoft.Extensions.Primitives {3.1.6} testframework2
Microsoft.Web.Infrastructure {1.0.0.0} testframework2
MySql.Data {6.10.9} testframework2
MySql.Data.Entity {6.8.8} testframework2
MySql.Data.EntityFrameworkCore {6.10.9} testframework2
MySqlConnector {0.68.0} testframework2
Newtonsoft.Json {12.0.2} testframework2
Pomelo.EntityFrameworkCore.MySql {3.1.1} testframework2
Pomelo.JsonObject {2.2.1} testframework2
SSH.NET {2016.1.0} testframework2
System.Buffers {4.5.1} testframework2
System.Collections.Immutable {1.7.1} testframework2
System.ComponentModel.Annotations {4.7.0} testframework2
System.Data.Odbc {4.7.0} testframework2
System.Diagnostics.DiagnosticSource {4.7.1} testframework2
System.Memory {4.5.4} testframework2
System.Numerics.Vectors {4.5.0} testframework2
System.Runtime.CompilerServices.... {4.7.1} testframework2
System.Threading.Tasks.Extensions {4.5.4} testframework2
visual studio 2019从mysql数据库表通过命令自动生成实体类模型
标签:buffer str bho depend database pool mmu end 数据库
本文系统来源:https://blog.51cto.com/10108149/2511468
内容总结
以上是互联网集市为您收集整理的visual studio 2019从mysql数据库表通过命令自动生成实体类模型全部内容,希望文章能够帮你解决visual studio 2019从mysql数据库表通过命令自动生成实体类模型所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。