Exemplo n.º 1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="query"></param>
        /// <param name="parameter"></param>
        public Query(string query, ISqlParameter parameter)
        {
            Connection = Sql.Connection;
            Command    = new SqlCommand(query, Connection);
            var parameters = parameter?.GetParameters();

            if (parameters != null)
            {
                Command.Parameters.AddRange(parameters);
            }
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="name"></param>
        /// <param name="parameter"></param>
        public StoredProcedure(string name, ISqlParameter parameter)
        {
            Connection = Sql.Connection;
            Command    = new SqlCommand(name, Connection)
            {
                CommandType = CommandType.StoredProcedure
            };
            var parameters = parameter?.GetParameters();

            if (parameters != null)
            {
                Command.Parameters.AddRange(parameters);
            }
        }