Пример #1
0
        /// <summary>
        /// 构造DbContext(自定义连接字符串)
        /// </summary>
        /// <param name="teacherBusinessId"></param>
        public UserDbContext(IUserDbSetting dbSetting) : base(CreateDbConnection(dbSetting), false)
        {
            var dbConnection = CreateDbConnection(dbSetting);

            _connectionString = dbConnection.ConnectionString;
            //this.Configuration.LazyLoadingEnabled = false;
        }
Пример #2
0
        /// <summary>
        /// 动态创建连接
        /// </summary>
        /// <param name="teacherBusinessId"></param>
        /// <returns></returns>
        public static DbConnection CreateDbConnection(IUserDbSetting dbSetting)
        {
            if (dbSetting == null)
            {
                throw new NullReferenceException("未提供有效的数据库配置.");
            }

            string teacherDbFilePath = dbSetting.GetFullDbPath();

            DbConnection connection = SQLiteProviderFactory.Instance.CreateConnection();

            connection.ConnectionString = $"Data Source={teacherDbFilePath}";

            return(connection);
        }