mono/mcs/class/System.Data/System.Data.SqlClient.jvm/SqlParameterCollection.cs

//
// System.Data.Common.SqlParameterCollection
//
// Author:
//   Boris Kirzner ([email protected])
//

/*
  * Copyright (c) 2002-2004 Mainsoft Corporation.
  *
  * Permission is hereby granted, free of charge, to any person obtaining a
  * copy of this software and associated documentation files (the "Software"),
  * to deal in the Software without restriction, including without limitation
  * the rights to use, copy, modify, merge, publish, distribute, sublicense,
  * and/or sell copies of the Software, and to permit persons to whom the
  * Software is furnished to do so, subject to the following conditions:
  *
  * The above copyright notice and this permission notice shall be included in
  * all copies or substantial portions of the Software.
  *
  * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
  * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
  * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
  * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
  * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
  * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
  * DEALINGS IN THE SOFTWARE.
  */

using System.Data.ProviderBase;

namespace System.Data.SqlClient
{
    public class SqlParameterCollection : AbstractDbParameterCollection
    {
		#region Constructors

        public SqlParameterCollection(SqlCommand parent): base(parent)
        {
        }

		#endregion // Constructors

		#region Properties

        public SqlParameter this[string parameterName]
        {
            get { return (SqlParameter)base[parameterName]; }
            set { 
				OnSchemaChanging();
				base[parameterName] = value; 
			}
        }

        public SqlParameter this[int index]
        {
            get { return (SqlParameter)base[index]; }
            set { 
				base.OnSchemaChanging();
				base[index] = value; 
			}
        }

		protected override Type ItemType { 
			get { return typeof(SqlParameter); }
		}

		#endregion // Properties

		#region Methods       

        public SqlParameter Add(SqlParameter value)
        {
            base.Add(value);
            return value;
        }

        public SqlParameter Add(string parameterName, object value)
        {
            SqlParameter param = new SqlParameter(parameterName,value);
            return Add(param);
        }

        public SqlParameter Add(string parameterName, SqlDbType sqlDbType)
        {
            SqlParameter param = new SqlParameter(parameterName,sqlDbType);
            return Add(param);
        }

        public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size)
        {
            SqlParameter param = new SqlParameter(parameterName,sqlDbType,size);
            return Add(param);
        }

        public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size, string sourceColumn)
        {
            SqlParameter param = new SqlParameter(parameterName,sqlDbType,size,sourceColumn);
            return Add(param);
        }

		#endregion // Methods

    }
}