1、
namespaceSnapsia.Web.Models
{usingSystem;usingSystem.Data.Entity;usingSystem.ComponentModel.DataAnnotations.Schema;usingSystem.Linq;
[DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]public partial classSnapsiaContext : DbContext
{publicSnapsiaContext()
:base("name=SnapsiaContext")
{
}public virtual DbSet InfluencersUser { get; set; }protected override voidOnModelCreating(DbModelBuilder modelBuilder)
{
}
}
}
2、表“TableDetails”中列“IsPrimaryKey”的值为 DBNull
解决办法:
set global optimizer_switch='derived_merge=OFF';
http://stackoverflow.com/questions/33575109/mysql-entity-the-value-for-column-isprimarykey-in-table-tabledetails-is
3、
[Table("TB_USER", Schema = "USER_SNAPSIA")]//dbo架构在oracle数据库为用户名public partial classTB_USER
{
[Key]
[StringLength(50)]public string ID { get; set; }
[StringLength(50)]public string USERNAME { get; set; }
[StringLength(50)]public string PWD { get; set; }
}
public partial classOrclContext : DbContext
{publicOrclContext()
:base("name=OrclContext")
{
}public virtual DbSet TB_USER { get; set; }public virtual DbSet TB_SYYS { get; set; }public virtual DbSet TB_CCT { get; set; }protected override voidOnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.HasDefaultSchema("USER_SNAPSIA"); //dbo架构在oracle数据库为用户名
modelBuilder.Entity()
.Property(e=>e.ID)
.IsUnicode(false);
}
}
4、VS2015 update3 +MySQL5.7+EntityFramework Code First
从数据库生成Code First 代码,选择连接后点击下一步,界面闪退,无法生成的解决办法。
需要安装最新版的两个组件:
mysql-connector-net-6.9.9
mysql-for-visualstudio-1.2.6
5、使用同一个上下文对象:
public staticSnapsiaContext GetCurrentDbSession()
{
SnaContext context= CallContext.GetData(typeof(DbSessionContextFactory).FullName) asSnaContext;if (context == null)
{
context= newSnaContext();
CallContext.SetData(typeof(DbSessionContextFactory).FullName, context);
}returncontext;
}
6、EntityFramework Code First 优化
6.1、推荐使用IIS8.
https://weblog.west-wind.com/posts/2013/Oct/02/Use-IIS-Application-Initialization-for-keeping-ASPNET-Apps-alive?utm_source=tuicool#GettingstartedwithApplicationInitialization
http://www.cnblogs.com/hantianwei/archive/2013/04/26/3044157.html