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{....
发表评论