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
Show file 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