DsJian.Data.MySoftDataProvider/DbProvider/SQLiteRepository.cs

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

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

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

        /// <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 = MySoft.Data.ProviderFactory.CreateDbProvider(MySoft.Data.ProviderType.SQLite, connectionString);
            return new MySoft.Data.DbSession(provider);
        }

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

        /// <summary>
        /// 获取驱动
        /// </summary>
        /// <returns></returns>
        public override MySoft.Data.DbProvider GetDbProvider(string connectionName)
        {
            return MySoft.Data.ProviderFactory.CreateDbProvider(connectionName, MySoft.Data.ProviderType.SQLite);
        }
    }
}