2 // Mono.Data.SybaseClient.SybaseDataAdapter.cs
5 // Tim Coleman (tim@timcoleman.com)
7 // Copyright (C) Tim Coleman, 2002
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:
19 // The above copyright notice and this permission notice shall be
20 // included in all copies or substantial portions of the Software.
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.
32 using System.ComponentModel;
34 using System.Data.Common;
36 namespace Mono.Data.SybaseClient {
37 public sealed class SybaseDataAdapter : DbDataAdapter, IDbDataAdapter
41 SybaseCommand deleteCommand;
42 SybaseCommand insertCommand;
43 SybaseCommand selectCommand;
44 SybaseCommand updateCommand;
46 static readonly object EventRowUpdated = new object();
47 static readonly object EventRowUpdating = new object();
53 public SybaseDataAdapter ()
54 : this (new SybaseCommand ())
58 public SybaseDataAdapter (SybaseCommand selectCommand)
60 DeleteCommand = new SybaseCommand ();
61 InsertCommand = new SybaseCommand ();
62 SelectCommand = selectCommand;
63 UpdateCommand = new SybaseCommand ();
66 public SybaseDataAdapter (string selectCommandText, SybaseConnection selectConnection)
67 : this (new SybaseCommand (selectCommandText, selectConnection))
71 public SybaseDataAdapter (string selectCommandText, string selectConnectionString)
72 : this (selectCommandText, new SybaseConnection (selectConnectionString))
80 public SybaseCommand DeleteCommand {
81 get { return deleteCommand; }
82 set { deleteCommand = value; }
85 public SybaseCommand InsertCommand {
86 get { return insertCommand; }
87 set { insertCommand = value; }
90 public SybaseCommand SelectCommand {
91 get { return selectCommand; }
92 set { selectCommand = value; }
95 public SybaseCommand UpdateCommand {
96 get { return updateCommand; }
97 set { updateCommand = value; }
100 IDbCommand IDbDataAdapter.DeleteCommand {
101 get { return DeleteCommand; }
103 if (!(value is SybaseCommand))
104 throw new ArgumentException ();
105 DeleteCommand = (SybaseCommand)value;
109 IDbCommand IDbDataAdapter.InsertCommand {
110 get { return InsertCommand; }
112 if (!(value is SybaseCommand))
113 throw new ArgumentException ();
114 InsertCommand = (SybaseCommand)value;
118 IDbCommand IDbDataAdapter.SelectCommand {
119 get { return SelectCommand; }
121 if (!(value is SybaseCommand))
122 throw new ArgumentException ();
123 SelectCommand = (SybaseCommand)value;
127 IDbCommand IDbDataAdapter.UpdateCommand {
128 get { return UpdateCommand; }
130 if (!(value is SybaseCommand))
131 throw new ArgumentException ();
132 UpdateCommand = (SybaseCommand)value;
137 ITableMappingCollection IDataAdapter.TableMappings {
138 get { return TableMappings; }
141 #endregion // Properties
145 protected override RowUpdatedEventArgs CreateRowUpdatedEvent (DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
147 return new SybaseRowUpdatedEventArgs (dataRow, command, statementType, tableMapping);
151 protected override RowUpdatingEventArgs CreateRowUpdatingEvent (DataRow dataRow, IDbCommand command, StatementType statementType, DataTableMapping tableMapping)
153 return new SybaseRowUpdatingEventArgs (dataRow, command, statementType, tableMapping);
156 protected override void OnRowUpdated (RowUpdatedEventArgs value)
158 SybaseRowUpdatedEventHandler handler = (SybaseRowUpdatedEventHandler) Events[EventRowUpdated];
159 if ((handler != null) && (value is SybaseRowUpdatedEventArgs))
160 handler(this, (SybaseRowUpdatedEventArgs) value);
163 protected override void OnRowUpdating (RowUpdatingEventArgs value)
165 SybaseRowUpdatingEventHandler handler = (SybaseRowUpdatingEventHandler) Events[EventRowUpdating];
166 if ((handler != null) && (value is SybaseRowUpdatingEventArgs))
167 handler(this, (SybaseRowUpdatingEventArgs) value);
170 #endregion // Methods
172 #region Events and Delegates
174 public event SybaseRowUpdatedEventHandler RowUpdated {
175 add { Events.AddHandler (EventRowUpdated, value); }
176 remove { Events.RemoveHandler (EventRowUpdated, value); }
179 public event SybaseRowUpdatingEventHandler RowUpdating {
180 add { Events.AddHandler (EventRowUpdating, value); }
181 remove { Events.RemoveHandler (EventRowUpdating, value); }
184 #endregion // Events and Delegates