oledataprovider.cs

C#代码查看Sqlserver等不同数据库的源代码

//=====================================================================================
// 作者：二十四画生
// Email：mailto:[e-mail]
// Blog：http://esshs.cnblogs.com
//=====================================================================================

using System;
using System.Data;

using OleDB.ApplicationBlocks.Data;
using Esshs.Common.Framework;
using Esshs.DAL;

namespace Esshs.DAL.OLEDataProvider
{
	/// <summary>
	/// OleDB类型的数据访问的具体实现
	/// </summary>
	public class OleDataProvider : DataProvider
	{
		private const string ProviderType = "data";
		private ProviderConfiguration _providerConfiguration = ProviderConfiguration.GetProviderConfiguration(ProviderType);
		private string _connectionString;

		/// <summary>
		/// 构造函数
		/// </summary>
		public OleDataProvider()
		{
			Provider objProvider = (Provider)_providerConfiguration.Providers[_providerConfiguration.DefaultProvider];
			if (objProvider.Attributes["connectionStringName"] != "" && System.Configuration.ConfigurationSettings.AppSettings[objProvider.Attributes["connectionStringName"]] != "")
			{
				_connectionString = System.Configuration.ConfigurationSettings.AppSettings[objProvider.Attributes["connectionStringName"]];
			}
			else
			{
				_connectionString = objProvider.Attributes["connectionString"];
			}
		}

		/// <summary>
		/// 连接字符串属性
		/// </summary>
		public string ConnectionString
		{
			get
			{
				return _connectionString;
			}
		}


		#region 实现抽象方法

		public override DataSet GetCategories()
		{
			return OleDBHelper.ExecuteDataset(ConnectionString, CommandType.Text ,"select * from Categories");
		}

		#endregion
	}
}