Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Diff of /System.Data.SQLite/SQLiteDataAdapter.cs [51a8cf] .. [d2857c] Maximize Restore

  Switch to side-by-side view

--- a/System.Data.SQLite/SQLiteDataAdapter.cs
+++ b/System.Data.SQLite/SQLiteDataAdapter.cs
@@ -3,188 +3,210 @@
  * Written by Robert Simpson (robert@blackcastlesoft.com)
  * 
  * Released to the public domain, use at your own risk!
- ********************************************************/
-
-namespace System.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.37.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; }
-    }
-  }
-}
+ ********************************************************/
+
+using System.ComponentModel;
+using System.Data.Common;
+
+namespace System.Data.SQLite
+{
+    /// <summary>
+    /// SQLite implementation of DbDataAdapter.
+    /// </summary>
+#if !PLATFORM_COMPACTFRAMEWORK
+    [DefaultEvent("RowUpdated")]
+    [ToolboxItem(
+        "SQLite.Designer.SQLiteDataAdapterToolboxItem, SQLite.Designer, Version=1.0.37.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 readonly object _updatingEventPH = new object();
+        private static readonly 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)
+        {
+            var cnn = new SQLiteConnection(connectionString);
+            SelectCommand = new SQLiteCommand(commandText, cnn);
+        }
+
+        /// <summary>
+        /// Row updating event handler
+        /// </summary>
+        public event EventHandler<RowUpdatingEventArgs> RowUpdating
+        {
+            add
+            {
+#if !PLATFORM_COMPACTFRAMEWORK
+                var previous = (EventHandler<RowUpdatingEventArgs>) base.Events[_updatingEventPH];
+                if ((previous != null) && (value.Target is DbCommandBuilder))
+                {
+                    var 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)
+        {
+            var 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)
+        {
+            var 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; }
+        }
+    }
+}