DsJian.Data.MySoftDataProvider/DbProvider/SqlServer2005Repository.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DsJian.Repository
{
    /// <summary>
    /// SqlServer2005数据库
    /// </summary>
    public class SqlServer2005Repository : SessionRepository
    {
        public SqlServer2005Repository(string connectionName)
            : base(connectionName)
        { }

        public SqlServer2005Repository()
            : base("DsJian")
        { }

        /// <summary>
        /// 根据类型获得数据库连接字符串
        /// </summary>
        /// <param name="type"></param>
        /// <param name="dbServer"></param>
        /// <param name="dbName"></param>
        /// <param name="dbUid"></param>
        /// <param name="dbPwd"></param>
        /// <returns></returns>
        public override String GetDbConnectionString(string dbServer, string dbName, string dbUid, string dbPwd)
        {
            return String.Format("Server={0};uid={1};pwd={2};database={3}", dbServer, dbUid, dbPwd, dbName);
        }

        /// <summary>
        /// 创建连接会话，指定链接字符串
        /// </summary>
        /// <returns></returns>
        public override MySoft.Data.DbSession GetSession(string connectionString)
        {
            MySoft.Data.DbProvider provider = new MySoft.Data.SqlServer9.SqlServer9Provider(connectionString);
            return new MySoft.Data.DbSession(provider);
        }

        /// <summary>
        /// 根据数据库类型获得建表脚本位置
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        public override String GetDbScriptPath()
        {
            return "/DbScripts/SqlServer2005.sql";
        }

        /// <summary>
        /// 获取驱动
        /// </summary>
        /// <returns></returns>
        public override MySoft.Data.DbProvider GetDbProvider(string connectionName)
        {