C# Class GreenQloud.Persistence.SQLite.SQLiteDatabase

Mostrar archivo Open project: greenqloud/qloudsync

Public Methods

Method 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

Method Description
SQLiteDatabase ( ) : Mono.Data.Sqlite

Method Details

CreateDataBase() public method

public CreateDataBase ( ) : void
return void

ExecuteNonQuery() public method

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.
return int

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sql, bool returnId ) : int
sql string
returnId bool
return int

ExecuteScalar() public method

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

GetDataTable() public method

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

Instance() public static method

public static Instance ( ) : SQLiteDatabase
return SQLiteDatabase