I'm testing out the Oracle Beta (126.96.36.199) with the entity framework (4.1) and MVC and running into a couple problems.
I figured the easiest test would be to take a completed project (MVC music store tutorial on this site) and try to convert the connection string of the DBContext object to point to an oracle server populated with the tables. Initially I had a problem with the default schema name of "dbo" which I overrode in "OnModelCreating". Now that it is pointing to the right schema/table I get an 'ORA-00904: Invalid identifier' error. I think this is due to how the LINQ query is being processed.
The inner exception is "ORA-00904: \"Extent1\".\"ArtistId\": invalid identifier" and the value it shows for my DBContext object is:
CAST( "Extent1"."ArtistId" AS number(9,0)) AS "C1",
"Extent1"."Name" AS "Name"
FROM "MVCTEST"."ARTISTS" "Extent1"
I think the problem is with the extra quotation marks around everything; If I get rid of those I can run the query in Oracle. So basically I want to know if it's possible to override the formatting of the queries through the DBContext object to lose the quotation marks or some other way to accomplish the same goal. I appreciate any help you all could give me.
View Complete Post