EFOracleProvider Wiki Rss Feed

UPDATED WIKI: Home

jkowalski — Wed, 13 Aug 2008 04:55:50 GMT

This is a Sample Entity Framework Provider for Oracle. It works with Oracle 10g by wrapping System.Data.OracleClient APIs. It uses the same technique as Entity Framework Sample Provider which wraps System.Data.SqlClient.

Sample Entity Framework Provider for Oracle 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.
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.
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).

UPDATED WIKI: Home

jkowalski — Tue, 24 Jun 2008 01:15:02 GMT

This is a Sample Entity Framework Provider for Oracle. It works with Oracle 10g by wrapping System.Data.OracleClient APIs. It uses the same technique as Entity Framework Sample Provider which wraps System.Data.SqlClient.

Sample Entity Framework Provider for Oracle is compatible with Entity Framework released as part of .NET Framework 3.5 SP1 Beta http://blogs.msdn.com/adonet/archive/2008/05/11/visual-studio-2008-sp1-beta-net-3-5-sp1-beta.aspx.

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).

UPDATED WIKI: Home

jkowalski — Tue, 24 Jun 2008 01:12:08 GMT

Resource Page Description
Sample 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).

UPDATED WIKI: Home

jkowalski — Tue, 24 Jun 2008 01:11:42 GMT

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

{BINARYFLOAT/BINARYDOUBLE} 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).

UPDATED WIKI: Home

jkowalski — Tue, 24 Jun 2008 01:11:14 GMT

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

BINARYFLOAT/BINARYDOUBLE 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).

UPDATED WIKI: Home

jkowalski — Tue, 24 Jun 2008 01:10:36 GMT

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

BINARYFLOAT/BINARYDOUBLE 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).

UPDATED WIKI: Home

jkowalski — Tue, 24 Jun 2008 01:08:30 GMT

Resource Page Description
Sample 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.

This is a Sample Entity Framework Provider for Oracle. It 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 Beta.

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

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

BINARYFLOAT/BINARYDOUBLE 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.

UPDATED WIKI: Home

jkowalski — Sat, 21 Jun 2008 01:53:33 GMT