customconnectionmanager.cs

< SQL Server2005程序设计>

using System;
using Microsoft.SqlServer.Dts.Runtime;

namespace CustomConnectionManager
{
    public class MyConnection
    {
        // TODO: Implement your connection class
    }

    [DtsConnection(
        ConnectionType = "MYCONN",
        DisplayName = "My Custom Connection",
        Description = "Connection manager for my custom type of connections")]
    public class CustomConnectionManager : ConnectionManagerBase
    {
        public override object AcquireConnection(object txn)
        {
            MyConnection myConnection = new MyConnection();
            // TODO: Add code to open your type of connection
            return (object) myConnection;
        }

        public override void ReleaseConnection(object connection)
        {
            MyConnection myConnection = (MyConnection)connection;
            // TODO: Add code to close your type of connection
        }
    }
}