efcore/EFCore.NamingConventions

Not working with Oracle

michelevirgilio opened this issue · 2 comments

Microsoft.EntityFrameworkCore 8.0.3
Oracle.EntityFrameworkCore 8.21.121
EFCore.NamingConventions latest clone

Hi, i'm trying to use the extension in my solution with a Oracle connection. I've added the EFCore.NamingConventions project reference inside my solution and used this code:

              builder.Services.AddDbContext<MyOracleContext>(options => 
                {
                    options.UseOracle(connectionString);
                    options.LogTo(Console.WriteLine);
                    options.UseUpperCaseNamingConvention();
                });

i can see the hit during debug of the method

    public string RewriteName(string name)
        => name.ToUpper(_culture);

of UpperCaseNameRewriter

but the materialized query still have no uppercase names.
Maybe i'm missing some settings?
Thanks

Any help?

roji commented

@michelevirgilio it's hard to help without a minimal, runnable code sample - the above is just a snippet... I also don't have Oracle installed, so I'd suggest trying to temporarily switch to a different database provider (e.g. SQLite/SQL Server/PostgreSQL) just to check; if the problem persists there (as I suspect it will), that's something I can investigate much more easily (though I'd still need a minimal code sample. If it doesn't reproduce, then there's something in the Oracle EF provider that's causing the issue and it would have to be investigated in that context.