// // System.Data.Common.SqlParameterCollection // // Author: // Boris Kirzner (borisk@mainsoft.com) // /* * 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 } }