17,741
社区成员
发帖
与我相关
我的任务
分享
using(var context=new MMSConnection())
{
}
public class MMSConnection : DbContext
{
//
// Summary:
// Creates a Database instance for this context that allows for creation/deletion/existence
// checks for the underlying database.
public MMSConnection()
: base("name=LocalConnection")
{
}
//报警
public DbSet<DB_Alarm> Alarms { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
//注意:类对应的数据库表名必须全为小写字母,因为MySQL数据库table和schema的命名不支持大写。
modelBuilder.Entity<DB_Alarm>().ToTable("alarm");
}
}
以下是配置文件中的链接语句
<add name="LocalConnection" connectionString="Data Source=localhost;port=3306;Initial Catalog=MMSDB;Max Pool Size=30; Min Pool Size=5;user id=root;password=***" providerName="MySql.Data.MySqlClient" />