ASP.NET与MSSQL连接修改为与ORACLE连接

先看看与MSSQL连接的写法

WEBCONFIG文件

1. <configuration>
2.   <appSettings>
3.     <add key="DBConnectionString" value="server=(local);database=MyOA;User Id=sa;pwd=123" />
4.   </appSettings>
5. <connectionStrings/>

Database.cs     

1. using System.Data.SqlClient;
3. public class Database
4. {
5.      protected SqlConnection Connection;
6.      protected String ConnectionString;
8.      /// <summary>
9.      /// 构造函数
10.      /// </summary>
11.      public Database()
12.      {
13.         ConnectionString = ConfigurationSettings.AppSettings["DBConnectionString"];
14.      }
15. }

修改为ORACLE连接的话可以参照

 

1. <?xml version="1.0"?>
2. <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
4.   <connectionStrings>
5.        <!-- 
6.             连接oracle
7.         -->
8.     <add name="DBConnectionString" connectionString="Data Source=servername;Persist Security Info=True;User ID=sysuser;Password=sysuser;Unicode=True" providerName="System.Data.OracleClient"/>
9.   </connectionStrings>
11.   <system.web>
12.     <compilation debug="true">
13.       <assemblies>
14.         <!-- 
15.             配置oracle
16.         -->
17.         <add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
18.       </assemblies>
19.     </compilation>
20.   </system.web>
21. </configuration>

Database.cs文件

1. using System.Data.OracleClient;
3. public class Database
4. {
5.      protected OracleConnection Connection;
6.      protected String ConnectionString;
8.      /// <summary> 
9.      /// 构造函数 
10.      /// </summary> 
11.      public Database()
12.      {
13.         ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString ;
14.      }
15. }

然后把后面的sqlcommand  sqladapter之类全部换成oracle