1.添加包引用：

Microsoft.EntityFrameworkCore.Relational

Oracle.EntityFrameworkCore

2.重寫DbContext OnModelCreating

///

/// 判斷如果是Oracle，需要執行Schema

///

///

protected override void OnModelCreating(ModelBuilder modelBuilder)

{

//判斷當前數據庫是Oracle 需要手動添加Schema(DBA提供的數據庫賬號名稱)

if (this.Database.IsOracle())

{

modelBuilder.HasDefaultSchema(new SqlConnectionStringBuilder(Database.GetDbConnection().ConnectionString).UserID.ToUpper());

}

base.OnModelCreating(modelBuilder);

}

3.在DbContextConfigurer 中啟用oracle連接

public static class EzxDbContextConfigurer

{

public static void Configure(DbContextOptionsBuilder builder, string connectionString)

{

//builder.UseSqlServer(connectionString);

builder.UseOracle(connectionString);

}

public static void Configure(DbContextOptionsBuilder builder, DbConnection connection)

{

builder.UseSqlServer(connection);

}

}

4.在appsettings.json中添加Oracle的字符串的配置

{

"ConnectionStrings": {

//"Default": "Server=localhost; Database=EzxDb; Trusted_Connection=True;"

"Default": "User Id=cis;Password=cis;Data Source=127.0.0.1:1521/hisbd"

},

"Authentication": {

"JwtBearer": {

"IsEnabled": "true",

"SecurityKey": "Ezx_C421AAEE0D114E9C",

"Issuer": "Ezx",

"Audience": "Ezx"

}

},

"Logging": {

"IncludeScopes": false,

"LogLevel": {

"Default": "Debug",

"System": "Information",

"Microsoft": "Information"

}

}

}

原文：https://www.cnblogs.com/wu-dy/p/12885748.html