C# Класс 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/

Наследование: ISQLDatabase

Показать файл Открыть проект

Открытые методы

Метод	Описание
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.

Описание методов

ExecuteNonQuery() публичный Метод

public ExecuteNonQuery ( string sqlQuery ) : int
sqlQuery	string
Результат	int

ExecuteScalar() публичный Метод

public ExecuteScalar ( string sqlQuery ) : string
sqlQuery	string
Результат	string

GetDataTable() публичный Метод

public GetDataTable ( string sqlQuery ) : DataTable
sqlQuery	string
Результат	System.Data.DataTable

Insert() публичный Метод

public Insert ( String tableName, String>.Dictionary dataSet ) : void
tableName	String
dataSet	String>.Dictionary
Результат	void

SqLiteDatabase() публичный Метод

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).
Результат	System