SampleDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.70.242)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)))" />

OracleDbContext" providerName="Oracle.ManagedDataAccess.Client" connectionString="User Id=C##EF1;Password=ef1;Data Source=SampleDataSource" />

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"));

}

}