コード例 #1
0
        /// <summary>
        /// 配置使用示例
        /// </summary>
        /// <param name="key"></param>
        /// <returns></returns>
        public string NewDataBase()
        {
            DbContextSSO dbContext = new DbContextSSO();

            var list = dbContext.Set <sso_test>().ToList();

            return(list.ToJson());
        }
コード例 #2
0
        /// <summary>
        /// 使用原生Sql查询
        /// </summary>
        /// <returns></returns>
        public string FromSql()
        {
            //主数据库
            var tests = (IoCHelper.Resolve <IDbContextCore>() as DbContextCore).Set <ts_test>().FromSql("select * from ts_test").OrderBy(x => x.TestName);

            //二数据库
            DbContextSSO dbContext = new DbContextSSO();
            var          list      = dbContext.Set <sso_test>().FromSql("select * from sso_test").Where(x => x.TestName == "test");

            return(list.ToJson());
        }