OracleParameterCollection.cs 3.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
  1. //
  2. // System.Data.Common.OracleParameterCollection
  3. //
  4. // Authors:
  5. // Konstantin Triger <[email protected]>
  6. // Boris Kirzner <[email protected]>
  7. //
  8. // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
  9. //
  10. //
  11. // Permission is hereby granted, free of charge, to any person obtaining
  12. // a copy of this software and associated documentation files (the
  13. // "Software"), to deal in the Software without restriction, including
  14. // without limitation the rights to use, copy, modify, merge, publish,
  15. // distribute, sublicense, and/or sell copies of the Software, and to
  16. // permit persons to whom the Software is furnished to do so, subject to
  17. // the following conditions:
  18. //
  19. // The above copyright notice and this permission notice shall be
  20. // included in all copies or substantial portions of the Software.
  21. //
  22. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  23. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  24. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  25. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  26. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  27. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  28. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  29. //
  30. using System.Data.ProviderBase;
  31. namespace System.Data.OracleClient {
  32. public sealed class OracleParameterCollection : AbstractDbParameterCollection {
  33. #region Constructors
  34. public OracleParameterCollection(OracleCommand parent): base(parent) {
  35. }
  36. #endregion // Constructors
  37. #region Properties
  38. public new OracleParameter this[int index] {
  39. get { return (OracleParameter)base[index]; }
  40. set {
  41. OnSchemaChanging();
  42. base[index] = value;
  43. }
  44. }
  45. public new OracleParameter this[string parameterName] {
  46. get { return (OracleParameter)base[parameterName]; }
  47. set {
  48. OnSchemaChanging();
  49. base[parameterName] = value;
  50. }
  51. }
  52. protected override Type ItemType {
  53. get { return typeof(OracleParameter); }
  54. }
  55. #endregion // Properties
  56. #region Methods
  57. public OracleParameter Add(OracleParameter value) {
  58. base.Add(value);
  59. return value;
  60. }
  61. public OracleParameter Add(string parameterName, object value) {
  62. OracleParameter param = new OracleParameter(parameterName, value);
  63. return Add(param);
  64. }
  65. public OracleParameter Add(string parameterName, OracleType sqlDbType) {
  66. OracleParameter param = new OracleParameter(parameterName, sqlDbType);
  67. return Add(param);
  68. }
  69. public OracleParameter Add(string parameterName, OracleType sqlDbType, int size) {
  70. OracleParameter param = new OracleParameter(parameterName, sqlDbType, size);
  71. return Add(param);
  72. }
  73. public OracleParameter Add(string parameterName, OracleType sqlDbType, int size, string sourceColumn) {
  74. OracleParameter param = new OracleParameter(parameterName, sqlDbType, size, sourceColumn);
  75. return Add(param);
  76. }
  77. #if NET_2_0
  78. public bool Contains (OracleParameter value) {
  79. return base.Contains (value);
  80. }
  81. public void CopyTo (OracleParameter [] array, int index) {
  82. base.CopyTo (array, index);
  83. }
  84. public void Insert (int index, OracleParameter value) {
  85. base.Insert (index, value);
  86. }
  87. public void Remove (OracleParameter value) {
  88. base.Remove (value);
  89. }
  90. #endif
  91. #endregion // Methods
  92. }
  93. }