2
0

OracleParameterCollection.cs 3.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  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 OracleParameter this[int index] {
  39. get { return (OracleParameter)base[index]; }
  40. set {
  41. OnSchemaChanging();
  42. base[index] = value;
  43. }
  44. }
  45. public 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. #endregion // Methods
  78. }
  79. }