System.Data.SQLite

Check-in [e539f17af4]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add an example to the SQLiteModuleEnumerable class doc comments.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e539f17af4c2bd7ba1a17e50ffd39c9ae3ba93a1
User & Date: mistachkin 2013-06-26 18:17:47.232
Context
2013-06-26
23:50
Modify the index introspection code so that it does not treat PRAGMA table_info 'pk' column values as boolean. Fix for [f2c47a01eb]. check-in: 8d0c39afd2 user: mistachkin tags: trunk
18:17
Add an example to the SQLiteModuleEnumerable class doc comments. check-in: e539f17af4 user: mistachkin tags: trunk
04:52
Fixup external MSDN documentation links for the referenced generic interfaces. check-in: 0897c71426 user: mistachkin tags: trunk
Changes
Unified Diff Show Whitespace Changes Patch
Changes to System.Data.SQLite/SQLiteModuleEnumerable.cs.
213
214
215
216
217
218
219
220







































221
222
223
224
225
226
227

    #region SQLiteModuleEnumerable Class
    /// <summary>
    /// This class implements a virtual table module that exposes an
    /// <see cref="IEnumerable" /> object instance as a read-only virtual
    /// table.  It is not sealed and may be used as the base class for any
    /// user-defined virtual table class that wraps an
    /// <see cref="IEnumerable" /> object instance.







































    /// </summary>
    public class SQLiteModuleEnumerable : SQLiteModuleNoop /* NOT SEALED */
    {
        #region Private Constants
        /// <summary>
        /// The CREATE TABLE statement used to declare the schema for the
        /// virtual table.







|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266

    #region SQLiteModuleEnumerable Class
    /// <summary>
    /// This class implements a virtual table module that exposes an
    /// <see cref="IEnumerable" /> object instance as a read-only virtual
    /// table.  It is not sealed and may be used as the base class for any
    /// user-defined virtual table class that wraps an
    /// <see cref="IEnumerable" /> object instance.  The following short
    /// example shows it being used to treat an array of strings as a table
    /// data source:
    /// <code>
    ///   public static class Sample
    ///   {
    ///     public static void Main()
    ///     {
    ///       using (SQLiteConnection connection = new SQLiteConnection(
    ///           "Data Source=:memory:;"))
    ///       {
    ///         connection.Open();
    ///
    ///         connection.CreateModule(new SQLiteModuleEnumerable(
    ///           "sampleModule", new string[] { "one", "two", "three" }));
    ///
    ///         using (SQLiteCommand command = connection.CreateCommand())
    ///         {
    ///           command.CommandText =
    ///               "CREATE VIRTUAL TABLE t1 USING sampleModule;";
    ///
    ///           command.ExecuteNonQuery();
    ///         }
    ///
    ///         using (SQLiteCommand command = connection.CreateCommand())
    ///         {
    ///           command.CommandText = "SELECT * FROM t1;";
    ///
    ///           using (SQLiteDataReader dataReader = command.ExecuteReader())
    ///           {
    ///             while (dataReader.Read())
    ///               Console.WriteLine(dataReader[0].ToString());
    ///           }
    ///         }
    ///
    ///         connection.Close();
    ///       }
    ///     }
    ///   }
    /// </code>
    /// </summary>
    public class SQLiteModuleEnumerable : SQLiteModuleNoop /* NOT SEALED */
    {
        #region Private Constants
        /// <summary>
        /// The CREATE TABLE statement used to declare the schema for the
        /// virtual table.