An SqlBuilder for building sql statements for Sqlite. More...
Inherits Foodolini::Database::Sql::SqlStrategy.
Public Member Functions | |
override string | TableQuery () |
Builds a query that lists all tables. | |
override string | CreateTableQuery (string table, IDictionary< string, Type > columns, string primaryKey) |
Sqlite specific create table statement. | |
override string | InsertQuery (string table, ICollection< string > parameters) |
override string | UpdateQuery (string table, ICollection< string > parameters, string identifier) |
override string | WhereQuery (string table, string condition) |
override string | PagedWhereQuery (string table, string condition, int page, int pageSize) |
override string | AllQuery (string table) |
override string | PagedQuery (string table, int page, int pageSize) |
override string | DeleteQuery (string table, string identifier) |
override string | DeleteWhereQuery (string table, string condition) |
Private Member Functions | |
string | GetTypeAffinity (Type type) |
Gets the affinity of a column using it's .Net type. |
An SqlBuilder for building sql statements for Sqlite.
Definition at line 14 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.AllQuery | ( | string | table | ) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 141 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.CreateTableQuery | ( | string | table, | |
IDictionary< string, Type > | columns, | |||
string | primaryKey | |||
) | [virtual] |
Sqlite specific create table statement.
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 30 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.DeleteQuery | ( | string | table, | |
string | identifier | |||
) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 159 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.DeleteWhereQuery | ( | string | table, | |
string | condition | |||
) | [virtual] |
table | A System.String | |
condition | A System.String |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 177 of file SqliteStrategy.cs.
string Foodolini.Database.Sql.Sqlite.GetTypeAffinity | ( | Type | type | ) | [private] |
Gets the affinity of a column using it's .Net type.
For more information on column affinity, see http://www.sqlite.org/datatype3.html
type | Type to find affinity for |
Definition at line 53 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.InsertQuery | ( | string | table, | |
ICollection< string > | parameters | |||
) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 92 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.PagedQuery | ( | string | table, | |
int | page, | |||
int | pageSize | |||
) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 150 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.PagedWhereQuery | ( | string | table, | |
string | condition, | |||
int | page, | |||
int | pageSize | |||
) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 132 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.TableQuery | ( | ) | [virtual] |
Builds a query that lists all tables.
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 23 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.UpdateQuery | ( | string | table, | |
ICollection< string > | parameters, | |||
string | identifier | |||
) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 109 of file SqliteStrategy.cs.
override string Foodolini.Database.Sql.Sqlite.WhereQuery | ( | string | table, | |
string | condition | |||
) | [virtual] |
Implements Foodolini.Database.Sql.SqlStrategy.
Definition at line 123 of file SqliteStrategy.cs.