Tips

This is just a dump of a few things we came across. Better here than not at all.

Main step by step guide to getting started.

http://blogs.msdn.com/jkowalski/archive/2008/10/24/using-ef-oracle-sample-provider-with-edm-designer.aspx?CommentPosted=true#commentmessag

no point redoing.


step 10. (in the above post) the ssdl generated by edmgen in .net 3.5 sp1 requires replacing 'store:Schema="dbo"' with NOTHING and 'Schema="dbo"' with NOTHING btw. This is again oracle 11g. NOTE: store:Schema vs. Schema


step 8. (in the above post)

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


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.

Last edited Sep 17, 2009 at 7:48 PM by JA, version 1

Comments

No comments yet.