Using EF Oracle Sample Provider with EDM Designer

re: Using EF Oracle Sample Provider with EDM Designer

Padma Alluri — Fri, 12 Dec 2008 14:31:45 GMT

I am facing the problem on using this EFOracleSampleProvider.

I have done all the first 7 steps what you mentioned in the article, But when i run the following command

%WINDIR%\Microsoft.NET\Framework\v3.5\edmgen.exe /provider:EFOracleProvider /mode:fullgeneration /connectionstring:"data source=XE;user id=edmuser;password=123456" /project:NorthwindEFModel

it is giving error as

error 7001: The provider did not return a ProviderManifestToken string. ORA-12154: TNS:could not resolve the connect identifier specified

I have given the correct cridentials to connectionstring.

please give us the solution for the above error.

re: Using EF Oracle Sample Provider with EDM Designer

borismod — Thu, 25 Dec 2008 19:26:18 GMT

Padma, if you have 2 Oracle clients installed under your product\[version_number]\, then EFOracleProvider will look for tnsnames.ora in client_2. The workaround is copy tnsnames.ora to client_2 folder as well.

Hope this helps,

Boris

When will the timestamp type be supported?

ZachLi — Thu, 02 Apr 2009 21:09:48 GMT

This is great stuff. When will the timestamp type of oracle will be supported? It is very common type in oracle.

re: Using EF Oracle Sample Provider with EDM Designer

JA — Tue, 12 May 2009 12:35:18 GMT

step 10. the ssdl generated by edmgen in .net 3.5 sp1 requires replacing 'store:Schema="dbo"' with NOTHING. This is again oracle 11g.

re: Using EF Oracle Sample Provider with EDM Designer

JA — Tue, 12 May 2009 14:34:53 GMT

what i said above is in addition to replacing 'Schema="dbo"' with NOTHING btw

re: Using EF Oracle Sample Provider with EDM Designer

JA — Tue, 12 May 2009 21:53:36 GMT

for the benifit of others step 8. can work as follows also

edmgen /provider:EFOracleProvider /mode:fullgeneration /connectionstring:"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ORAdb.yourdomain.co.uk)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORAdb.yourdomain.co.uk)));User Id=your_user_name;Password=your_password;" /project:SomeProjectName

if you get any part of the connection string wrong you will get errors like

Error when invalid SERVICE_NAME is given:

error 7001: The provider did not return a ProviderManifestToken string.

ORA-12514: TNS:listener does not currently know of service requested in

connect descriptor

Error when invalid HOST is given:

error 7001: The provider did not return a ProviderManifestToken string.

ORA-12545: Connect failed because target host or object does not exist

re: Using EF Oracle Sample Provider with EDM Designer

JA — Tue, 12 May 2009 22:39:22 GMT

if you are running the EFOracleProvider along side another modified version based on a copy of the project don't forget to create a new strong name key using sn.exe -k keyname.snk, in the project properties > signing > change to use this .snk file > recompile (the project is set to register in the GAC automagically).

then get the new public token by running sn.exe -T newEForacleProviderAssembly.dll and update the machine.config <DbProviderFactory> (step 5.)

Without this you may get an error saying that the @Provider name in the ssdl file is invalid or not registered properly because it is pointing at the other one that has a different name.

EFOracleSampleProvider that uses odp.net 11.1 rather than MS Oracle client

JA — Tue, 12 May 2009 22:52:15 GMT

have got something working only tested by pulling a single row from a table in an 11g database. Note this database has case sensitive table and column names.

re: Using EF Oracle Sample Provider with EDM Designer

scegg — Mon, 15 Jun 2009 11:17:54 GMT

Hi. I follow all your steps and find this error when I query data.

The Mapping and Metadata information for EntityContainer 'MyDBContext' no longer matches the information used to create the pre generated views.

re: Using EF Oracle Sample Provider with EDM Designer

scegg — Mon, 15 Jun 2009 11:19:35 GMT

If I skip step 10, another error will be displayed to notify me that the table / view I queried is not existed. (bad schema i think)

Using EF Oracle Sample Provider

adrien82 — Wed, 01 Jul 2009 10:48:42 GMT

I have done all the instructions in the guide but I have the following error:

error 7001: Il metodo 'CreateDbCommandDefinition' del tipo 'EFOraclePr

racleProviderServices' dell'assembly 'EFOracleProvider, Version=1.0.0.

=neutral, PublicKeyToken=def642f226e0e59b' non ha un'implementazione.

why this error????

HELP ME

re: Using EF Oracle Sample Provider with EDM Designer

adrien82 — Wed, 01 Jul 2009 13:27:48 GMT

i have resolved....i have changed my framework .NET 3.5 with FRAMEWORK .NET 3.5 Service Pack 1

:-)

EFOracleSampleProvider that uses odp.net 11.1 rather than MS Oracle client

JA — Wed, 08 Jul 2009 14:15:22 GMT

Hi,

Have this project now available on Codeplex at http://eforacleodpprovider.codeplex.com/

re: Using EF Oracle Sample Provider with EDM Designer

adrien82 — Fri, 10 Jul 2009 12:50:12 GMT

I have done all the instructions in the guide but I have the following error when effectued the query:

System.Data.OracleClient.OracleException non è stata gestita dal codice utente

Message="ORA-00942: tabella o vista inesistente\n"

Source="System.Data.OracleClient"

ErrorCode=-2146232008

Code=942

StackTrace:

in System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)

in System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)

in System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)

in System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)

in EFOracleProvider.EFOracleCommand.ExecuteDbDataReader(CommandBehavior behavior)

in System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

in System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

InnerException:

WHY THIS PROBLEM?????? HELP ME thanks

Problem Int64 & Edm.Decimal

Romain Suire — Wed, 26 Aug 2009 16:47:58 GMT

Hi,

I have a problem about Int64 and EDM.Decimal.

In my case, IDs are "number" in my SSDL file, "Int64" in my CSDL file and "Long" in my objects. The problem appears when I try to add entities to database.

Stack Trace : System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.ArgumentException: The specified value is not an instance of type 'Edm.Decimal'

So I decided to look your EFOracleOdpProviderManifest and I fine a solution (maybe not the good one).

In the "GetEdmType()" method, case "number", I add :

if (precision == 0 && scale == 196)

return TypeUsage.CreateDefaultTypeUsage(PrimitiveType.GetEdmPrimitiveType(PrimitiveTypeKind.Int64));