Resource Page DescriptionSample Entity Framework Provider for Oracle. Works with Oracle 10g by wrapping System.Data.OracleClient APIs. It is compatible with Entity Framework released as part of .NET Framework 3.5 SP1.
DISCLAIMER This is an unsupported sample and should be treated as such. Although reasonable effort has been put to make sure that basic EF scenarios work with Oracle, there are certain limitations. Use in production environment is strongly discouraged. INSTALLATION
- Install Visual Studio 2008 SP1 Beta.
- Install Oracle 10g Express Edition from http://www.oracle.com/technology/software/products/database/xe/index.html
- Add new user "edmuser" with password "123456" (if you change the user name/password you will need to update connection strings). The user needs to have permissions to create database objects (assigning the user to DBA role is the quickest way to give necessary permissions).
- The default connection string is using XE name from tnsnames.ora. If you have installed a different version of Oracle or used different instance configuration, you will have to update connection strings in App.config files.
- Review "OracleNorthwind/install_db.cmd" and adjust path to sqlplus.exe as necessary then run the batch file. It will create and populate a Northwind sample database in "edmuser" schema.
- Open the solution file EFOracleProvider.sln and run "EFOracleProvider.AdHocTests" and "Entity Framework Query Samples"
KNOWN ISSUES
- BINARY_FLOAT/BINARY_DOUBLE types are not supported. This is a limitation of underlying System.Data.OracleClient. Columns using those types have been replaced with NUMBER.
- Subqueries with aggregates are not supported. See RunNestedSubquery() method for an example. Users will see ORA-00904. This issue in Entity Framework has been fixed in post-beta builds and the fix will be included in final version of Visual Studio 2008 SP1.
- FunctionImportMapping does not call GetEdmType() when validating parameter mapping. As a result it is not possible to map Edm.Int32 to Oracle.EFOracle(Precision=11,Scale=0). This issue in Entity Framework has been fixed in post-beta builds and the fix will be included in final version of Visual Studio 2008 SP1.
- Oracle DDEX Provider for Visual Studio is not included. Example DDEX provider that supports SQL Server is available as part of EF Sample Provider at http://code.msdn.microsoft.com/EFSampleProvider
- APPLY operator is not supported by Oracle. As a result, certain queries that internally use this operator (such as "Average - Grouping 1", "Max - Grouping", "Min - Grouping") are not supported.
- Certain functions (AVG in particular) return numeric values that cannot be properly materialized as decimal by System.Data.OracleClient. As a result users will get OCI-22053 (overflow).
|