本文為您介紹了DB2 9.0+提供的ADO.NET Provider，ADO.NET Provider支持.NET 2.0，方面了使用DB2作數(shù)據(jù)訪問。如果您對此有興趣，不妨一看，會對您有所幫助。

雖然很多朋友都在用.NET作數(shù)據(jù)訪問，但使用DB2的應(yīng)該不多，偶爾使用也是用ODBC或OLE DB方式。

DB2 9.0+提供了支持.NET 2.0的ADO.NET Provider, 尤其對于使用PureXML開發(fā)XQuery的朋友而言，這個功能上要比OLE DB，ODBC的方式豐富。

我安裝的是DB2 9.5 Express-C版本
開發(fā)環(huán)境是VS 2008，不過其實用VS 2005的DB 9.5 Visual Studio 2005 Add-ins更方便
基于代碼的訪問就不提了，這里介紹一個App.Config的方式 （google了一下，找不到合適的，經(jīng)過誤打誤撞碰出了providerName="IBM.Data.DB2"）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Diagnostics;
using System.Data.Common;
using System.Configuration;
namespace MarvellousXml.Library.Data
{
    /// <summary>
    /// 完成數(shù)據(jù)操作的抽象基類
    /// </summary>
    public class Database
    {
        protected string name;
        ConnectionStringSettings setting;

        public Database(string name)
        {
            this.name = name;
            this.setting = ConfigurationManager.ConnectionStrings[name];#p#
        }

        /// <summary>
        /// 提供DbConnection實例
        /// </summary>
        /// <returns></returns>
        public DbConnection GetConnection()
        {
            return CreateConnection(this.name);
        }

        #region Helper Methods

        /// <summary>
        /// 根據(jù)配置構(gòu)造DbConnection實例
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        private DbConnection CreateConnection(string name)
        {
            if (string.IsNullOrEmpty(name))
                throw new ArgumentNullException("name");
           
            DbProviderFactory factory = DbProviderFactories.GetFactory(setting.ProviderName);
            DbConnection connection = factory.CreateConnection();
            connection.ConnectionString = setting.ConnectionString;
            return connection;
        }

        #endregion

    }#p#
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using System.Data;
using System.Data.Common;
using MarvellousXml.Library.Data;
namespace MarvellousXml.Library.Data.Test
{
    [TestClass]
    public class DatabaseFixture
    {
        [TestMethod]
        public void CreateDb2Database()
        {
            string dbName = "DB2.Test";
            Database database = DatabaseFactory.Create(dbName);
            Assert.IsNotNull(database);
            DbConnection connection = database.GetConnection();
            connection.Open();
            Assert.IsTrue(connection.State == ConnectionState.Open);
        }
    }
}#p#

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="DB2.Test" connectionString="Database=SAMPLE;User ID=...;Server=127.0.0.1; Password = ...; Persist Security Info=True" providerName="IBM.Data.DB2"/>
  </connectionStrings>
</configuration>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace MarvellousXml.Library.Data
{
    /// <summary>
    /// 構(gòu)造Database的工廠類型 (還沒有完成的 毛坯)
    /// </summary>
    public static class DatabaseFactory
    {
        /// <summary>
        /// 構(gòu)造
        /// </summary>
        /// <param name="name">邏輯連接名稱</param>
        /// <returns>Database實例</returns>
        public static Database Create(string name)
        {
            return new Database(name);
        }

    }
}