You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ibatis.apache.org by rg...@apache.org on 2009/06/14 03:51:36 UTC
svn commit: r784498 [2/3] - in /ibatis/trunk/cs/V3/src: ./
Apache.Ibatis.DataMapper.Sqlite.Test/
Apache.Ibatis.DataMapper.Sqlite.Test/Domain/
Apache.Ibatis.DataMapper.Sqlite.Test/Fixtures/
Apache.Ibatis.DataMapper.Sqlite.Test/Maps/ Apache.Ibatis.DataMa...
Added: ibatis/trunk/cs/V3/src/External-Bin/Net/2.0/System.Data.SQLite.XML
URL: http://svn.apache.org/viewvc/ibatis/trunk/cs/V3/src/External-Bin/Net/2.0/System.Data.SQLite.XML?rev=784498&view=auto
==============================================================================
--- ibatis/trunk/cs/V3/src/External-Bin/Net/2.0/System.Data.SQLite.XML (added)
+++ ibatis/trunk/cs/V3/src/External-Bin/Net/2.0/System.Data.SQLite.XML Sun Jun 14 01:51:36 2009
@@ -0,0 +1,3642 @@
+<?xml version="1.0"?>
+<doc>
+ <assembly>
+ <name>System.Data.SQLite</name>
+ </assembly>
+ <members>
+ <member name="F:System.Data.SQLite.SQLiteConnectionPool._connections">
+ <summary>
+ The connection pool object
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnectionPool._poolVersion">
+ <summary>
+ The default version number new pools will get
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnectionPool.Remove(System.String,System.Int32,System.Int32@)">
+ <summary>
+ Attempt to pull a pooled connection out of the queue for active duty
+ </summary>
+ <param name="fileName">The filename for a desired connection</param>
+ <param name="maxPoolSize">The maximum size the connection pool for the filename can be</param>
+ <param name="version">The pool version the returned connection will belong to</param>
+ <returns>Returns NULL if no connections were available. Even if none are, the poolversion will still be a valid pool version</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnectionPool.ClearAllPools">
+ <summary>
+ Clears out all pooled connections and rev's up the default pool version to force all old active objects
+ not in the pool to get discarded rather than returned to their pools.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnectionPool.ClearPool(System.String)">
+ <summary>
+ Clear a given pool for a given filename. Discards anything in the pool for the given file, and revs the pool
+ version so current active objects on the old version of the pool will get discarded rather than be returned to the pool.
+ </summary>
+ <param name="fileName">The filename of the pool to clear</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnectionPool.Add(System.String,System.Data.SQLite.SQLiteConnectionHandle,System.Int32)">
+ <summary>
+ Return a connection to the pool for someone else to use.
+ </summary>
+ <param name="fileName">The filename of the pool to use</param>
+ <param name="hdl">The connection handle to pool</param>
+ <param name="version">The pool version the handle was created under</param>
+ <remarks>
+ If the version numbers don't match between the connection and the pool, then the handle is discarded.
+ </remarks>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteConnectionPool.Pool">
+ <summary>
+ Keeps track of connections made on a specified file. The PoolVersion dictates whether old objects get
+ returned to the pool or discarded when no longer in use.
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteConnection">
+ <summary>
+ SQLite implentation of DbConnection.
+ </summary>
+ <remarks>
+ The <see cref="P:System.Data.SQLite.SQLiteConnection.ConnectionString">ConnectionString</see> property of the SQLiteConnection class can contain the following parameter(s), delimited with a semi-colon:
+ <list type="table">
+ <listheader>
+ <term>Parameter</term>
+ <term>Values</term>
+ <term>Required</term>
+ <term>Default</term>
+ </listheader>
+ <item>
+ <description>Data Source</description>
+ <description>{filename}</description>
+ <description>Y</description>
+ <description></description>
+ </item>
+ <item>
+ <description>Version</description>
+ <description>3</description>
+ <description>N</description>
+ <description>3</description>
+ </item>
+ <item>
+ <description>UseUTF16Encoding</description>
+ <description><b>True</b><br/><b>False</b></description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>DateTimeFormat</description>
+ <description><b>Ticks</b> - Use DateTime.Ticks<br/><b>ISO8601</b> - Use ISO8601 DateTime format</description>
+ <description>N</description>
+ <description>ISO8601</description>
+ </item>
+ <item>
+ <description>BinaryGUID</description>
+ <description><b>True</b> - Store GUID columns in binary form<br/><b>False</b> - Store GUID columns as text</description>
+ <description>N</description>
+ <description>True</description>
+ </item>
+ <item>
+ <description>Cache Size</description>
+ <description>{size in bytes}</description>
+ <description>N</description>
+ <description>2000</description>
+ </item>
+ <item>
+ <description>Synchronous</description>
+ <description><b>Normal</b> - Normal file flushing behavior<br/><b>Full</b> - Full flushing after all writes<br/><b>Off</b> - Underlying OS flushes I/O's</description>
+ <description>N</description>
+ <description>Normal</description>
+ </item>
+ <item>
+ <description>Page Size</description>
+ <description>{size in bytes}</description>
+ <description>N</description>
+ <description>1024</description>
+ </item>
+ <item>
+ <description>Password</description>
+ <description>{password}</description>
+ <description>N</description>
+ <description></description>
+ </item>
+ <item>
+ <description>Enlist</description>
+ <description><b>Y</b> - Automatically enlist in distributed transactions<br/><b>N</b> - No automatic enlistment</description>
+ <description>N</description>
+ <description>Y</description>
+ </item>
+ <item>
+ <description>Pooling</description>
+ <description><b>True</b> - Use connection pooling<br/><b>False</b> - Do not use connection pooling</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>FailIfMissing</description>
+ <description><b>True</b> - Don't create the database if it does not exist, throw an error instead<br/><b>False</b> - Automatically create the database if it does not exist</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>Max Page Count</description>
+ <description>{size in pages} - Limits the maximum number of pages (limits the size) of the database</description>
+ <description>N</description>
+ <description>0</description>
+ </item>
+ <item>
+ <description>Legacy Format</description>
+ <description><b>True</b> - Use the more compatible legacy 3.x database format<br/><b>False</b> - Use the newer 3.3x database format which compresses numbers more effectively</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>Default Timeout</description>
+ <description>{time in seconds}<br/>The default command timeout</description>
+ <description>N</description>
+ <description>30</description>
+ </item>
+ <item>
+ <description>Journal Mode</description>
+ <description><b>Delete</b> - Delete the journal file after a commit<br/><b>Persist</b> - Zero out and leave the journal file on disk after a commit<br/><b>Off</b> - Disable the rollback journal entirely</description>
+ <description>N</description>
+ <description>Delete</description>
+ </item>
+ <item>
+ <description>Read Only</description>
+ <description><b>True</b> - Open the database for read only access<br/><b>False</b> - Open the database for normal read/write access</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>Max Pool Size</description>
+ <description>The maximum number of connections for the given connection string that can be in the connection pool</description>
+ <description>N</description>
+ <description>100</description>
+ </item>
+ <item>
+ <description>Default IsolationLevel</description>
+ <description>The default transaciton isolation level</description>
+ <description>N</description>
+ <description>Serializable</description>
+ </item>
+ </list>
+ </remarks>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._connectionState">
+ <summary>
+ State of the current connection
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._connectionString">
+ <summary>
+ The connection string
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._transactionLevel">
+ <summary>
+ Nesting level of the transactions open on the connection
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._defaultIsolation">
+ <summary>
+ The default isolation level for new transactions
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._enlistment">
+ <summary>
+ Whether or not the connection is enlisted in a distrubuted transaction
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._sql">
+ <summary>
+ The base SQLite object to interop with
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._dataSource">
+ <summary>
+ The database filename minus path and extension
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._password">
+ <summary>
+ Temporary password storage, emptied after the database has been opened
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConnection._defaultTimeout">
+ <summary>
+ Default command timeout
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.#ctor">
+ <overloads>
+ Constructs a new SQLiteConnection object
+ </overloads>
+ <summary>
+ Default constructor
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.#ctor(System.String)">
+ <summary>
+ Initializes the connection with the specified connection string
+ </summary>
+ <param name="connectionString">The connection string to use on the connection</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.#ctor(System.Data.SQLite.SQLiteConnection)">
+ <summary>
+ Clones the settings and connection string from an existing connection. If the existing connection is already open, this
+ function will open its own connection, enumerate any attached databases of the original connection, and automatically
+ attach to them.
+ </summary>
+ <param name="connection"></param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Clone">
+ <summary>
+ Creates a clone of the connection. All attached databases and user-defined functions are cloned. If the existing connection is open, the cloned connection
+ will also be opened.
+ </summary>
+ <returns></returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Dispose(System.Boolean)">
+ <summary>
+ Disposes of the SQLiteConnection, closing it if it is active.
+ </summary>
+ <param name="disposing">True if the connection is being explicitly closed.</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.CreateFile(System.String)">
+ <summary>
+ Creates a database file. This just creates a zero-byte file which SQLite
+ will turn into a database when the file is opened properly.
+ </summary>
+ <param name="databaseFileName">The file to create</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.CompressFile(System.String)">
+ <summary>
+ On NTFS volumes, this function turns on the compression attribute for the given file.
+ It must not be open or referenced at the time of the function call.
+ </summary>
+ <param name="databaseFileName">The file to compress</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.DecompressFile(System.String)">
+ <summary>
+ On NTFS volumes, this function removes the compression attribute for the given file.
+ It must not be open or referenced at the time of the function call.
+ </summary>
+ <param name="databaseFileName">The file to decompress</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.OnStateChange(System.Data.ConnectionState)">
+ <summary>
+ Raises the state change event when the state of the connection changes
+ </summary>
+ <param name="newState">The new state. If it is different from the previous state, an event is raised.</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.BeginTransaction(System.Data.IsolationLevel,System.Boolean)">
+ <summary>
+ OBSOLETE. Creates a new SQLiteTransaction if one isn't already active on the connection.
+ </summary>
+ <param name="isolationLevel">This parameter is ignored.</param>
+ <param name="deferredLock">When TRUE, SQLite defers obtaining a write lock until a write operation is requested.
+ When FALSE, a writelock is obtained immediately. The default is TRUE, but in a multi-threaded multi-writer
+ environment, one may instead choose to lock the database immediately to avoid any possible writer deadlock.</param>
+ <returns>Returns a SQLiteTransaction object.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.BeginTransaction(System.Boolean)">
+ <summary>
+ OBSOLETE. Creates a new SQLiteTransaction if one isn't already active on the connection.
+ </summary>
+ <param name="deferredLock">When TRUE, SQLite defers obtaining a write lock until a write operation is requested.
+ When FALSE, a writelock is obtained immediately. The default is false, but in a multi-threaded multi-writer
+ environment, one may instead choose to lock the database immediately to avoid any possible writer deadlock.</param>
+ <returns>Returns a SQLiteTransaction object.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.BeginTransaction(System.Data.IsolationLevel)">
+ <summary>
+ Creates a new SQLiteTransaction if one isn't already active on the connection.
+ </summary>
+ <param name="isolationLevel">Supported isolation levels are Serializable, ReadCommitted and Unspecified.</param>
+ <remarks>
+ Unspecified will use the default isolation level specified in the connection string. If no isolation level is specified in the
+ connection string, Serializable is used.
+ Serializable transactions are the default. In this mode, the engine gets an immediate lock on the database, and no other threads
+ may begin a transaction. Other threads may read from the database, but not write.
+ With a ReadCommitted isolation level, locks are deferred and elevated as needed. It is possible for multiple threads to start
+ a transaction in ReadCommitted mode, but if a thread attempts to commit a transaction while another thread
+ has a ReadCommitted lock, it may timeout or cause a deadlock on both threads until both threads' CommandTimeout's are reached.
+ </remarks>
+ <returns>Returns a SQLiteTransaction object.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.BeginTransaction">
+ <summary>
+ Creates a new SQLiteTransaction if one isn't already active on the connection.
+ </summary>
+ <returns>Returns a SQLiteTransaction object.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.BeginDbTransaction(System.Data.IsolationLevel)">
+ <summary>
+ Forwards to the local BeginTransaction() function
+ </summary>
+ <param name="isolationLevel">Supported isolation levels are Unspecified, Serializable, and ReadCommitted</param>
+ <returns></returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ChangeDatabase(System.String)">
+ <summary>
+ Not implemented
+ </summary>
+ <param name="databaseName"></param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Close">
+ <summary>
+ When the database connection is closed, all commands linked to this connection are automatically reset.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ClearPool(System.Data.SQLite.SQLiteConnection)">
+ <summary>
+ Clears the connection pool associated with the connection. Any other active connections using the same database file
+ will be discarded instead of returned to the pool when they are closed.
+ </summary>
+ <param name="connection"></param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ClearAllPools">
+ <summary>
+ Clears all connection pools. Any active connections will be discarded instead of sent to the pool when they are closed.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.CreateCommand">
+ <summary>
+ Create a new SQLiteCommand and associate it with this connection.
+ </summary>
+ <returns>Returns an instantiated SQLiteCommand object already assigned to this connection.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.CreateDbCommand">
+ <summary>
+ Forwards to the local CreateCommand() function
+ </summary>
+ <returns></returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ParseConnectionString(System.String)">
+ <summary>
+ Parses the connection string into component parts
+ </summary>
+ <param name="connectionString">The connection string to parse</param>
+ <returns>An array of key-value pairs representing each parameter of the connection string</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.EnlistTransaction(System.Transactions.Transaction)">
+ <summary>
+ Manual distributed transaction enlistment support
+ </summary>
+ <param name="transaction">The distributed transaction to enlist in</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.FindKey(System.Collections.Generic.SortedList{System.String,System.String},System.String,System.String)">
+ <summary>
+ Looks for a key in the array of key/values of the parameter string. If not found, return the specified default value
+ </summary>
+ <param name="items">The list to look in</param>
+ <param name="key">The key to find</param>
+ <param name="defValue">The default value to return if the key is not found</param>
+ <returns>The value corresponding to the specified key, or the default value if not found.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Open">
+ <summary>
+ Opens the connection using the parameters found in the <see cref="P:System.Data.SQLite.SQLiteConnection.ConnectionString">ConnectionString</see>
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ChangePassword(System.String)">
+ <summary>
+ Change the password (or assign a password) to an open database.
+ </summary>
+ <remarks>
+ No readers or writers may be active for this process. The database must already be open
+ and if it already was password protected, the existing password must already have been supplied.
+ </remarks>
+ <param name="newPassword">The new password to assign to the database</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ChangePassword(System.Byte[])">
+ <summary>
+ Change the password (or assign a password) to an open database.
+ </summary>
+ <remarks>
+ No readers or writers may be active for this process. The database must already be open
+ and if it already was password protected, the existing password must already have been supplied.
+ </remarks>
+ <param name="newPassword">The new password to assign to the database</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.SetPassword(System.String)">
+ <summary>
+ Sets the password for a password-protected database. A password-protected database is
+ unusable for any operation until the password has been set.
+ </summary>
+ <param name="databasePassword">The password for the database</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.SetPassword(System.Byte[])">
+ <summary>
+ Sets the password for a password-protected database. A password-protected database is
+ unusable for any operation until the password has been set.
+ </summary>
+ <param name="databasePassword">The password for the database</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.ExpandFileName(System.String)">
+ <summary>
+ Expand the filename of the data source, resolving the |DataDirectory| macro as appropriate.
+ </summary>
+ <param name="sourceFile">The database filename to expand</param>
+ <returns>The expanded path and filename of the filename</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.GetSchema">
+ <overloads>
+ The following commands are used to extract schema information out of the database. Valid schema types are:
+ <list type="bullet">
+ <item>
+ <description>MetaDataCollections</description>
+ </item>
+ <item>
+ <description>DataSourceInformation</description>
+ </item>
+ <item>
+ <description>Catalogs</description>
+ </item>
+ <item>
+ <description>Columns</description>
+ </item>
+ <item>
+ <description>ForeignKeys</description>
+ </item>
+ <item>
+ <description>Indexes</description>
+ </item>
+ <item>
+ <description>IndexColumns</description>
+ </item>
+ <item>
+ <description>Tables</description>
+ </item>
+ <item>
+ <description>Views</description>
+ </item>
+ <item>
+ <description>ViewColumns</description>
+ </item>
+ </list>
+ </overloads>
+ <summary>
+ Returns the MetaDataCollections schema
+ </summary>
+ <returns>A DataTable of the MetaDataCollections schema</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.GetSchema(System.String)">
+ <summary>
+ Returns schema information of the specified collection
+ </summary>
+ <param name="collectionName">The schema collection to retrieve</param>
+ <returns>A DataTable of the specified collection</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.GetSchema(System.String,System.String[])">
+ <summary>
+ Retrieves schema information using the specified constraint(s) for the specified collection
+ </summary>
+ <param name="collectionName">The collection to retrieve</param>
+ <param name="restrictionValues">The restrictions to impose</param>
+ <returns>A DataTable of the specified collection</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_MetaDataCollections">
+ <summary>
+ Builds a MetaDataCollections schema datatable
+ </summary>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_DataSourceInformation">
+ <summary>
+ Builds a DataSourceInformation datatable
+ </summary>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_Columns(System.String,System.String,System.String)">
+ <summary>
+ Build a Columns schema
+ </summary>
+ <param name="strCatalog">The catalog (attached database) to query, can be null</param>
+ <param name="strTable">The table to retrieve schema information for, must not be null</param>
+ <param name="strColumn">The column to retrieve schema information for, can be null</param>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_Indexes(System.String,System.String,System.String)">
+ <summary>
+ Returns index information for the given database and catalog
+ </summary>
+ <param name="strCatalog">The catalog (attached database) to query, can be null</param>
+ <param name="strIndex">The name of the index to retrieve information for, can be null</param>
+ <param name="strTable">The table to retrieve index information for, can be null</param>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_Tables(System.String,System.String,System.String)">
+ <summary>
+ Retrieves table schema information for the database and catalog
+ </summary>
+ <param name="strCatalog">The catalog (attached database) to retrieve tables on</param>
+ <param name="strTable">The table to retrieve, can be null</param>
+ <param name="strType">The table type, can be null</param>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_Views(System.String,System.String)">
+ <summary>
+ Retrieves view schema information for the database
+ </summary>
+ <param name="strCatalog">The catalog (attached database) to retrieve views on</param>
+ <param name="strView">The view name, can be null</param>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_Catalogs(System.String)">
+ <summary>
+ Retrieves catalog (attached databases) schema information for the database
+ </summary>
+ <param name="strCatalog">The catalog to retrieve, can be null</param>
+ <returns>DataTable</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_IndexColumns(System.String,System.String,System.String,System.String)">
+ <summary>
+ Returns the base column information for indexes in a database
+ </summary>
+ <param name="strCatalog">The catalog to retrieve indexes for (can be null)</param>
+ <param name="strTable">The table to restrict index information by (can be null)</param>
+ <param name="strIndex">The index to restrict index information by (can be null)</param>
+ <param name="strColumn">The source column to restrict index information by (can be null)</param>
+ <returns>A DataTable containing the results</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_ViewColumns(System.String,System.String,System.String)">
+ <summary>
+ Returns detailed column information for a specified view
+ </summary>
+ <param name="strCatalog">The catalog to retrieve columns for (can be null)</param>
+ <param name="strView">The view to restrict column information by (can be null)</param>
+ <param name="strColumn">The source column to restrict column information by (can be null)</param>
+ <returns>A DataTable containing the results</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConnection.Schema_ForeignKeys(System.String,System.String,System.String)">
+ <summary>
+ Retrieves foreign key information from the specified set of filters
+ </summary>
+ <param name="strCatalog">An optional catalog to restrict results on</param>
+ <param name="strTable">An optional table to restrict results on</param>
+ <param name="strKeyName">An optional foreign key name to restrict results on</param>
+ <returns>A DataTable with the results of the query</returns>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.DbProviderFactory">
+ <summary>
+ Returns a SQLiteProviderFactory object.
+ </summary>
+ </member>
+ <member name="E:System.Data.SQLite.SQLiteConnection.StateChange">
+ <summary>
+ This event is raised whenever the database is opened or closed.
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.ConnectionString">
+ <summary>
+ The connection string containing the parameters for the connection
+ </summary>
+ <remarks>
+ <list type="table">
+ <listheader>
+ <term>Parameter</term>
+ <term>Values</term>
+ <term>Required</term>
+ <term>Default</term>
+ </listheader>
+ <item>
+ <description>Data Source</description>
+ <description>{filename}</description>
+ <description>Y</description>
+ <description></description>
+ </item>
+ <item>
+ <description>Version</description>
+ <description>3</description>
+ <description>N</description>
+ <description>3</description>
+ </item>
+ <item>
+ <description>UseUTF16Encoding</description>
+ <description><b>True</b><br/><b>False</b></description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>DateTimeFormat</description>
+ <description><b>Ticks</b> - Use DateTime.Ticks<br/><b>ISO8601</b> - Use ISO8601 DateTime format<br/><b>JulianDay</b> - Use JulianDay format</description>
+ <description>N</description>
+ <description>ISO8601</description>
+ </item>
+ <item>
+ <description>BinaryGUID</description>
+ <description><b>Yes/On/1</b> - Store GUID columns in binary form<br/><b>No/Off/0</b> - Store GUID columns as text</description>
+ <description>N</description>
+ <description>On</description>
+ </item>
+ <item>
+ <description>Cache Size</description>
+ <description>{size in bytes}</description>
+ <description>N</description>
+ <description>2000</description>
+ </item>
+ <item>
+ <description>Synchronous</description>
+ <description><b>Normal</b> - Normal file flushing behavior<br/><b>Full</b> - Full flushing after all writes<br/><b>Off</b> - Underlying OS flushes I/O's</description>
+ <description>N</description>
+ <description>Normal</description>
+ </item>
+ <item>
+ <description>Page Size</description>
+ <description>{size in bytes}</description>
+ <description>N</description>
+ <description>1024</description>
+ </item>
+ <item>
+ <description>Password</description>
+ <description>{password}</description>
+ <description>N</description>
+ <description></description>
+ </item>
+ <item>
+ <description>Enlist</description>
+ <description><B>Y</B> - Automatically enlist in distributed transactions<br/><b>N</b> - No automatic enlistment</description>
+ <description>N</description>
+ <description>Y</description>
+ </item>
+ <item>
+ <description>Pooling</description>
+ <description><b>True</b> - Use connection pooling<br/><b>False</b> - Do not use connection pooling</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>FailIfMissing</description>
+ <description><b>True</b> - Don't create the database if it does not exist, throw an error instead<br/><b>False</b> - Automatically create the database if it does not exist</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>Max Page Count</description>
+ <description>{size in pages} - Limits the maximum number of pages (limits the size) of the database</description>
+ <description>N</description>
+ <description>0</description>
+ </item>
+ <item>
+ <description>Legacy Format</description>
+ <description><b>True</b> - Use the more compatible legacy 3.x database format<br/><b>False</b> - Use the newer 3.3x database format which compresses numbers more effectively</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>Default Timeout</description>
+ <description>{time in seconds}<br/>The default command timeout</description>
+ <description>N</description>
+ <description>30</description>
+ </item>
+ <item>
+ <description>Journal Mode</description>
+ <description><b>Delete</b> - Delete the journal file after a commit<br/><b>Persist</b> - Zero out and leave the journal file on disk after a commit<br/><b>Off</b> - Disable the rollback journal entirely</description>
+ <description>N</description>
+ <description>Delete</description>
+ </item>
+ <item>
+ <description>Read Only</description>
+ <description><b>True</b> - Open the database for read only access<br/><b>False</b> - Open the database for normal read/write access</description>
+ <description>N</description>
+ <description>False</description>
+ </item>
+ <item>
+ <description>Max Pool Size</description>
+ <description>The maximum number of connections for the given connection string that can be in the connection pool</description>
+ <description>N</description>
+ <description>100</description>
+ </item>
+ <item>
+ <description>Default IsolationLevel</description>
+ <description>The default transaciton isolation level</description>
+ <description>N</description>
+ <description>Serializable</description>
+ </item>
+ </list>
+ </remarks>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.DataSource">
+ <summary>
+ Returns the filename without extension or path
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.Database">
+ <summary>
+ Returns an empty string
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.DefaultTimeout">
+ <summary>
+ Gets/sets the default command timeout for newly-created commands. This is especially useful for
+ commands used internally such as inside a SQLiteTransaction, where setting the timeout is not possible.
+ This can also be set in the ConnectionString with "Default Timeout"
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.ServerVersion">
+ <summary>
+ Returns the version of the underlying SQLite database engine
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.SQLiteVersion">
+ <summary>
+ Returns the version of the underlying SQLite database engine
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteConnection.State">
+ <summary>
+ Returns the state of the connection.
+ </summary>
+ </member>
+ <member name="E:System.Data.SQLite.SQLiteConnection.Update">
+ <summary>
+ This event is raised whenever SQLite makes an update/delete/insert into the database on
+ this connection. It only applies to the given connection.
+ </summary>
+ </member>
+ <member name="E:System.Data.SQLite.SQLiteConnection.Commit">
+ <summary>
+ This event is raised whenever SQLite is committing a transaction.
+ Return non-zero to trigger a rollback
+ </summary>
+ </member>
+ <member name="E:System.Data.SQLite.SQLiteConnection.RollBack">
+ <summary>
+ This event is raised whenever SQLite is committing a transaction.
+ Return non-zero to trigger a rollback
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteDataAdapter">
+ <summary>
+ SQLite implementation of DbDataAdapter.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteDataAdapter.#ctor">
+ <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>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteDataAdapter.#ctor(System.Data.SQLite.SQLiteCommand)">
+ <summary>
+ Constructs a data adapter using the specified select command.
+ </summary>
+ <param name="cmd">The select command to associate with the adapter.</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteDataAdapter.#ctor(System.String,System.Data.SQLite.SQLiteConnection)">
+ <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>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteDataAdapter.#ctor(System.String,System.String)">
+ <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>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteDataAdapter.OnRowUpdating(System.Data.Common.RowUpdatingEventArgs)">
+ <summary>
+ Raised by the underlying DbDataAdapter when a row is being updated
+ </summary>
+ <param name="value">The event's specifics</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteDataAdapter.OnRowUpdated(System.Data.Common.RowUpdatedEventArgs)">
+ <summary>
+ Raised by DbDataAdapter after a row is updated
+ </summary>
+ <param name="value">The event's specifics</param>
+ </member>
+ <member name="E:System.Data.SQLite.SQLiteDataAdapter.RowUpdating">
+ <summary>
+ Row updating event handler
+ </summary>
+ </member>
+ <member name="E:System.Data.SQLite.SQLiteDataAdapter.RowUpdated">
+ <summary>
+ Row updated event handler
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteDataAdapter.SelectCommand">
+ <summary>
+ Gets/sets the select command for this DataAdapter
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteDataAdapter.InsertCommand">
+ <summary>
+ Gets/sets the insert command for this DataAdapter
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteDataAdapter.UpdateCommand">
+ <summary>
+ Gets/sets the update command for this DataAdapter
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteDataAdapter.DeleteCommand">
+ <summary>
+ Gets/sets the delete command for this DataAdapter
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteConvert">
+ <summary>
+ This base class provides datatype conversion services for the SQLite provider.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConvert._datetimeFormats">
+ <summary>
+ An array of ISO8601 datetime formats we support conversion from
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConvert._utf8">
+ <summary>
+ An UTF-8 Encoding instance, so we can convert strings to and from UTF-8
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteConvert._datetimeFormat">
+ <summary>
+ The default DateTime format for this instance
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.#ctor(System.Data.SQLite.SQLiteDateFormats)">
+ <summary>
+ Initializes the conversion class
+ </summary>
+ <param name="fmt">The default date/time format to use for this instance</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToUTF8(System.String)">
+ <summary>
+ Converts a string to a UTF-8 encoded byte array sized to include a null-terminating character.
+ </summary>
+ <param name="sourceText">The string to convert to UTF-8</param>
+ <returns>A byte array containing the converted string plus an extra 0 terminating byte at the end of the array.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToUTF8(System.DateTime)">
+ <summary>
+ Convert a DateTime to a UTF-8 encoded, zero-terminated byte array.
+ </summary>
+ <remarks>
+ This function is a convenience function, which first calls ToString() on the DateTime, and then calls ToUTF8() with the
+ string result.
+ </remarks>
+ <param name="dateTimeValue">The DateTime to convert.</param>
+ <returns>The UTF-8 encoded string, including a 0 terminating byte at the end of the array.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToString(System.IntPtr,System.Int32)">
+ <summary>
+ Converts a UTF-8 encoded IntPtr of the specified length into a .NET string
+ </summary>
+ <param name="nativestring">The pointer to the memory where the UTF-8 string is encoded</param>
+ <param name="nativestringlen">The number of bytes to decode</param>
+ <returns>A string containing the translated character(s)</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.UTF8ToString(System.IntPtr,System.Int32)">
+ <summary>
+ Converts a UTF-8 encoded IntPtr of the specified length into a .NET string
+ </summary>
+ <param name="nativestring">The pointer to the memory where the UTF-8 string is encoded</param>
+ <param name="nativestringlen">The number of bytes to decode</param>
+ <returns>A string containing the translated character(s)</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToDateTime(System.String)">
+ <summary>
+ Converts a string into a DateTime, using the current DateTimeFormat specified for the connection when it was opened.
+ </summary>
+ <remarks>
+ Acceptable ISO8601 DateTime formats are:
+ yyyy-MM-dd HH:mm:ss
+ yyyyMMddHHmmss
+ yyyyMMddTHHmmssfffffff
+ yyyy-MM-dd
+ yy-MM-dd
+ yyyyMMdd
+ HH:mm:ss
+ THHmmss
+ </remarks>
+ <param name="dateText">The string containing either a Tick value, a JulianDay double, or an ISO8601-format string</param>
+ <returns>A DateTime value</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToDateTime(System.Double)">
+ <summary>
+ Converts a julianday value into a DateTime
+ </summary>
+ <param name="julianDay">The value to convert</param>
+ <returns>A .NET DateTime</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToJulianDay(System.DateTime)">
+ <summary>
+ Converts a DateTime struct to a JulianDay double
+ </summary>
+ <param name="value">The DateTime to convert</param>
+ <returns>The JulianDay value the Datetime represents</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToString(System.DateTime)">
+ <summary>
+ Converts a DateTime to a string value, using the current DateTimeFormat specified for the connection when it was opened.
+ </summary>
+ <param name="dateValue">The DateTime value to convert</param>
+ <returns>Either a string consisting of the tick count for DateTimeFormat.Ticks, a JulianDay double, or a date/time in ISO8601 format.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToDateTime(System.IntPtr,System.Int32)">
+ <summary>
+ Internal function to convert a UTF-8 encoded IntPtr of the specified length to a DateTime.
+ </summary>
+ <remarks>
+ This is a convenience function, which first calls ToString() on the IntPtr to convert it to a string, then calls
+ ToDateTime() on the string to return a DateTime.
+ </remarks>
+ <param name="ptr">A pointer to the UTF-8 encoded string</param>
+ <param name="len">The length in bytes of the string</param>
+ <returns>The parsed DateTime value</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.Split(System.String,System.Char)">
+ <summary>
+ Smart method of splitting a string. Skips quoted elements, removes the quotes.
+ </summary>
+ <remarks>
+ This split function works somewhat like the String.Split() function in that it breaks apart a string into
+ pieces and returns the pieces as an array. The primary differences are:
+ <list type="bullet">
+ <item><description>Only one character can be provided as a separator character</description></item>
+ <item><description>Quoted text inside the string is skipped over when searching for the separator, and the quotes are removed.</description></item>
+ </list>
+ Thus, if splitting the following string looking for a comma:<br/>
+ One,Two, "Three, Four", Five<br/>
+ <br/>
+ The resulting array would contain<br/>
+ [0] One<br/>
+ [1] Two<br/>
+ [2] Three, Four<br/>
+ [3] Five<br/>
+ <br/>
+ Note that the leading and trailing spaces were removed from each item during the split.
+ </remarks>
+ <param name="source">Source string to split apart</param>
+ <param name="separator">Separator character</param>
+ <returns>A string array of the split up elements</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToBoolean(System.Object)">
+ <summary>
+ Convert a value to true or false.
+ </summary>
+ <param name="source">A string or number representing true or false</param>
+ <returns></returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ToBoolean(System.String)">
+ <summary>
+ Convert a string to true or false.
+ </summary>
+ <param name="source">A string representing true or false</param>
+ <returns></returns>
+ <remarks>
+ "yes", "no", "y", "n", "0", "1", "on", "off" as well as Boolean.FalseString and Boolean.TrueString will all be
+ converted to a proper boolean value.
+ </remarks>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.ColumnToType(System.Data.SQLite.SQLiteStatement,System.Int32,System.Data.SQLite.SQLiteType)">
+ <summary>
+ Determines the data type of a column in a statement
+ </summary>
+ <param name="stmt">The statement to retrieve information for</param>
+ <param name="i">The column to retrieve type information on</param>
+ <param name="typ">The SQLiteType to receive the affinity for the given column</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.SQLiteTypeToType(System.Data.SQLite.SQLiteType)">
+ <summary>
+ Converts a SQLiteType to a .NET Type object
+ </summary>
+ <param name="t">The SQLiteType to convert</param>
+ <returns>Returns a .NET Type object</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.TypeToDbType(System.Type)">
+ <summary>
+ For a given intrinsic type, return a DbType
+ </summary>
+ <param name="typ">The native type to convert</param>
+ <returns>The corresponding (closest match) DbType</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.DbTypeToColumnSize(System.Data.DbType)">
+ <summary>
+ Returns the ColumnSize for the given DbType
+ </summary>
+ <param name="typ">The DbType to get the size of</param>
+ <returns></returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.DbTypeToType(System.Data.DbType)">
+ <summary>
+ Convert a DbType to a Type
+ </summary>
+ <param name="typ">The DbType to convert from</param>
+ <returns>The closest-match .NET type</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.TypeToAffinity(System.Type)">
+ <summary>
+ For a given type, return the closest-match SQLite TypeAffinity, which only understands a very limited subset of types.
+ </summary>
+ <param name="typ">The type to evaluate</param>
+ <returns>The SQLite type affinity for that type.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteConvert.TypeNameToDbType(System.String)">
+ <summary>
+ For a given type name, return a closest-match .NET type
+ </summary>
+ <param name="Name">The name of the type to match</param>
+ <returns>The .NET DBType the text evaluates to.</returns>
+ </member>
+ <member name="T:System.Data.SQLite.TypeAffinity">
+ <summary>
+ SQLite has very limited types, and is inherently text-based. The first 5 types below represent the sum of all types SQLite
+ understands. The DateTime extension to the spec is for internal use only.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.Uninitialized">
+ <summary>
+ Not used
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.Int64">
+ <summary>
+ All integers in SQLite default to Int64
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.Double">
+ <summary>
+ All floating point numbers in SQLite default to double
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.Text">
+ <summary>
+ The default data type of SQLite is text
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.Blob">
+ <summary>
+ Typically blob types are only seen when returned from a function
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.Null">
+ <summary>
+ Null types can be returned from functions
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.DateTime">
+ <summary>
+ Used internally by this provider
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.TypeAffinity.None">
+ <summary>
+ Used internally
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteDateFormats">
+ <summary>
+ This implementation of SQLite for ADO.NET can process date/time fields in databases in only one of three formats. Ticks, ISO8601
+ and JulianDay.
+ </summary>
+ <remarks>
+ ISO8601 is more compatible, readable, fully-processable, but less accurate as it doesn't provide time down to fractions of a second.
+ JulianDay is the numeric format the SQLite uses internally and is arguably the most compatible with 3rd party tools. It is
+ not readable as text without post-processing.
+ Ticks less compatible with 3rd party tools that query the database, and renders the DateTime field unreadable as text without post-processing.
+
+ The preferred order of choosing a datetime format is JulianDay, ISO8601, and then Ticks. Ticks is mainly present for legacy
+ code support.
+ </remarks>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDateFormats.Ticks">
+ <summary>
+ Using ticks is not recommended and is not well supported with LINQ.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDateFormats.ISO8601">
+ <summary>
+ The default format for this provider.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDateFormats.JulianDay">
+ <summary>
+ JulianDay format, which is what SQLite uses internally
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteJournalModeEnum">
+ <summary>
+ This enum determines how SQLite treats its journal file.
+ </summary>
+ <remarks>
+ By default SQLite will create and delete the journal file when needed during a transaction.
+ However, for some computers running certain filesystem monitoring tools, the rapid
+ creation and deletion of the journal file can cause those programs to fail, or to interfere with SQLite.
+
+ If a program or virus scanner is interfering with SQLite's journal file, you may receive errors like "unable to open database file"
+ when starting a transaction. If this is happening, you may want to change the default journal mode to Persist.
+ </remarks>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteJournalModeEnum.Delete">
+ <summary>
+ The default mode, this causes SQLite to create and destroy the journal file as-needed.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteJournalModeEnum.Persist">
+ <summary>
+ When this is set, SQLite will keep the journal file even after a transaction has completed. It's contents will be erased,
+ and the journal re-used as often as needed. If it is deleted, it will be recreated the next time it is needed.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteJournalModeEnum.Off">
+ <summary>
+ This option disables the rollback journal entirely. Interrupted transactions or a program crash can cause database
+ corruption in this mode!
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteType">
+ <summary>
+ Struct used internally to determine the datatype of a column in a resultset
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteType.Type">
+ <summary>
+ The DbType of the column, or DbType.Object if it cannot be determined
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteType.Affinity">
+ <summary>
+ The affinity of a column, used for expressions or when Type is DbType.Object
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteTransaction">
+ <summary>
+ SQLite implementation of DbTransaction.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteTransaction._cnn">
+ <summary>
+ The connection to which this transaction is bound
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteTransaction.#ctor(System.Data.SQLite.SQLiteConnection,System.Boolean)">
+ <summary>
+ Constructs the transaction object, binding it to the supplied connection
+ </summary>
+ <param name="connection">The connection to open a transaction on</param>
+ <param name="deferredLock">TRUE to defer the writelock, or FALSE to lock immediately</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteTransaction.Commit">
+ <summary>
+ Commits the current transaction.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteTransaction.Dispose(System.Boolean)">
+ <summary>
+ Disposes the transaction. If it is currently active, any changes are rolled back.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteTransaction.Rollback">
+ <summary>
+ Rolls back the active transaction.
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteTransaction.Connection">
+ <summary>
+ Returns the underlying connection to which this transaction applies.
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteTransaction.DbConnection">
+ <summary>
+ Forwards to the local Connection property
+ </summary>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteTransaction.IsolationLevel">
+ <summary>
+ Gets the isolation level of the transaction. SQLite only supports Serializable transactions.
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteKeyReader">
+ <summary>
+ This class provides key info for a given SQLite statement.
+ <remarks>
+ Providing key information for a given statement is non-trivial :(
+ </remarks>
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteKeyReader.#ctor(System.Data.SQLite.SQLiteConnection,System.Data.SQLite.SQLiteDataReader,System.Data.SQLite.SQLiteStatement)">
+ <summary>
+ This function does all the nasty work at determining what keys need to be returned for
+ a given statement.
+ </summary>
+ <param name="cnn"></param>
+ <param name="reader"></param>
+ <param name="stmt"></param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteKeyReader.Sync">
+ <summary>
+ Make sure all the subqueries are open and ready and sync'd with the current rowid
+ of the table they're supporting
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteKeyReader.Reset">
+ <summary>
+ Release any readers on any subqueries
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteKeyReader.AppendSchemaTable(System.Data.DataTable)">
+ <summary>
+ Append all the columns we've added to the original query to the schema
+ </summary>
+ <param name="tbl"></param>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteKeyReader.Count">
+ <summary>
+ How many additional columns of keyinfo we're holding
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteKeyReader.KeyInfo">
+ <summary>
+ Used to support CommandBehavior.KeyInfo
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteKeyReader.KeyQuery">
+ <summary>
+ A single sub-query for a given table/database.
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteFunction">
+ <summary>
+ This abstract class is designed to handle user-defined functions easily. An instance of the derived class is made for each
+ connection to the database.
+ </summary>
+ <remarks>
+ Although there is one instance of a class derived from SQLiteFunction per database connection, the derived class has no access
+ to the underlying connection. This is necessary to deter implementers from thinking it would be a good idea to make database
+ calls during processing.
+
+ It is important to distinguish between a per-connection instance, and a per-SQL statement context. One instance of this class
+ services all SQL statements being stepped through on that connection, and there can be many. One should never store per-statement
+ information in member variables of user-defined function classes.
+
+ For aggregate functions, always create and store your per-statement data in the contextData object on the 1st step. This data will
+ be automatically freed for you (and Dispose() called if the item supports IDisposable) when the statement completes.
+ </remarks>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._base">
+ <summary>
+ The base connection this function is attached to
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._contextDataList">
+ <summary>
+ Internal array used to keep track of aggregate function context data
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._InvokeFunc">
+ <summary>
+ Holds a reference to the callback function for user functions
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._StepFunc">
+ <summary>
+ Holds a reference to the callbakc function for stepping in an aggregate function
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._FinalFunc">
+ <summary>
+ Holds a reference to the callback function for finalizing an aggregate function
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._CompareFunc">
+ <summary>
+ Holds a reference to the callback function for collation sequences
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._context">
+ <summary>
+ Current context of the current callback. Only valid during a callback
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteFunction._registeredFunctions">
+ <summary>
+ This static list contains all the user-defined functions declared using the proper attributes.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.#ctor">
+ <summary>
+ Internal constructor, initializes the function's internal variables.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.Invoke(System.Object[])">
+ <summary>
+ Scalar functions override this method to do their magic.
+ </summary>
+ <remarks>
+ Parameters passed to functions have only an affinity for a certain data type, there is no underlying schema available
+ to force them into a certain type. Therefore the only types you will ever see as parameters are
+ DBNull.Value, Int64, Double, String or byte[] array.
+ </remarks>
+ <param name="args">The arguments for the command to process</param>
+ <returns>You may return most simple types as a return value, null or DBNull.Value to return null, DateTime, or
+ you may return an Exception-derived class if you wish to return an error to SQLite. Do not actually throw the error,
+ just return it!</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.Step(System.Object[],System.Int32,System.Object@)">
+ <summary>
+ Aggregate functions override this method to do their magic.
+ </summary>
+ <remarks>
+ Typically you'll be updating whatever you've placed in the contextData field and returning as quickly as possible.
+ </remarks>
+ <param name="args">The arguments for the command to process</param>
+ <param name="stepNumber">The 1-based step number. This is incrememted each time the step method is called.</param>
+ <param name="contextData">A placeholder for implementers to store contextual data pertaining to the current context.</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.Final(System.Object)">
+ <summary>
+ Aggregate functions override this method to finish their aggregate processing.
+ </summary>
+ <remarks>
+ If you implemented your aggregate function properly,
+ you've been recording and keeping track of your data in the contextData object provided, and now at this stage you should have
+ all the information you need in there to figure out what to return.
+ NOTE: It is possible to arrive here without receiving a previous call to Step(), in which case the contextData will
+ be null. This can happen when no rows were returned. You can either return null, or 0 or some other custom return value
+ if that is the case.
+ </remarks>
+ <param name="contextData">Your own assigned contextData, provided for you so you can return your final results.</param>
+ <returns>You may return most simple types as a return value, null or DBNull.Value to return null, DateTime, or
+ you may return an Exception-derived class if you wish to return an error to SQLite. Do not actually throw the error,
+ just return it!
+ </returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.Compare(System.String,System.String)">
+ <summary>
+ User-defined collation sequences override this method to provide a custom string sorting algorithm.
+ </summary>
+ <param name="param1">The first string to compare</param>
+ <param name="param2">The second strnig to compare</param>
+ <returns>1 if param1 is greater than param2, 0 if they are equal, or -1 if param1 is less than param2</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.ConvertParams(System.Int32,System.IntPtr)">
+ <summary>
+ Converts an IntPtr array of context arguments to an object array containing the resolved parameters the pointers point to.
+ </summary>
+ <remarks>
+ Parameters passed to functions have only an affinity for a certain data type, there is no underlying schema available
+ to force them into a certain type. Therefore the only types you will ever see as parameters are
+ DBNull.Value, Int64, Double, String or byte[] array.
+ </remarks>
+ <param name="nArgs">The number of arguments</param>
+ <param name="argsptr">A pointer to the array of arguments</param>
+ <returns>An object array of the arguments once they've been converted to .NET values</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.SetReturnValue(System.IntPtr,System.Object)">
+ <summary>
+ Takes the return value from Invoke() and Final() and figures out how to return it to SQLite's context.
+ </summary>
+ <param name="context">The context the return value applies to</param>
+ <param name="returnValue">The parameter to return to SQLite</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.ScalarCallback(System.IntPtr,System.Int32,System.IntPtr)">
+ <summary>
+ Internal scalar callback function, which wraps the raw context pointer and calls the virtual Invoke() method.
+ </summary>
+ <param name="context">A raw context pointer</param>
+ <param name="nArgs">Number of arguments passed in</param>
+ <param name="argsptr">A pointer to the array of arguments</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.CompareCallback(System.IntPtr,System.Int32,System.IntPtr,System.Int32,System.IntPtr)">
+ <summary>
+ Internal collation sequence function, which wraps up the raw string pointers and executes the Compare() virtual function.
+ </summary>
+ <param name="ptr">Not used</param>
+ <param name="len1">Length of the string pv1</param>
+ <param name="ptr1">Pointer to the first string to compare</param>
+ <param name="len2">Length of the string pv2</param>
+ <param name="ptr2">Pointer to the second string to compare</param>
+ <returns>Returns -1 if the first string is less than the second. 0 if they are equal, or 1 if the first string is greater
+ than the second.</returns>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.StepCallback(System.IntPtr,System.Int32,System.IntPtr)">
+ <summary>
+ The internal aggregate Step function callback, which wraps the raw context pointer and calls the virtual Step() method.
+ </summary>
+ <remarks>
+ This function takes care of doing the lookups and getting the important information put together to call the Step() function.
+ That includes pulling out the user's contextData and updating it after the call is made. We use a sorted list for this so
+ binary searches can be done to find the data.
+ </remarks>
+ <param name="context">A raw context pointer</param>
+ <param name="nArgs">Number of arguments passed in</param>
+ <param name="argsptr">A pointer to the array of arguments</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.FinalCallback(System.IntPtr)">
+ <summary>
+ An internal aggregate Final function callback, which wraps the context pointer and calls the virtual Final() method.
+ </summary>
+ <param name="context">A raw context pointer</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.Dispose(System.Boolean)">
+ <summary>
+ Placeholder for a user-defined disposal routine
+ </summary>
+ <param name="disposing">True if the object is being disposed explicitly</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.Dispose">
+ <summary>
+ Disposes of any active contextData variables that were not automatically cleaned up. Sometimes this can happen if
+ someone closes the connection while a DataReader is open.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.#cctor">
+ <summary>
+ Using reflection, enumerate all assemblies in the current appdomain looking for classes that
+ have a SQLiteFunctionAttribute attribute, and registering them accordingly.
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.RegisterFunction(System.Type)">
+ <summary>
+ Manual method of registering a function. The type must still have the SQLiteFunctionAttributes in order to work
+ properly, but this is a workaround for the Compact Framework where enumerating assemblies is not currently supported.
+ </summary>
+ <param name="typ">The type of the function to register</param>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunction.BindFunctions(System.Data.SQLite.SQLiteBase)">
+ <summary>
+ Called by SQLiteBase derived classes, this function binds all user-defined functions to a connection.
+ It is done this way so that all user-defined functions will access the database using the same encoding scheme
+ as the connection (UTF-8 or UTF-16).
+ </summary>
+ <remarks>
+ The wrapper functions that interop with SQLite will create a unique cookie value, which internally is a pointer to
+ all the wrapped callback functions. The interop function uses it to map CDecl callbacks to StdCall callbacks.
+ </remarks>
+ <param name="sqlbase">The base object on which the functions are to bind</param>
+ <returns>Returns an array of functions which the connection object should retain until the connection is closed.</returns>
+ </member>
+ <member name="P:System.Data.SQLite.SQLiteFunction.SQLiteConvert">
+ <summary>
+ Returns a reference to the underlying connection's SQLiteConvert class, which can be used to convert
+ strings and DateTime's into the current connection's encoding schema.
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteFunctionEx">
+ <summary>
+ Extends SQLiteFunction and allows an inherited class to obtain the collating sequence associated with a function call.
+ </summary>
+ <remarks>
+ User-defined functions can call the GetCollationSequence() method in this class and use it to compare strings and char arrays.
+ </remarks>
+ </member>
+ <member name="M:System.Data.SQLite.SQLiteFunctionEx.GetCollationSequence">
+ <summary>
+ Obtains the collating sequence in effect for the given function.
+ </summary>
+ <returns></returns>
+ </member>
+ <member name="T:System.Data.SQLite.FunctionType">
+ <summary>
+ The type of user-defined function to declare
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.FunctionType.Scalar">
+ <summary>
+ Scalar functions are designed to be called and return a result immediately. Examples include ABS(), Upper(), Lower(), etc.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.FunctionType.Aggregate">
+ <summary>
+ Aggregate functions are designed to accumulate data until the end of a call and then return a result gleaned from the accumulated data.
+ Examples include SUM(), COUNT(), AVG(), etc.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.FunctionType.Collation">
+ <summary>
+ Collation sequences are used to sort textual data in a custom manner, and appear in an ORDER BY clause. Typically text in an ORDER BY is
+ sorted using a straight case-insensitive comparison function. Custom collating sequences can be used to alter the behavior of text sorting
+ in a user-defined manner.
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteCallback">
+ <summary>
+ An internal callback delegate declaration.
+ </summary>
+ <param name="context">Raw context pointer for the user function</param>
+ <param name="nArgs">Count of arguments to the function</param>
+ <param name="argsptr">A pointer to the array of argument pointers</param>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteFinalCallback">
+ <summary>
+ An internal final callback delegate declaration.
+ </summary>
+ <param name="context">Raw context pointer for the user function</param>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteCollation">
+ <summary>
+ Internal callback delegate for implementing collation sequences
+ </summary>
+ <param name="puser">Not used</param>
+ <param name="len1">Length of the string pv1</param>
+ <param name="pv1">Pointer to the first string to compare</param>
+ <param name="len2">Length of the string pv2</param>
+ <param name="pv2">Pointer to the second string to compare</param>
+ <returns>Returns -1 if the first string is less than the second. 0 if they are equal, or 1 if the first string is greater
+ than the second.</returns>
+ </member>
+ <member name="T:System.Data.SQLite.CollationTypeEnum">
+ <summary>
+ The type of collating sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationTypeEnum.Binary">
+ <summary>
+ The built-in BINARY collating sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationTypeEnum.NoCase">
+ <summary>
+ The built-in NOCASE collating sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationTypeEnum.Reverse">
+ <summary>
+ The built-in REVERSE collating sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationTypeEnum.Custom">
+ <summary>
+ A custom user-defined collating sequence
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.CollationEncodingEnum">
+ <summary>
+ The encoding type the collation sequence uses
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationEncodingEnum.UTF8">
+ <summary>
+ The collation sequence is UTF8
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationEncodingEnum.UTF16LE">
+ <summary>
+ The collation sequence is UTF16 little-endian
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationEncodingEnum.UTF16BE">
+ <summary>
+ The collation sequence is UTF16 big-endian
+ </summary>
+ </member>
+ <member name="T:System.Data.SQLite.CollationSequence">
+ <summary>
+ A struct describing the collating sequence a function is executing in
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationSequence.Name">
+ <summary>
+ The name of the collating sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationSequence.Type">
+ <summary>
+ The type of collating sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationSequence.Encoding">
+ <summary>
+ The text encoding of the collation sequence
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.CollationSequence._func">
+ <summary>
+ Context of the function that requested the collating sequence
+ </summary>
+ </member>
+ <member name="M:System.Data.SQLite.CollationSequence.Compare(System.String,System.String)">
+ <summary>
+ Calls the base collating sequence to compare two strings
+ </summary>
+ <param name="s1">The first string to compare</param>
+ <param name="s2">The second string to compare</param>
+ <returns>-1 if s1 is less than s2, 0 if s1 is equal to s2, and 1 if s1 is greater than s2</returns>
+ </member>
+ <member name="M:System.Data.SQLite.CollationSequence.Compare(System.Char[],System.Char[])">
+ <summary>
+ Calls the base collating sequence to compare two character arrays
+ </summary>
+ <param name="c1">The first array to compare</param>
+ <param name="c2">The second array to compare</param>
+ <returns>-1 if c1 is less than c2, 0 if c1 is equal to c2, and 1 if c1 is greater than c2</returns>
+ </member>
+ <member name="T:System.Data.SQLite.SQLiteDataReader">
+ <summary>
+ SQLite implementation of DbDataReader.
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDataReader._command">
+ <summary>
+ Underlying command this reader is attached to
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDataReader._activeStatementIndex">
+ <summary>
+ Index of the current statement in the command being processed
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDataReader._activeStatement">
+ <summary>
+ Current statement being Read()
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDataReader._readingState">
+ <summary>
+ State of the current statement being processed.
+ -1 = First Step() executed, so the first Read() will be ignored
+ 0 = Actively reading
+ 1 = Finished reading
+ 2 = Non-row-returning statement, no records
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDataReader._rowsAffected">
+ <summary>
+ Number of records affected by the insert/update statements executed on the command
+ </summary>
+ </member>
+ <member name="F:System.Data.SQLite.SQLiteDataReader._fieldCount">
+ <summary>
[... 1974 lines stripped ...]