📄 system.data.sqlite.xml
字号:
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.ColumnToType(System.Data.SQLite.SQLiteStatement,System.Int32)">
<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>
<returns>Returns a SQLiteType struct</returns>
</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.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.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.SQLiteCollation">
<summary>
Internal callback delegate for implementing collation sequences
</summary>
<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.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._interopCookie">
<summary>
Used internally to keep track of memory allocated for aggregate functions
</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._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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -