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

//
// System.Data.Common.SqlParameterCollection
//
// Authors:
//	Konstantin Triger <[email protected]>
//	Boris Kirzner <[email protected]>
//	
// (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
//

//
// 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

    }
}