2 // System.Data.Common.DbCommand
5 // Tim Coleman (tim@timcoleman.com)
7 // Copyright (C) Tim Coleman, 2003
11 // Copyright (C) 2004 Novell, Inc (http://www.novell.com)
13 // Permission is hereby granted, free of charge, to any person obtaining
14 // a copy of this software and associated documentation files (the
15 // "Software"), to deal in the Software without restriction, including
16 // without limitation the rights to use, copy, modify, merge, publish,
17 // distribute, sublicense, and/or sell copies of the Software, and to
18 // permit persons to whom the Software is furnished to do so, subject to
19 // the following conditions:
21 // The above copyright notice and this permission notice shall be
22 // included in all copies or substantial portions of the Software.
24 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
25 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
26 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
27 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
28 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
29 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
30 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
33 #if NET_2_0 || TARGET_JVM
35 using System.ComponentModel;
38 namespace System.Data.Common {
39 public abstract class DbCommand : Component, IDbCommand, IDisposable
41 protected DbCommand ()
48 [RefreshProperties (RefreshProperties.All)]
49 public abstract string CommandText { get; set; }
51 public abstract int CommandTimeout { get; set; }
53 [DefaultValue (CommandType.Text)]
54 [RefreshProperties (RefreshProperties.All)]
55 public abstract CommandType CommandType { get; set; }
59 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
60 public DbConnection Connection {
61 get { return DbConnection; }
62 set { DbConnection = value; }
65 protected abstract DbConnection DbConnection { get; set; }
66 protected abstract DbParameterCollection DbParameterCollection { get; }
67 protected abstract DbTransaction DbTransaction { get; set; }
69 [EditorBrowsable (EditorBrowsableState.Never)]
73 public abstract bool DesignTimeVisible { get; set; }
75 IDbConnection IDbCommand.Connection {
76 get { return Connection; }
77 set { Connection = (DbConnection) value; }
80 IDataParameterCollection IDbCommand.Parameters {
81 get { return Parameters; }
84 IDbTransaction IDbCommand.Transaction {
85 get { return Transaction; }
86 set { Transaction = (DbTransaction) value; }
90 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
91 public DbParameterCollection Parameters {
92 get { return DbParameterCollection; }
97 [DesignerSerializationVisibility (DesignerSerializationVisibility.Hidden)]
98 public DbTransaction Transaction {
99 get { return DbTransaction; }
100 set { DbTransaction = value; }
103 [DefaultValue (UpdateRowSource.Both)]
104 public abstract UpdateRowSource UpdatedRowSource { get; set; }
106 #endregion // Properties
110 public abstract void Cancel ();
111 protected abstract DbParameter CreateDbParameter ();
113 public DbParameter CreateParameter ()
115 return CreateDbParameter ();
118 protected abstract DbDataReader ExecuteDbDataReader (CommandBehavior behavior);
119 public abstract int ExecuteNonQuery ();
121 public DbDataReader ExecuteReader ()
123 return ExecuteDbDataReader (CommandBehavior.Default);
126 public DbDataReader ExecuteReader (CommandBehavior behavior)
128 return ExecuteDbDataReader (behavior);
131 public abstract object ExecuteScalar ();
133 IDbDataParameter IDbCommand.CreateParameter ()
135 return CreateParameter ();
138 IDataReader IDbCommand.ExecuteReader ()
140 return ExecuteReader ();
143 IDataReader IDbCommand.ExecuteReader (CommandBehavior behavior)
145 return ExecuteReader (behavior);
148 public abstract void Prepare ();
150 #endregion // Methods