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
파일 보기 프로젝트 열기: kzemek/FileScanner

공개 메소드들

메소드 설명
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