Entity Framework with Model-First and Oracle -


i'm trying use entity framework model-first on oracle database. have installed odp.net , oracle visual studio tools file odtwithodac1120320_32bit.zip, version 11.2.0.3.20.

i made small test model, set connection string oracle db, changed code generation templates of model generate oracle via t4 (tpt).xaml , ssdltooracle.tt. code generations working, generated sql not usable:

create table "dbo"."entity1set" (    "id" uniqueidentifier not null,    "nvarcharproperty" nvarchar(max) not null ); 

neither uniqueidentifier nor nvarchar valid oracle keywords. furthermore, oracle handles schemas differently sql server, "dbo". stuff won't work.

how handle that? changing sql after every code generation?

are there other ways use ef oracle , model-first?

looks model generated sqlserver , passed ssdltooracle.tt. ssdltooracle.tt file not check if dealing oracle specific storeitemcollection , uses gets results in generating hybrid of oracle specific sql using sqlserver types. can check database model generated opening edmx file , checking provider , providermanifesttoken attributes.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -