SQL - Extended  1.0.0
Pi-Con: Small utilities makes the difference
Classes | Enumerations
SQLite Namespace Reference

Classes

class  AsyncTableQuery
 Query to an asynchronous database connection. More...
 
class  AutoIncrementAttribute
 Attribute for the autoincremnet option in the Database / Table / Column More...
 
class  BaseTableQuery
 Abstract class for Ordering on columnName More...
 
class  CollationAttribute
 Select the collating sequence to use on a column. "BINARY", "NOCASE", and "RTRIM" are supported. "BINARY" is the default. More...
 
class  ColumnAttribute
 Attribute to specify another name to the column More...
 
class  CreateTablesResult
 The results in a Dictionary of multiple table creations More...
 
class  EnumCache
 Caching information of a type / object
 
class  EnumCacheInfo
 Class to store the information of a cacheitem (EnumCache) More...
 
class  IgnoreAttribute
 Attribute to ingnore adding to the database More...
 
class  IndexedAttribute
 Attribute to create a Index in the database / table More...
 
class  MaxLengthAttribute
 Attribute to limit the length of the string column More...
 
class  NotifyTableChangedEventArgs
 Arguments for the Notification Event More...
 
class  NotNullAttribute
 Attribute for a column not null in the database More...
 
class  NotNullConstraintViolationException
 check for a violation of the constraints in the table. More...
 
class  Orm
 The basic ORM class from SQLite-Net, with added code
 
class  PreparedSqlLiteInsertCommand
 Since the insert never changed, we only need to prepare once. More...
 
class  PreserveAttribute
 Attribute to Preserve the connection. More...
 
class  SQLite3
 The SQLite-Net 3
 
class  SQLiteAsyncConnection
 A pooled asynchronous connection to a SQLite database. More...
 
class  SQLiteCommand
 SQLite basic commands with bindings More...
 
class  SQLiteConnection
 The basic SQLiteConnection class from SQLite-Net, with added code. More...
 
class  SQLiteConnectionPool
 
class  SQLiteConnectionString
 Represents a parsed connection string. More...
 
class  SQLiteConnectionWithLock
 This is a normal connection except it contains a Lock method that can be used to serialize access to the database in lieu of using the sqlite's FullMutex support. More...
 
class  SQLiteException
 Exception, error results More...
 
class  StoreAsTextAttribute
 Attribute to to store the Enum as Text. More...
 
class  TableAttribute
 Attribute to set some table options More...
 
class  TableMapping
 The basic TableMapping class from SQLite-Net, with added code More...
 
class  TableQuery
 SQLite-Net queries op one table, not recursive. The function will be converted and exected to a SQL command after the .ToList() More...
 
class  UniqueIndexAttribute
 Unique attribute to set the column value to unique And adds a index to this Column More...
 

Enumerations

enum  Collations { None, RTRIM, BINARY, NOCASE }
 The collating sequence to use on a column. More...
 
enum  CreateFlags {
  CreateFlags.None = 0x000, CreateFlags.ImplicitPK = 0x001, CreateFlags.ImplicitIndex = 0x002, CreateFlags.AllImplicit = 0x003,
  CreateFlags.AutoIncPK = 0x004, CreateFlags.FullTextSearch3 = 0x100, CreateFlags.FullTextSearch4 = 0x200
}
 Flags for Primary Keys when the table is Created. More...
 
enum  CreateTableResult { Created, Migrated }
 Enum to specify if the Table has to be: More...
 
enum  NotifyTableChangedAction { Insert, Update, Delete }
 Type action of the notification More...
 
enum  SQLiteOpenFlags {
  ReadOnly = 1, ReadWrite = 2, Create = 4, NoMutex = 0x8000,
  FullMutex = 0x10000, SharedCache = 0x20000, PrivateCache = 0x40000, ProtectionComplete = 0x00100000,
  ProtectionCompleteUnlessOpen = 0x00200000, ProtectionCompleteUntilFirstUserAuthentication = 0x00300000, ProtectionNone = 0x00400000
}
 Flags to specify the connection type More...
 

Enumeration Type Documentation

◆ Collations

enum SQLite.Collations
strong

The collating sequence to use on a column.

◆ CreateFlags

enum SQLite.CreateFlags
strong

Flags for Primary Keys when the table is Created.

Enumerator
None 

Use the default creation options

ImplicitPK 

Create a primary key index for a property called 'Id' (case-insensitive). This avoids the need for the [PrimaryKey] attribute.

ImplicitIndex 

Create indices for properties ending in 'Id' (case-insensitive).

AllImplicit 

Create a primary key for a property called 'Id' and create an indices for properties ending in 'Id' (case-insensitive).

AutoIncPK 

Force the primary key property to be auto incrementing. This avoids the need for the [AutoIncrement] attribute. The primary key property on the class should have type int or long.

FullTextSearch3 

Create virtual table using FTS3

FullTextSearch4 

Create virtual table using FTS4

◆ CreateTableResult

Enum to specify if the Table has to be:

  • Cretaed
  • Migrated

◆ NotifyTableChangedAction

Type action of the notification

◆ SQLiteOpenFlags

Flags to specify the connection type