CODEWITHSUNDEEP
oracle-databasec#-4.0entity-framework-4ef-code-first
andrecarlucci
andrecarlucci

Reputation: 6296

How to remove database namespace from generated sqls from EF4.1 code-first when using Oracle?

I'm trying Entity Framework 4.1 Code-first with the new oracle provider.

I've created a simple object to insert into the database but I'm getting an insert error. Looking at the tracers I find the sql:

insert into "dbo"."TB_TEST"("STR_NAME", "DT_HR_DATE", "NUM_VALUE")
values (:p1, :p2, :p3)

As you can see, EF is adding a namespace "dbo" before my table name and obviously oracle has no idea what "dbo" is.

How to remove the namespace prefix?

Upvotes: 1

Views: 308

Answers (1)

DCookie
DCookie

Reputation: 43523

It seems that perhaps EF thinks that maybe this is a SQL Server connection? Isn't dbo the standard database owner in SQL Server?

Upvotes: 1

Related Questions