Foodolini.Database.Sql.Sqlite Class Reference

An SqlBuilder for building sql statements for Sqlite. More...

Inherits Foodolini::Database::Sql::SqlStrategy.

Collaboration diagram for Foodolini.Database.Sql.Sqlite:
Collaboration graph

List of all members.

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.

Detailed Description

An SqlBuilder for building sql statements for Sqlite.

Definition at line 14 of file SqliteStrategy.cs.


Member Function Documentation

override string Foodolini.Database.Sql.Sqlite.AllQuery ( string  table  )  [virtual]
Returns:
An Sqlite specific query

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]
Returns:
An Sqlite specific delete query

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]
Parameters:
table A System.String
condition A System.String
Returns:
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

Parameters:
type Type to find affinity for
Returns:
Sqlite storage class

Definition at line 53 of file SqliteStrategy.cs.

override string Foodolini.Database.Sql.Sqlite.InsertQuery ( string  table,
ICollection< string >  parameters 
) [virtual]
Returns:
An Sqlite specific insert statement

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]
Returns:
An Sqlite specific paged query statement

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]
Returns:
An Sqlite specific where paged query

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.

Returns:
An sql statement for quering 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]
Returns:
An Sqlite specific update statement

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]
Returns:
An Sqlite specific where query

Implements Foodolini.Database.Sql.SqlStrategy.

Definition at line 123 of file SqliteStrategy.cs.


The documentation for this class was generated from the following file:

Foodolini 1.0.0 Documentation, generated with DoxyGen.