DbCommand.cs 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  1. //
  2. // System.Data.Common.DbCommand
  3. //
  4. // Author:
  5. // Tim Coleman ([email protected])
  6. //
  7. // Copyright (C) Tim Coleman, 2003
  8. //
  9. //
  10. // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
  11. //
  12. // Permission is hereby granted, free of charge, to any person obtaining
  13. // a copy of this software and associated documentation files (the
  14. // "Software"), to deal in the Software without restriction, including
  15. // without limitation the rights to use, copy, modify, merge, publish,
  16. // distribute, sublicense, and/or sell copies of the Software, and to
  17. // permit persons to whom the Software is furnished to do so, subject to
  18. // the following conditions:
  19. //
  20. // The above copyright notice and this permission notice shall be
  21. // included in all copies or substantial portions of the Software.
  22. //
  23. // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  24. // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  25. // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  26. // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  27. // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  28. // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  29. // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  30. //
  31. #if NET_2_0 || TARGET_JVM
  32. using System.ComponentModel;
  33. using System.Data;
  34. namespace System.Data.Common {
  35. public abstract class DbCommand : Component, IDbCommand, IDisposable
  36. {
  37. protected DbCommand ()
  38. {
  39. }
  40. #region Properties
  41. [DefaultValue ("")]
  42. [RefreshProperties (RefreshProperties.All)]
  43. public abstract string CommandText { get; set; }
  44. public abstract int CommandTimeout { get; set; }
  45. [DefaultValue (CommandType.Text)]
  46. [RefreshProperties (RefreshProperties.All)]
  47. public abstract CommandType CommandType { get; set; }
  48. [DefaultValue (null)]
  49. [Browsable (false)]
  50. [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  51. public DbConnection Connection {
  52. get { return DbConnection; }
  53. set { DbConnection = value; }
  54. }
  55. protected abstract DbConnection DbConnection { get; set; }
  56. protected abstract DbParameterCollection DbParameterCollection { get; }
  57. protected abstract DbTransaction DbTransaction { get; set; }
  58. [EditorBrowsable (EditorBrowsableState.Never)]
  59. [Browsable (false)]
  60. [DefaultValue (true)]
  61. [DesignOnly (true)]
  62. public abstract bool DesignTimeVisible { get; set; }
  63. IDbConnection IDbCommand.Connection {
  64. get { return Connection; }
  65. set { Connection = (DbConnection) value; }
  66. }
  67. IDataParameterCollection IDbCommand.Parameters {
  68. get { return Parameters; }
  69. }
  70. IDbTransaction IDbCommand.Transaction {
  71. get { return Transaction; }
  72. set { Transaction = (DbTransaction) value; }
  73. }
  74. [Browsable (false)]
  75. [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  76. public DbParameterCollection Parameters {
  77. get { return DbParameterCollection; }
  78. }
  79. [Browsable (false)]
  80. [DefaultValue (null)]
  81. [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
  82. public DbTransaction Transaction {
  83. get { return DbTransaction; }
  84. set { DbTransaction = value; }
  85. }
  86. [DefaultValue (UpdateRowSource.Both)]
  87. public abstract UpdateRowSource UpdatedRowSource { get; set; }
  88. #endregion // Properties
  89. #region Methods
  90. public abstract void Cancel ();
  91. protected abstract DbParameter CreateDbParameter ();
  92. public DbParameter CreateParameter ()
  93. {
  94. return CreateDbParameter ();
  95. }
  96. protected abstract DbDataReader ExecuteDbDataReader (CommandBehavior behavior);
  97. public abstract int ExecuteNonQuery ();
  98. public DbDataReader ExecuteReader ()
  99. {
  100. return ExecuteDbDataReader (CommandBehavior.Default);
  101. }
  102. public DbDataReader ExecuteReader (CommandBehavior behavior)
  103. {
  104. return ExecuteDbDataReader (behavior);
  105. }
  106. public abstract object ExecuteScalar ();
  107. IDbDataParameter IDbCommand.CreateParameter ()
  108. {
  109. return CreateParameter ();
  110. }
  111. IDataReader IDbCommand.ExecuteReader ()
  112. {
  113. return ExecuteReader ();
  114. }
  115. IDataReader IDbCommand.ExecuteReader (CommandBehavior behavior)
  116. {
  117. return ExecuteReader (behavior);
  118. }
  119. public abstract void Prepare ();
  120. #endregion // Methods
  121. }
  122. }
  123. #endif