C# Class GreenQloud.Persistence.SQLite.SQLiteDatabase

Afficher le fichier Open project: greenqloud/qloudsync

Méthodes publiques

Méthode Description
CreateDataBase ( ) : void
ExecuteNonQuery ( string sql ) : int

Allows the programmer to interact with the database for purposes other than a query.

ExecuteNonQuery ( string sql, bool returnId ) : int
ExecuteScalar ( string sql ) : string

Allows the programmer to retrieve single items from the DB.

GetDataTable ( string sql ) : DataTable

Allows the programmer to run a query against the Database.

Instance ( ) : SQLiteDatabase

Private Methods

Méthode Description
SQLiteDatabase ( ) : Mono.Data.Sqlite

Method Details

CreateDataBase() public méthode

public CreateDataBase ( ) : void
Résultat void

ExecuteNonQuery() public méthode

Allows the programmer to interact with the database for purposes other than a query.
public ExecuteNonQuery ( string sql ) : int
sql string The SQL to be run.
Résultat int

ExecuteNonQuery() public méthode

public ExecuteNonQuery ( string sql, bool returnId ) : int
sql string
returnId bool
Résultat int

ExecuteScalar() public méthode

Allows the programmer to retrieve single items from the DB.
public ExecuteScalar ( string sql ) : string
sql string The query to run.
Résultat string

GetDataTable() public méthode

Allows the programmer to run a query against the Database.
public GetDataTable ( string sql ) : DataTable
sql string The SQL to run
Résultat System.Data.DataTable

Instance() public static méthode

public static Instance ( ) : SQLiteDatabase
Résultat SQLiteDatabase