Entity Framework 6.x Code Frist For Oracle 实践与注意点

<configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </configSections>

public class Blog { public int BlogId { get; set; } [MaxLength(50)] public string Url { get; set; }   }

public class MyDbContext: DbContext { public MyDbContext() : base("Name=OracleDbContext") {   Database.SetInitializer<MyDbContext>(null); } public DbSet<Blog> Blogs { get; set; }   public DbSet<Post> Posts { get; set; }   protected override void OnModelCreating(DbModelBuilder modelBuilder) { //注意：Oracle必须定义成用户名/所有者或是称Schema，（SQL默认是dbo） modelBuilder.HasDefaultSchema("C##EF1"); //注意：Oracle必须把所有mapping的字段名转换成大写，否则无法在pl/sql developer中用sql查询 modelBuilder.Properties().Configure(x => x.HasColumnName(x.ClrPropertyInfo.Name.ToUpper())); //注意：Oracle必须把所有mapping的数据库表名转换成大写，否则无法在pl/sql developer中用sql查询 modelBuilder.Types().Configure(c => c.ToTable(c.ClrType.Name.ToUpper())); //注意：如果字段名是string类型再没有设定MaxLength/Type属性的情况下默认给250长度/NVARCHAR2类型，否则系统会自动创建成NCLOG类型 modelBuilder.Properties<string>().Configure(c => c.HasMaxLength(250)); modelBuilder.Properties<string>().Configure(c => c.HasColumnType("NVARCHAR2")); }   }