示例#1
0
        /// <summary>
        /// 创建StoreProcedure对象的实例
        /// </summary>
        /// <param name="spName">存储过程名称</param>
        /// <param name="parameters">匿名对象</param>
        /// <returns>StoreProcedure对象实例</returns>
        public static StoreProcedure Create(string spName, DbParameter[] parameters)
        {
            StoreProcedure sp = new StoreProcedure(ConnectionScope.GetDefaultDbConext());

            sp.Init(spName, parameters);
            return(sp);
        }
示例#2
0
        /// <summary>
        /// 创建StoreProcedure对象的实例
        /// </summary>
        /// <param name="spName">存储过程名称</param>
        /// <param name="argsObject">匿名对象参数</param>
        /// <returns>StoreProcedure对象实例</returns>
        public static StoreProcedure Create(string spName, object argsObject)
        {
            StoreProcedure sp = new StoreProcedure(ConnectionScope.GetDefaultDbConext());

            sp.Init(spName, argsObject);
            return(sp);
        }
示例#3
0
        /// <summary>
        /// 创建一个XmlCommand对象实例。
        /// </summary>
        /// <param name="name">命令名字</param>
        /// <param name="argsObject">匿名对象表示的参数</param>
        /// <returns></returns>
        public static XmlCommand Create(string name, object argsObject)
        {
            XmlCommand command = new XmlCommand(ConnectionScope.GetDefaultDbConext());

            command.Init(name, argsObject);
            return(command);
        }
示例#4
0
        /// <summary>
        /// 根据指定的参数化SQL语句,创建CPQuery对象实例
        /// </summary>
        /// <param name="parameterizedSQL">参数化SQL语句</param>
        /// <returns>CPQuery对象实例</returns>
        public static CPQuery Create(string parameterizedSQL = null)
        {
            //if( string.IsNullOrEmpty(parameterizedSQL) )
            //	throw new ArgumentNullException("parameterizedSQL");

            CPQuery query = new CPQuery(ConnectionScope.GetDefaultDbConext());

            query.Init(parameterizedSQL);
            return(query);
        }
示例#5
0
        /// <summary>
        /// 创建一个XmlCommand对象实例。
        /// </summary>
        /// <param name="name">命令名字</param>
        /// <param name="dictionary">要传递的参数字典</param>
        /// <returns></returns>
        public static XmlCommand Create(string name, Dictionary <string, object> dictionary)
        {
            // 说明:保留这个重载,而不是用匿名对象来代替是因为:
            // 匿名对象是只读的,需要一次性构造,而Dictionary可以在不同的代码段中分开构造。
            // 所以,不要删除这个重载方法。

            XmlCommand command = new XmlCommand(ConnectionScope.GetDefaultDbConext());

            command.Init(name, dictionary);
            return(command);
        }
示例#6
0
        /// <summary>
        /// 通过参数化SQL、哈希表的方式,创建CPQuery对象实例
        /// </summary>
        /// <param name="parameterizedSQL">参数化的SQL字符串</param>
        /// <param name="dictionary">哈希表</param>
        /// <returns>CPQuery对象实例</returns>
        public static CPQuery Create(string parameterizedSQL, Dictionary <string, object> dictionary)
        {
            if (string.IsNullOrEmpty(parameterizedSQL))
            {
                throw new ArgumentNullException("parameterizedSQL");
            }

            CPQuery query = new CPQuery(ConnectionScope.GetDefaultDbConext());

            query.Init(parameterizedSQL, dictionary);
            return(query);
        }