C# Class FileScanner.PersistanceManager.SqLiteDatabase

Contains methods for interacting with an SQLite database. Based on: http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/

Inheritance: ISQLDatabase

显示文件 Open project: kzemek/FileScanner

Public Methods

Method	Description
ExecuteNonQuery ( string sqlQuery ) : int
ExecuteScalar ( string sqlQuery ) : string
GetDataTable ( string sqlQuery ) : DataTable
Insert ( String tableName, String>.Dictionary dataSet ) : void
SqLiteDatabase ( string databaseFileName, string databaseStructureFileName ) : System	Creates a new SqLiteDatabase object and associates it with database file of given name. If the database file doesn't exist, creates an empty database under the given file name according to the database structure contained in the second file.

Method Details

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sqlQuery ) : int
sqlQuery	string
return	int

ExecuteScalar() public method

public ExecuteScalar ( string sqlQuery ) : string
sqlQuery	string
return	string

GetDataTable() public method

public GetDataTable ( string sqlQuery ) : DataTable
sqlQuery	string
return	System.Data.DataTable

Insert() public method

public Insert ( String tableName, String>.Dictionary dataSet ) : void
tableName	String
dataSet	String>.Dictionary
return	void

SqLiteDatabase() public method

Creates a new SqLiteDatabase object and associates it with database file of given name. If the database file doesn't exist, creates an empty database under the given file name according to the database structure contained in the second file.

public SqLiteDatabase ( string databaseFileName, string databaseStructureFileName ) : System
databaseFileName	string	Name of the file containing the database.
databaseStructureFileName	string	Name of the file containing the database structure (CREATE statements).
return	System