C# Class RPS.DBConnector

Show file Open project: marijnkampf/Random-Photo-Screensaver Class Usage Examples

Public Properties

Property	Type	Description
connection	System.Data.SQLite.SQLiteConnection

Public Methods

Method	Description
Close ( ) : void
DBConnector ( string filename, DBTableDefinition tableDefinition ) : System
DBConnector ( string filename, DBTableDefinition tableDefinition, bool keepInMemory ) : System
ExecuteNonQuery ( string query ) : SQLiteCommand
ExecuteReader ( string query ) : SQLiteDataReader
ToReadableString ( SQLiteCommand command ) : string
executeReaderFirstDataRow ( SQLiteCommand command ) : DataRow
saveDBToFile ( ) : void

Protected Methods

Method	Description
loadDBFromFile ( ) : void
openCreateFileDB ( ) : SQLiteConnection
openCreateFileDB ( string filename ) : SQLiteConnection

Method Details

Close() public method

public Close ( ) : void
return	void

DBConnector() public method

public DBConnector ( string filename, DBTableDefinition tableDefinition ) : System
filename	string
tableDefinition	DBTableDefinition
return	System

DBConnector() public method

public DBConnector ( string filename, DBTableDefinition tableDefinition, bool keepInMemory ) : System
filename	string
tableDefinition	DBTableDefinition
keepInMemory	bool
return	System

ExecuteNonQuery() public method

public ExecuteNonQuery ( string query ) : SQLiteCommand
query	string
return	System.Data.SQLite.SQLiteCommand

ExecuteReader() public method

public ExecuteReader ( string query ) : SQLiteDataReader
query	string
return	System.Data.SQLite.SQLiteDataReader

ToReadableString() public static method

public static ToReadableString ( SQLiteCommand command ) : string
command	System.Data.SQLite.SQLiteCommand
return	string

executeReaderFirstDataRow() public static method

public static executeReaderFirstDataRow ( SQLiteCommand command ) : DataRow
command	System.Data.SQLite.SQLiteCommand
return	System.Data.DataRow

loadDBFromFile() protected method

protected loadDBFromFile ( ) : void
return	void

openCreateFileDB() protected method

protected openCreateFileDB ( ) : SQLiteConnection
return	System.Data.SQLite.SQLiteConnection

openCreateFileDB() protected method

protected openCreateFileDB ( string filename ) : SQLiteConnection
filename	string
return	System.Data.SQLite.SQLiteConnection

saveDBToFile() public method

public saveDBToFile ( ) : void
return	void

Property Details

connection public property

public SQLiteConnection,System.Data.SQLite connection
return	System.Data.SQLite.SQLiteConnection