模板网站建设流程,机械加工外协加工网,广告公司制作,商标购买在哪个平台好从Code MSDN上下载下来的EFOracleProvider不支持Oracle9i.但是,目前我所使用的还是Oracle9i。为此,对EFOracleProvider修改了以下#xff0c;以便使其支持Oracle9i.下面说说具体修改地方.(红色部分为添加或修改的代码部分)一#xff0c;修改EFOracleProvider1,修改EFOraclePr…从Code MSDN上下载下来的EFOracleProvider不支持Oracle9i.但是,目前我所使用的还是Oracle9i。为此,对EFOracleProvider修改了以下以便使其支持Oracle9i.下面说说具体修改地方.(红色部分为添加或修改的代码部分)一修改EFOracleProvider1,修改EFOracleProviderManifest.cs类文件,internal const string TokenOracle9i 9i;//add by xray2005internal const string TokenOracle10g 10g;internal const string TokenOracle11g 11g;以下两个地方,不修改也是可以的.但考虑目前我主要是使用9i,所以也就修改成9i了.private EFOracleVersion _version EFOracleVersion.Oracle9i; //EFOracleVersion.Oracle11g;private string _token TokenOracle9i; //TokenOracle10g;2,修改EFOracleVersion.cs类文件如下代码所示namespaceEFOracleProvider{using System;/// ///This enum describes the current storage version/// internal enum EFOracleVersion{Oracle9i 9, //add by xray2005/// ///Oracle10g/// Oracle10g 10,/// ///Oracle 11g/// Oracle11g 11,// higher versions go here}/// ///This class is a simple utility class that determines the version from the///connection/// internal static class EFOracleVersionUtils{/// ///Get the version from the connection./// /// current connection/// version for the current connectioninternal static EFOracleVersion GetStorageVersion(EFOracleConnection connection){string serverVersion connection.ServerVersion;if (serverVersion.StartsWith(9.)){return EFOracleVersion.Oracle9i;//add by xray2005}else if (serverVersion.StartsWith(10.)){return EFOracleVersion.Oracle10g;}else if (serverVersion.StartsWith(11.)){return EFOracleVersion.Oracle11g;}throw new ArgumentException(Could not determine storage version; a valid storage connection or a version hint is required.);}internal static string GetVersionHint(EFOracleVersion version){switch (version){case EFOracleVersion.Oracle9i:return EFOracleProviderManifest.TokenOracle9i;//add by xray2005case EFOracleVersion.Oracle10g:return EFOracleProviderManifest.TokenOracle10g;case EFOracleVersion.Oracle11g:return EFOracleProviderManifest.TokenOracle11g;default:throw new ArgumentException(Could not determine storage version; a valid storage connection or a version hint is required.);}}internal static EFOracleVersion GetStorageVersion(string versionHint){if (!string.IsNullOrEmpty(versionHint)){switch (versionHint){case EFOracleProviderManifest.TokenOracle9i:return EFOracleVersion.Oracle9i;//add by xray2005case EFOracleProviderManifest.TokenOracle10g:return EFOracleVersion.Oracle10g;case EFOracleProviderManifest.TokenOracle11g:return EFOracleVersion.Oracle11g;}}throw new ArgumentException(Could not determine storage version; a valid storage connection or a version hint is required.);}internal static bool IsVersionX(EFOracleVersion storageVersion){return storageVersion EFOracleVersion.Oracle9i || storageVersion EFOracleVersion.Oracle10g ||storageVersion EFOracleVersion.Oracle11g;//add by xray2005}}}二使用EFOracleProvider修改完毕后,编译一下.如果是自己下载的源代码编译的,那么编译后的EFOracleProvider自动已经在GAC注册了.如果是手动注册EFOracleProvider到GAC那么命令如下gacutil –I“EFOracleProvider.dll”其中gacutil.exe位于系统盘符号:\Program Files\Microsoft SDKs\Windows\v6.0A\bin下面。接下来我们需要做的就是,把这个EFOracleProvider添加到Machine.config中.第一步,找到Machine.config文件.该文件的位置在:系统盘符号:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG下面.第二步,用打开Machine.config文件,在DbProviderFactories配置节点,增加EFOracleProvider的配置,如下所示:description.Net Framework Data Provider for OdbctypeSystem.Data.Odbc.OdbcFactory, System.Data, Version2.0.0.0,Cultureneutral, PublicKeyTokenb77a5c561934e089 /description.Net Framework Data Provider for OleDbtypeSystem.Data.OleDb.OleDbFactory, System.Data, Version2.0.0.0,Cultureneutral, PublicKeyTokenb77a5c561934e089 /invariantSystem.Data.OracleClient description.Net Framework DataProvider for Oracle typeSystem.Data.OracleClient.OracleClientFactory,System.Data.OracleClient, Version2.0.0.0, Cultureneutral,PublicKeyTokenb77a5c561934e089 /invariantSystem.Data.SqlClient description.Net Framework DataProvider for SqlServer typeSystem.Data.SqlClient.SqlClientFactory,System.Data, Version2.0.0.0, Cultureneutral,PublicKeyTokenb77a5c561934e089 /invariantSystem.Data.SqlServerCe.3.5 description.NET Framework DataProvider for Microsoft SQL Server CompacttypeSystem.Data.SqlServerCe.SqlCeProviderFactory,System.Data.SqlServerCe, Version3.5.0.0, Cultureneutral,PublicKeyToken89845dcd8080cc91 /nameEF Oracle Data Provider invariantEFOracleProviderdescriptionEF Provider for OracletypeEFOracleProvider.EFOracleProviderFactory,EFOracleProvider,Version1.0.0.0, Cultureneutral, PublicKeyTokendef642f226e0e59b /第三步,保存即可.接下来简单的介绍一下,如何使用这个EFOralceProvider.第1步:在命令行窗口,将目录定位到提示符, 系统盘符:\WINDOWS\Microsoft.NET\Framework\v3.5.如下所示(是我电脑上的目录):第2步,输入相应的生成参数.如下图所示:将“data sourcetest;user idxray;password 123”成你自己的对应的参数即可.确定之后,就可以看到生成的结果了,同时会有写信息出来,如下示:至此,EdmGen就为我们生成需要的文件.生成的文件如下所示:lTestEFModel.csdllTestEFModel.msllTestEFModel.ssdllTestEFModel.ObjectLayer.cslTestEFModel.Views.cs然后,通过EdmGen2工具, 使用刚刚生成的TestEFModel .csdl, TestEFModel .msl, TestEFModel .ssdl三个文件来生成一个模型.命令如下:Edmgen2.exe /toedmx TestEFModel.csdl TestEFModel.msl TestEFModel.ssdl确定之后,该工具就会为我们生成一个TestEFModel.edmx文件了.然后,把这个文件加入到我们的项目中,同时修改项目的App.Config文件连接字符串,如下所示:connectionStringproviderEFOracleProvider;metadatares://*/TestEFModel.csdl|res://*/TestEFModel.ssdl|res://*/TestEFModel.msl;Provider Connection Stringdata sourcetest;user idxray;password1111providerNameSystem.Data.EntityClient /最后保存.至此修改EFOracleProvider并使用介绍完毕。最后提供几个连接以方便大家学习研究
