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
Afficher le fichier Open project: kzemek/FileScanner

Méthodes publiques

Méthode 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 méthode

public ExecuteNonQuery ( string sqlQuery ) : int
sqlQuery string
Résultat int

ExecuteScalar() public méthode

public ExecuteScalar ( string sqlQuery ) : string
sqlQuery string
Résultat string

GetDataTable() public méthode

public GetDataTable ( string sqlQuery ) : DataTable
sqlQuery string
Résultat System.Data.DataTable

Insert() public méthode

public Insert ( String tableName, String>.Dictionary dataSet ) : void
tableName String
dataSet String>.Dictionary
Résultat void

SqLiteDatabase() public méthode

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).
Résultat System