示例#1
0
        /// <summary>
        /// 创建数据上下文
        /// </summary>
        /// <param name="sqlURI"></param>
        /// <returns></returns>
        public static DataContext CreateDataContext(SQLConnectionURI sqlURI, MappingSource ms, bool Log = false)
        {
            System.Diagnostics.Debug.Assert(sqlURI != null, "没有找到有效的数据库连接!");
            System.Diagnostics.Debug.Assert(!string.IsNullOrEmpty(sqlURI.ConnectString), "没有找到有效的数据库连接!");
            IDbConnection connection = null;

            if (!string.IsNullOrEmpty(sqlURI.SQLType) && sqlURI.SQLType.ToUpper() == "SQLITE")
            {
                connection = new SQLiteConnection(sqlURI.ConnectString);
            }
            else if (!string.IsNullOrEmpty(sqlURI.SQLType) && sqlURI.SQLType.ToUpper() == "MSSQL")
            {
                connection = new SqlConnection(sqlURI.ConnectString);
            }
            else //如果没有标明数据库类型,默认采用mssql数据库
            {
                connection = new SqlConnection(sqlURI.ConnectString);
            }
            DataContext dc = new DataContext(connection, ms);

            if (Log)
            {
                dc.Log = System.Console.Out;
            }
            return(dc);
        }
示例#2
0
 public LinqUnitWork(SQLConnectionURI connStr, MappingSource ms)
 {
     _DataContext = DataContextFactory.CreateDataContext(connStr, ms);
 }