using?System;

namespace?Teaching.DAC
{
	///?

	///?對數據源連接字符串構成的封裝，可以生成不同數據源的連接字符串。
	///?

	public?class?ConnectionStringHelper
	{
		public?ConnectionStringHelper（）
		{
			//
			//?TODO:?Add?constructor?logic?here
			//
		}

		//?創建Sql?Server以用戶授權方式訪問的數據庫連接字符串
		//?“Data?Source=Aron1;Initial?Catalog=pubs;User?Id=sa;Password=asdasd;“?
		static?public?string?CreateSqlConnectionString（string?server?string?database?string?userId?string?password）
		{
			string?connectionString?=?““;

			if（server?==?null?||?server?==?““?||?database?==?null?||?database?==?““?||?userId?==?null?||?userId?==?““）
			{
				return?connectionString;
			}
			connectionString?=?“Data?Source=“?+?server?+?“;Initial?Catalog=“?+?database?+?“;User?Id=“?+?userId?+?“;Password=“?+?password?+?“;Connect?Timeout=30;“;
			return?connectionString;
		}

		//?創建Sql?Server以安全模式訪問的數據庫連接字符串
		//?“Data?Source=Aron1;Initial?Catalog=pubs;Integrated?Security=SSPI;“?		-?or?-		“Server=Aron1;Database=pubs;Trusted_Connection=True;“?
		static?public?string?CreateSqlConnectionString（string?server?string?database）
		{
			string?connectionString?=?““;
			
			if（server?==?null?||?server?==?““?||?database?==?null?||?database?==?““）
			{
				return?connectionString;
			}
????????????connectionString?=?“Data?Source=“?+?server?+?“;Initial?Catalog=“?+?database?+?“;Integrated?Security=SSPI;Connect?Timeout=30;“;
			return?connectionString;
		}
		
		//?創建Sql?Server的OleDb數據源類型的連接字符串
		//?“Provider=sqloledb;Data?Source=Aron1;Initial?Catalog=pubs;User?Id=sa;Password=asdasd;“
		static?public?string?CreateSqlOleDbConnectionString（string?dataSource?string?database?string?userId?string?password）
		{
			string?connectionString?=?““;

			if（dataSource?==?null?||?dataSource?==?““?||?database?==?null?||?database?==?““?||?userId?==?null?||?userId?==?““）
			{
				return?““;
			}
????????????connectionString?=?“Provider=sqloledb;Data?Source=“?+?dataSource?+?“;Initial?Catalog=“?+?database?+?“;User?Id=“?+?userId?+?“;Password=“?+?password?+?“;Connect?Timeout=30;“;
			return?connectionString;
		}

		//?創建Sql?Server的OleDb的數據源類型的連接字符串
		//?“Provider=sqloledb;Data?Source=Aron1;Initial?Catalog=pubs;Integrated?Security=SSPI;“?
		static?public?string?CreateSqlOleDbConnectionString（string?dataSource?string?database）
		{
			string?connectionString?=?““;

			if（dataSource?==?null?||?dataSource?==?““?||?database?==?null?||?database?==?““）
			{
				return?““;
			}
????????????connectionString?=?“Provider=sqloledb;Data?Source=“?+?dataSource?+?“;Initial?Catalog=“?+?database?+?“;Integrated?Security=SSPI;Connect?Timeout=30;“;
			return?connectionString;
		}

		//?創建Oracle連接字符串-信任模式?“Data?Source=MyOracleDB;Integrated?Security=yes;“?
		static?public?string?CreateOracleConnectionString（string?dataSource）
		{
			string?connectionString?=?““;
			
			if（dataSource?==?null?||?dataSource?==?““）
				return?connectionString;
????????????connectionString?=?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????28160??2010-02-28?18:44??Teaching.User\bin\Debug\Teaching.DAC.dll

?????文件?????112128??2010-02-28?18:44??Teaching.User\bin\Debug\Teaching.DAC.pdb

?????文件??????67584??2010-03-09?20:59??Teaching.User\bin\Debug\Teaching.MOD.dll

?????文件?????386560??2010-03-09?20:59??Teaching.User\bin\Debug\Teaching.MOD.pdb

?????文件??????72704??2010-03-09?20:59??Teaching.User\bin\Debug\Teaching.User.dll

?????文件?????144896??2010-03-09?20:59??Teaching.User\bin\Debug\Teaching.User.pdb

?????文件???????7168??2010-03-09?20:59??Teaching.User\bin\Debug\Teaching.Utility.dll

?????文件??????15872??2010-03-09?20:59??Teaching.User\bin\Debug\Teaching.Utility.pdb

?????文件???????6646??2010-03-09?20:59??Teaching.User\obj\Debug\ResolveAssemblyReference.cache

?????文件????????697??2010-03-09?20:59??Teaching.User\obj\Debug\Teaching.User.csproj.FileListAbsolute.txt

?????文件??????72704??2010-03-09?20:59??Teaching.User\obj\Debug\Teaching.User.dll

?????文件?????144896??2010-03-09?20:59??Teaching.User\obj\Debug\Teaching.User.pdb

?????文件???????1452??2008-11-20?11:28??Teaching.User\Properties\AssemblyInfo.cs

?????文件??????41363??2009-09-05?20:57??Teaching.User\SqlStudentDAL.cs

?????文件??????26008??2009-08-20?22:01??Teaching.User\SqlSysUserDAL.cs

?????文件??????41555??2009-10-07?23:05??Teaching.User\SqlTeacherDAL.cs

?????文件??????13703??2009-06-20?23:23??Teaching.User\SqlUserGroupDAL.cs

?????文件??????39237??2010-01-31?18:24??Teaching.User\SqlUserInfoDAL.cs

?????文件??????13292??2010-01-22?23:10??Teaching.User\SqlUserTypeDAL.cs

?????文件???????5538??2009-06-13?08:22??Teaching.User\StudentDAL.cs

?????文件????????640??2008-11-20?11:41??Teaching.User\StudentDALFactory.cs

?????文件????????238??2009-08-14?22:02??Teaching.User\SysUserBLL.cs

?????文件???????4850??2009-08-20?21:46??Teaching.User\SysUserDAL.cs

?????文件????????640??2008-11-20?11:41??Teaching.User\SysUserDALFactory.cs

?????文件???????5609??2009-10-06?15:20??Teaching.User\TeacherDAL.cs

?????文件????????640??2008-11-20?11:41??Teaching.User\TeacherDALFactory.cs

?????文件???????3976??2009-08-14?22:32??Teaching.User\Teaching.User.csproj

?????文件??????13946??2009-09-05?11:16??Teaching.User\UserBLL.cs

?????文件???????4650??2009-06-20?23:22??Teaching.User\UserGroupDAL.cs

?????文件????????646??2008-11-20?11:41??Teaching.User\UserGroupDALFactory.cs

............此處省略2176個文件信息