Ejemplo n.º 1
0
        /// <summary>
        /// 创建具体数据库访问类
        /// </summary>
        /// <typeparam name="TProvider"></typeparam>
        /// <param name="connectionString"></param>
        /// <returns></returns>
        #region Methods
        public static DapperDB CreateDatabase <TProvider>(string connectionString) where TProvider : DbConnection
        {
            var db = new DapperDB(() =>
            {
                return(Activator.CreateInstance <TProvider>());
            }
                                  , connectionString);

            return(db);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取Datable(只限制Oracle数据库用)
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="p">Oracle动态参数</param>
        /// <returns></returns>
        public static DataTable ExecuteTable(this DapperDB db, string sql, OracleDynamicParameters p)
        {
            DataTable dt = null;

            using (var conn = db.GetConnection())
            {
                dt = new DataTable();
                dt.Load(conn.ExecuteReader(sql, p));
            }
            return(dt);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 查询List接口(只限制Oracle数据库用)
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="sql"></param>
        /// <param name="p">Oracle动态参数</param>
        /// <param name="isCount">是否返回总数</param>
        /// <param name="recordCount">总数</param>
        /// <returns></returns>
        public static List <T> QueryList <T>(this DapperDB db, string sql, OracleDynamicParameters p, bool isCount, ref int recordCount)
        {
            List <T> list = null;

            using (var conn = db.GetConnection())
            {
                list = conn.Query <T>(sql, p).ToList();
                if (isCount)
                {
                    recordCount = p.GetRecordCount();
                }
                return(list);
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 获取Datable
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="p">Oracle动态参数</param>
        /// <param name="isCount"></param>
        /// <param name="recordCount"></param>
        /// <returns></returns>
        public static DataTable ExecuteTable(this DapperDB db, string sql, OracleDynamicParameters p, bool isCount, ref int recordCount)
        {
            DataTable dt = null;

            using (var conn = db.GetConnection())
            {
                dt = new DataTable();
                dt.Load(conn.ExecuteReader(sql, p));
                if (isCount)
                {
                    recordCount = p.GetRecordCount();
                }
            }
            return(dt);
        }