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: |
e539f17af4c2bd7ba1a17e50ffd39c9a |
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
Changes to System.Data.SQLite/SQLiteModuleEnumerable.cs.
︙ | ︙ | |||
213 214 215 216 217 218 219 | #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 | | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 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. |
︙ | ︙ |