I would like Entity Framework v6 to not use quotes around identifiers when executing transactions against the database. Is it possible to configure the DbContext to do this without creating a configuration file for every entity?
For example:
Instead of
SELECT "ApplicationId"
FROM "dbo"."Applications";
I want
SELECT ApplicationId
FROM dbo.Applications;
Will Entity Framework be able to correctly map properties and entities to the database fields and tables correctly?
EDIT:
Rather than try to eliminate the quotation marks, I should have indicated that my goal is to interface with an Oracle DB. Oracle will require using quotation marks around identifiers that contain lowercase letters. So, I should probably change my request to indicate that I need all uppercase identifiers.
I came up with part of a solution in the OnModelCreating method of the DbContext, but it won't handle Foreign Key identifiers:
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Properties()
.Configure(c => c.HasColumnName(c.ClrPropertyInfo.Name.ToUpperInvariant()));
modelBuilder.Types()
.Configure(c => c.ToTable(c.ClrType.Name.ToUpperInvariant()));
}