wasCSharpSQLite – Blame information for rev
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
1 | office | 1 | // |
2 | // System.Data.Common.DbCommand |
||
3 | // |
||
4 | // Author: |
||
5 | // Tim Coleman (tim@timcoleman.com) |
||
6 | // |
||
7 | // Copyright (C) Tim Coleman, 2003 |
||
8 | // |
||
9 | |||
10 | // |
||
11 | // Copyright (C) 2004 Novell, Inc (http://www.novell.com) |
||
12 | // |
||
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: |
||
20 | // |
||
21 | // The above copyright notice and this permission notice shall be |
||
22 | // included in all copies or substantial portions of the Software. |
||
23 | // |
||
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. |
||
31 | // |
||
32 | |||
33 | |||
34 | |||
35 | using System.ComponentModel; |
||
36 | using System.Data; |
||
37 | |||
38 | namespace System.Data.Common { |
||
39 | public abstract class DbCommand : IDbCommand, IDisposable |
||
40 | { |
||
41 | protected DbCommand () |
||
42 | { |
||
43 | } |
||
44 | |||
45 | #region Properties |
||
46 | |||
47 | [DefaultValue ("")] |
||
48 | public abstract string CommandText { get; set; } |
||
49 | |||
50 | public abstract int CommandTimeout { get; set; } |
||
51 | |||
52 | [DefaultValue (CommandType.Text)] |
||
53 | public abstract CommandType CommandType { get; set; } |
||
54 | |||
55 | [DefaultValue (null)] |
||
56 | #if !(WINDOWS_PHONE || NETFX_CORE) |
||
57 | [Browsable (false)] |
||
58 | #endif |
||
59 | public DbConnection Connection { |
||
60 | get { return DbConnection; } |
||
61 | set { DbConnection = value; } |
||
62 | } |
||
63 | |||
64 | protected abstract DbConnection DbConnection { get; set; } |
||
65 | protected abstract DbParameterCollection DbParameterCollection { get; } |
||
66 | protected abstract DbTransaction DbTransaction { get; set; } |
||
67 | |||
68 | [EditorBrowsable (EditorBrowsableState.Never)] |
||
69 | #if !(WINDOWS_PHONE || NETFX_CORE) |
||
70 | [Browsable (false)] |
||
71 | #endif |
||
72 | [DefaultValue (true)] |
||
73 | public abstract bool DesignTimeVisible { get; set; } |
||
74 | |||
75 | IDbConnection IDbCommand.Connection { |
||
76 | get { return Connection; } |
||
77 | set { Connection = (DbConnection) value; } |
||
78 | } |
||
79 | |||
80 | IDataParameterCollection IDbCommand.Parameters { |
||
81 | get { return Parameters; } |
||
82 | } |
||
83 | |||
84 | IDbTransaction IDbCommand.Transaction { |
||
85 | get { return Transaction; } |
||
86 | set { Transaction = (DbTransaction) value; } |
||
87 | } |
||
88 | #if !(WINDOWS_PHONE || NETFX_CORE) |
||
89 | [Browsable (false)] |
||
90 | #endif |
||
91 | public DbParameterCollection Parameters { |
||
92 | get { return DbParameterCollection; } |
||
93 | } |
||
94 | #if !(WINDOWS_PHONE || NETFX_CORE) |
||
95 | [Browsable (false)] |
||
96 | #endif |
||
97 | [DefaultValue (null)] |
||
98 | public DbTransaction Transaction { |
||
99 | get { return DbTransaction; } |
||
100 | set { DbTransaction = value; } |
||
101 | } |
||
102 | |||
103 | //[DefaultValue (UpdateRowSource.Both)] |
||
104 | //public abstract UpdateRowSource UpdatedRowSource { get; set; } |
||
105 | |||
106 | #endregion // Properties |
||
107 | |||
108 | #region Methods |
||
109 | |||
110 | public abstract void Cancel (); |
||
111 | protected abstract DbParameter CreateDbParameter (); |
||
112 | |||
113 | public DbParameter CreateParameter () |
||
114 | { |
||
115 | return CreateDbParameter (); |
||
116 | } |
||
117 | |||
118 | protected abstract DbDataReader ExecuteDbDataReader (CommandBehavior behavior); |
||
119 | public abstract int ExecuteNonQuery (); |
||
120 | |||
121 | public DbDataReader ExecuteReader () |
||
122 | { |
||
123 | return ExecuteDbDataReader (CommandBehavior.Default); |
||
124 | } |
||
125 | |||
126 | public DbDataReader ExecuteReader (CommandBehavior behavior) |
||
127 | { |
||
128 | return ExecuteDbDataReader (behavior); |
||
129 | } |
||
130 | |||
131 | public abstract object ExecuteScalar (); |
||
132 | |||
133 | IDbDataParameter IDbCommand.CreateParameter () |
||
134 | { |
||
135 | return CreateParameter (); |
||
136 | } |
||
137 | |||
138 | IDataReader IDbCommand.ExecuteReader () |
||
139 | { |
||
140 | return ExecuteReader (); |
||
141 | } |
||
142 | |||
143 | IDataReader IDbCommand.ExecuteReader (CommandBehavior behavior) |
||
144 | { |
||
145 | return ExecuteReader (behavior); |
||
146 | } |
||
147 | |||
148 | public abstract void Prepare (); |
||
149 | |||
150 | public void Dispose() |
||
151 | { |
||
152 | Dispose(true); |
||
153 | GC.SuppressFinalize(this); |
||
154 | } |
||
155 | |||
156 | // <summary> |
||
157 | // Controls disposal of resources used by this. |
||
158 | // </summary> |
||
159 | // |
||
160 | // <param name="release_all"> Controls which resources are released</param> |
||
161 | // |
||
162 | // <remarks> |
||
163 | // if release_all is set to true, both managed and unmanaged |
||
164 | // resources should be released. If release_all is set to false, |
||
165 | // only unmanaged resources should be disposed |
||
166 | // </remarks> |
||
167 | protected virtual void Dispose(bool release_all) |
||
168 | { |
||
169 | //if (release_all) |
||
170 | //{ |
||
171 | // if (mySite != null && mySite.Container != null) |
||
172 | // mySite.Container.Remove(this); |
||
173 | // EventHandler eh = (EventHandler)Events[disposedEvent]; |
||
174 | // if (eh != null) |
||
175 | // eh(this, EventArgs.Empty); |
||
176 | //} |
||
177 | } |
||
178 | |||
179 | |||
180 | #endregion // Methods |
||
181 | |||
182 | } |
||
183 | } |
||
184 | |||
185 |