C# Entity Framework 連接 Oracle：ODP.NET Managed Driver 完整設定指南

核心元件：Oracle.ManagedDataAccess.EntityFramework

**不需安裝 Oracle Client**，純 Managed 程式碼，透過 NuGet 即可完成所有設定。

步驟 1：安裝 NuGet 套件

Install-Package Oracle.ManagedDataAccess.EntityFramework

會自動安裝相依套件：Oracle.ManagedDataAccess、EntityFramework (若專案尚未有)。

步驟 2：App.config / Web.config 設定

步驟 3：DbContext 實作

public class OracleDbContext : DbContext {
    public OracleDbContext() : base("name=OracleDbContext") { }

    public DbSet Employees { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder) {
        modelBuilder.HasDefaultSchema("SCOTT"); // 對應 Oracle Schema
        base.OnModelCreating(modelBuilder);
    }
}

[Table("EMP")]
public class Employee {
    [Key, Column("EMPNO")]
    public int EmpNo { get; set; }

    [Column("ENAME")]
    public string Name { get; set; }

    [Column("JOB")]
    public string Job { get; set; }

    [Column("SAL")]
    public decimal Salary { get; set; }
}

步驟 4：CRUD 範例

using (var db = new OracleDbContext()) {
    // Create
    var emp = new Employee { EmpNo = 9999, Name = "TEST", Job = "CLERK", Salary = 3000 };
    db.Employees.Add(emp);
    db.SaveChanges();

    // Read
    var list = db.Employees.Where(e => e.Salary > 2000).ToList();

    // Update
    var e = db.Employees.Find(9999);
    e.Salary = 3500;
    db.SaveChanges();

    // Delete
    db.Employees.Remove(e);
    db.SaveChanges();
}

常見坑與解決

參考資源

• 官方文件：NuGet 套件頁
• 連接字串參考：ODP.NET Managed 連接字串屬性