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 VirtualDbset<influencersuser> Influencersuser {Get;Set; } protected Override voidonmodelcreating (Dbmodelbuilder modelBuilder) {}}}
2. The value of column "IsPrimaryKey" in Table "Tabledetails" is DBNull
Workaround:
Set Global optimizer_switch='derived_merge=off';
Http://stackoverflow.com/questions/33575109/mysql-entity-the-value-for-column-isprimarykey-in-table-tabledetails-is
http://bugs.mysql.com/bug.php?id=79163
Https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
3.
[Table ("Tb_user", schema = "User_snapsia")]//dbo schema in Oracle database for user name Public Partial classTb_user {[Key] [Stringlength ( -)] Public stringID {Get;Set; } [Stringlength ( -)] Public stringUSERNAME {Get;Set; } [Stringlength ( -)] Public stringPWD {Get;Set; } }
Public Partial classOrclcontext:dbcontext { PublicOrclcontext ():Base("Name=orclcontext") { } Public VirtualDbset<tb_user> Tb_user {Get;Set; } Public VirtualDbset<tb_syys> Tb_syys {Get;Set; } Public VirtualDbset<tb_cct> Tb_cct {Get;Set; } protected Override voidonmodelcreating (Dbmodelbuilder modelBuilder) { Modelbuilder.hasdefaultschema ( "User_snapsia"); DBO schema in Oracle database for user name modelbuilder.entity<TB_USER>() . Property (e=e.id). Isunicode (false); } }
Two issues during the use of Entity Framework 6 Code First +mvc5+mysql/oracle