文件列表:

EFOracleSampleProvider (0, 2008-08-07)
EFOracleSampleProvider\EdmGenTests (0, 2008-08-07)
EFOracleSampleProvider\EdmGenTests\EdmGen.exe.config (777, 2008-06-19)
EFOracleSampleProvider\EdmGenTests\Test_EFOracleProvider.cmd (277, 2008-06-20)
EFOracleSampleProvider\EFOracleProvider (0, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\Changes from SP1 Beta.txt (241, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\EFOracleCommand.cs (5453, 2008-06-19)
EFOracleSampleProvider\EFOracleProvider\EFOracleConnection.cs (4514, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\EFOracleDataReader.cs (7706, 2008-06-19)
EFOracleSampleProvider\EFOracleProvider\EFOracleProvider.csproj (4387, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\EFOracleProvider.snk (596, 2008-03-13)
EFOracleSampleProvider\EFOracleProvider\EFOracleProviderFactory.cs (3746, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\EFOracleProviderManifest.cs (25271, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\EFOracleProviderServices.cs (20242, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\EFOracleVersion.cs (3296, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\Helpers (0, 2008-08-04)
EFOracleSampleProvider\EFOracleProvider\Helpers\CommandTreeUtils.cs (4465, 2008-04-21)
EFOracleSampleProvider\EFOracleProvider\Helpers\EntityUtils.cs (690, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\Helpers\MetadataHelpers.cs (12493, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\Properties (0, 2008-08-04)
EFOracleSampleProvider\EFOracleProvider\Properties\AssemblyInfo.cs (1452, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\Resources (0, 2008-08-04)
EFOracleSampleProvider\EFOracleProvider\Resources\EFOracleProviderManifest.xml (4874, 2008-06-19)
EFOracleSampleProvider\EFOracleProvider\Resources\EFOracleStoreSchemaDefinition.ssdl (32403, 2008-06-20)
EFOracleSampleProvider\EFOracleProvider\Resources\EFOracleStoreSchemaMapping.msl (21496, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen (0, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\SqlGen\BasicExpressionVisitor.cs (33323, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\SqlGen\DmlSqlGenerator.cs (23802, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\ISqlFragment.cs (1513, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\JoinSymbol.cs (3564, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\SqlBuilder.cs (3483, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\SqlGenerator.cs (172085, 2008-08-07)
EFOracleSampleProvider\EFOracleProvider\SqlGen\SqlSelectStatement.cs (12538, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\SqlWriter.cs (2385, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\Symbol.cs (4770, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\SymbolPair.cs (1885, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\SymbolTable.cs (2002, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider\SqlGen\TopClause.cs (2689, 2008-04-18)
EFOracleSampleProvider\EFOracleProvider.AdHocTests (0, 2008-08-07)
... ...

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. 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 ============ 1. Install Visual Studio 2008 SP1. 2. Install Oracle 10g Express Edition from http://www.oracle.com/technology/software/products/database/xe/index.html 3. Add new user "edmuser" with password "123456" (if you change the user name/password you will have to modify batch files database scripts and configuration files). Make sure the user has permissions to create database objects (assigning the user to DBA role is the quickest way to give necessary permissions). 4. 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. 5. 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. 6.Open the EFOracleProvider.sln as administrator 7. Build the solution. As part of the build step, the provider will be installed in the GAC. 8. Download, compile and run EFQuerySamples project from http://code.msdn.microsoft.com/EFQuerySamples From the drop-down list, choose EFOracleProvider, pick a test to run and click "Run" KNOWN ISSUES ============ 1. 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. 2. 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. 3. 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. 4. 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. DIRECTORY LAYOUT ================ EFOracleProvider - provider source code EdmGenTests - ad-hoc tests that use EF Oracle Provider to reverse-engineer a Northwind database EFOracleProvider.AdHocTests - ad hoc test NorthwindEFModel - model files OracleNorthwind - database files (SQL)

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：