I'm connecting to an Oracle 12.1 database where schema name is all upper-case characters. In .NET core with EF core code, I use
Code: Select all
modelBuilder.HasDefaultSchema(<schemaName>);
method. If I specify schema name as all uppercase in .NET code, DevArt driver generates SQL statement like this:
Code: Select all
SELECT "t".ID
FROM <schema name>.<table name> "t"
However, if I specify at least one lower-case letter in schema name, it generates the statement where schema name is in double quotes, which apparently makes it case sensitive.
Code: Select all
SELECT "t".ID
FROM "<schema name>".<table name> "t"
I don't quite understand why it's not putting double quotes in one case, but then putting quotes in another case. I want schema name being without double quotes in all cases, which would make it case-insensitive. Is there a way to do that?
Thanks,
Eric