Entity Framework Ignore Schema

Question

I am using Entity Framework 6 Code First to connect to an oracle database. EF is using "dbo" as the schema. I would rather not specify the schema, but rather let Oracle resolve the schema from the connection string.

Is there a way to omit "dbo" or any schema from the queries?

Example Given: Instead of "select * from dbo.table" I would like to see "select * from table".

Currently, I am parsing the connection string for the userId and using that as the schema, but I'd prefer to not use this technique.

What does your connection string look like? (Sanitize it first...) — FrankO, Mar 25 '15 at 16:19

score 6 · Answer 1 · answered Jun 09 '16 at 16:24

FrankO's answer is correct in that you can specify the default schema using the Fluent API.

In addition, this same method, in my experience, can be utilized to remove the default schema, allowing Oracle to resolve the schema in the case that it is specified on the connect string or if your companies policy is to access all tables through a public synonym.

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.HasDefaultSchema(string.Empty);
}

This would produce SQL containing FROM "MY_TABLE" instead of FROM "dbo"."MY_TABLE"

I'm using:

EntityFramework 6.1.3
Oracle.ManagedDataAccess 12.1.2400
Oracle.ManagedDataAccess.EntityFramework 12.1.2400

Can I assume this is how you would do it in database-first too? — Deantwo, Jan 31 '19 at 12:49

score 1 · Answer 2 · answered Mar 25 '15 at 16:19

1

You could use Fluent API to declare the default schema like the following:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.HasDefaultSchema("your_schema_here");
}

answered Mar 25 '15 at 16:19

FrankO

2,522
6
24
34

Entity Framework Ignore Schema

2 Answers2