1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
|
/********************************************************
* ADO.NET 2.0 Data Provider for SQLite Version 3.X
* Written by Robert Simpson (robert@blackcastlesoft.com)
*
* Released to the public domain, use at your own risk!
********************************************************/
namespace Mono.Data.Sqlite
{
using System;
using System.Data;
using System.Data.Common;
using System.ComponentModel;
/// <summary>
/// SQLite implementation of DbDataAdapter.
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultEvent("RowUpdated")]
[ToolboxItem("SQLite.Designer.SqliteDataAdapterToolboxItem, SQLite.Designer, Version=1.0.36.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139")]
[Designer("Microsoft.VSDesigner.Data.VS.SqlDataAdapterDesigner, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
#endif
public sealed class SqliteDataAdapter : DbDataAdapter
{
private static object _updatingEventPH = new object();
private static object _updatedEventPH = new object();
/// <overloads>
/// This class is just a shell around the DbDataAdapter. Nothing from DbDataAdapter is overridden here, just a few constructors are defined.
/// </overloads>
/// <summary>
/// Default constructor.
/// </summary>
public SqliteDataAdapter()
{
}
/// <summary>
/// Constructs a data adapter using the specified select command.
/// </summary>
/// <param name="cmd">The select command to associate with the adapter.</param>
public SqliteDataAdapter(SqliteCommand cmd)
{
SelectCommand = cmd;
}
/// <summary>
/// Constructs a data adapter with the supplied select command text and associated with the specified connection.
/// </summary>
/// <param name="commandText">The select command text to associate with the data adapter.</param>
/// <param name="connection">The connection to associate with the select command.</param>
public SqliteDataAdapter(string commandText, SqliteConnection connection)
{
SelectCommand = new SqliteCommand(commandText, connection);
}
/// <summary>
/// Constructs a data adapter with the specified select command text, and using the specified database connection string.
/// </summary>
/// <param name="commandText">The select command text to use to construct a select command.</param>
/// <param name="connectionString">A connection string suitable for passing to a new SqliteConnection, which is associated with the select command.</param>
public SqliteDataAdapter(string commandText, string connectionString)
{
SqliteConnection cnn = new SqliteConnection(connectionString);
SelectCommand = new SqliteCommand(commandText, cnn);
}
/// <summary>
/// Row updating event handler
/// </summary>
public event EventHandler<RowUpdatingEventArgs> RowUpdating
{
add
{
#if !PLATFORM_COMPACTFRAMEWORK
EventHandler<RowUpdatingEventArgs> previous = (EventHandler<RowUpdatingEventArgs>)base.Events[_updatingEventPH];
if ((previous != null) && (value.Target is DbCommandBuilder))
{
EventHandler<RowUpdatingEventArgs> handler = (EventHandler<RowUpdatingEventArgs>)FindBuilder(previous);
if (handler != null)
{
base.Events.RemoveHandler(_updatingEventPH, handler);
}
}
#endif
base.Events.AddHandler(_updatingEventPH, value);
}
remove { base.Events.RemoveHandler(_updatingEventPH, value); }
}
#if !PLATFORM_COMPACTFRAMEWORK
internal static Delegate FindBuilder(MulticastDelegate mcd)
{
if (mcd != null)
{
Delegate[] invocationList = mcd.GetInvocationList();
for (int i = 0; i < invocationList.Length; i++)
{
if (invocationList[i].Target is DbCommandBuilder)
{
return invocationList[i];
}
}
}
return null;
}
#endif
/// <summary>
/// Row updated event handler
/// </summary>
public event EventHandler<RowUpdatedEventArgs> RowUpdated
{
add { base.Events.AddHandler(_updatedEventPH, value); }
remove { base.Events.RemoveHandler(_updatedEventPH, value); }
}
/// <summary>
/// Raised by the underlying DbDataAdapter when a row is being updated
/// </summary>
/// <param name="value">The event's specifics</param>
protected override void OnRowUpdating(RowUpdatingEventArgs value)
{
EventHandler<RowUpdatingEventArgs> handler = base.Events[_updatingEventPH] as EventHandler<RowUpdatingEventArgs>;
if (handler != null)
handler(this, value);
}
/// <summary>
/// Raised by DbDataAdapter after a row is updated
/// </summary>
/// <param name="value">The event's specifics</param>
protected override void OnRowUpdated(RowUpdatedEventArgs value)
{
EventHandler<RowUpdatedEventArgs> handler = base.Events[_updatedEventPH] as EventHandler<RowUpdatedEventArgs>;
if (handler != null)
handler(this, value);
}
/// <summary>
/// Gets/sets the select command for this DataAdapter
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultValue((string)null), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
#endif
public new SqliteCommand SelectCommand
{
get { return (SqliteCommand)base.SelectCommand; }
set { base.SelectCommand = value; }
}
/// <summary>
/// Gets/sets the insert command for this DataAdapter
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultValue((string)null), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
#endif
public new SqliteCommand InsertCommand
{
get { return (SqliteCommand)base.InsertCommand; }
set { base.InsertCommand = value; }
}
/// <summary>
/// Gets/sets the update command for this DataAdapter
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultValue((string)null), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
#endif
public new SqliteCommand UpdateCommand
{
get { return (SqliteCommand)base.UpdateCommand; }
set { base.UpdateCommand = value; }
}
/// <summary>
/// Gets/sets the delete command for this DataAdapter
/// </summary>
#if !PLATFORM_COMPACTFRAMEWORK
[DefaultValue((string)null), Editor("Microsoft.VSDesigner.Data.Design.DBCommandEditor, Microsoft.VSDesigner, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a", "System.Drawing.Design.UITypeEditor, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
#endif
public new SqliteCommand DeleteCommand
{
get { return (SqliteCommand)base.DeleteCommand; }
set { base.DeleteCommand = value; }
}
}
}
|
