EF 6 with ODP.Net Oracle.ManagedDataAccess，如何对类属性使用非大写字母

我正在为我的 ASP.Net MVC Web应用程序使用EF 6和 ODP.Net Oracle.ManagedDataAccess。

我有以下称为Employee的Model(Model'Employee.cs文件中(：

[Table("TBLEMPLOYEE")]
public class Employee {
    public int Id { get; set; }
    public string Name { get; set; }
    public string Gender { get; set; }
    public DateTime DateOfBirth { get; set; }
    public int EmployeeType { get; set; }
    public double? AnnualSalary { get; set; }
    public double? HourlyPay { get; set; }
    public double? HoursWorked { get; set; }
    public string City { get; set; }
}

以及EmployeeContext.cs

public class EmployeeContext : DbContext {
    public DbSet<Employee> Employees { get; set; }
    protected override void OnModelCreating(DbModelBuilder modelBuilder) {
        modelBuilder.HasDefaultSchema("myschema");
    }
}

然后，在我的EmployeeController.cs中，我像这样使用Employee和EmployeeContext：

public ActionResult Details(int id = 1) {
    try {
        EmployeeContext employeeContext = new EmployeeContext();
        employeeContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
        Employee employee = employeeContext.Employees.Single(x => x.ID == id);
        return View(employee);
    } catch (Exception e) {
        return View(e);
    }
}

当我收到以下内部异常错误时：

Oracle.ManagedDataAccess.Client.OracleException： ORA-00904： "Extent1"."Id"：标识符无效

异常错误发生在：

Employee employee = employeeContext.Employees.Single(x => x.ID == id);

当我使用 Debug 输出控制台进一步调试时，我注意到 EF 生成以下 SQL 查询来提取数据：

SELECT 
"Extent1"."Id" AS "Id", 
"Extent1"."Name" AS "Name", 
"Extent1"."Gender" AS "Gender", 
"Extent1"."DateOfBirth" AS "DateOfBirth", 
"Extent1"."EmployeeType" AS "EmployeeType", 
"Extent1"."AnnualSalary" AS "AnnualSalary", 
"Extent1"."HourlyPay" AS "HourlyPay", 
"Extent1"."HoursWorked" AS "HoursWorked", 
"Extent1"."City" AS "City"
FROM "MYSCHEMA"."TBLEMPLOYEE" "Extent1"
WHERE ("Extent1"."Id" = :p__linq__0) AND (ROWNUM <= (2) )

随着我做更多的研究，我了解到由于 SQL 查询列名(例如 ."Id"、".EmployeeType"、".HourlyPay" 等(中" "引号的存在，查询找不到匹配的列名，因为 Oracle 数据表列名都用大写字母表示(即： ."ID"、".EMPLOYEETYPE"、".HOURLYPAY"等(。

现在，当我将类定义更改为如下所示时：

[Table("TBLEMPLOYEE")]
public class Employee {
    public int ID { get; set; }
    public string NAME { get; set; }
    public string GENDER { get; set; }
    public DateTime DATEOFBIRTH { get; set; }
    public int EMPLOYEETYPE { get; set; }
    public double? ANNUALSALARY { get; set; }
    public double? HOURLYPAY { get; set; }
    public double? HOURSWORKED { get; set; }
    public string CITY { get; set; }
}

它工作得很好。但我不想这样。

作为一个典型的 C# 编码人员，我发现类字段/属性全大写字母非常不寻常。

我的问题是，有没有办法使用大写和小写字母的组合来保留类属性，仅用于查询，生成这些属性的大写字母版本？

同样，如果这些事情很重要，我会使用 EF 6.0.0.0 和 ODP.Net Oracle.ManagedDataAccess版本 4.121.2.0 和Oracle.ManagedDataAccess.EntityFramework版本 6.121.2.0。

[Table("TBLEMPLOYEE")]
public class Employee {
    [Column("ID")]
    public int Id { get; set; }
    [Column("NAME")]
    public string Name { get; set; }
    etc...
}

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    //Configure Column
    modelBuilder.Entity<Employee>()
                .Property(p => p.Id)
                .HasColumnName("ID");
    modelBuilder.Entity<Employee>()
                .Property(p => p.Name)
                .HasColumnName("NAME");
}

using System.Data.Entity.ModelConfiguration.Conventions;
using System.Data.Entity.Core.Metadata.Edm;
public class UppercaseColumnNameConvention : IStoreModelConvention<EdmProperty>
{
    public void Apply(EdmProperty item, DbModel model)
    {
        item.Name = item.Name.ToUpper();
    }
}

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Conventions.Add<UppercaseColumnNameConvention>();
    // ...
}