asp.net api mvc连接mysql数据库

1、nuget安装MySql.Data.Entity

2、web.config

<connectionStrings>
<add name="sxschool_dotnetContext" connectionString="Server=localhost;Database=schooldb;User=schooldb;Password=123123" providerName="MySql.Data.MySqlClient" />
</connectionStrings>

 

3、在类名上加上限定表名,如果不加,默认搜索schools表

[Table("school")]
public class School{}

4、在数据库上下文连接dbcontext加上标识

[DbConfigurationType(typeof(MySqlEFConfiguration))]
public class sxschool_dotnetContext : DbContext{....

声明:本站内容来源于原创和互联网,尊重作者版权,转载请注明来源网址,欢迎收藏,谢谢!