C# Class DAL.SQLiteDatabase

Exibir arquivo Open project: siracoj/signtolearn Class Usage Examples

Public Methods

Method	Description
ClearDB ( ) : bool
ClearTable ( String table ) : bool
Delete ( String tableName, String where ) : bool
ExecuteNonQuery ( string sql ) : int
ExecuteScalar ( string sql ) : string
GetDataTable ( string sql ) : DataTable
Insert ( String tableName, String>.Dictionary data ) : bool
SQLiteDatabase ( ) : System
Update ( String tableName, String>.Dictionary data, String where ) : bool

Method Details

ClearDB() public method

public ClearDB ( ) : bool
return	bool

ClearTable() public method

public ClearTable ( String table ) : bool
table	String
return	bool

Delete() public method

public Delete ( String tableName, String where ) : bool
tableName	String
where	String
return	bool

ExecuteNonQuery() public method

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

ExecuteScalar() public method

public ExecuteScalar ( string sql ) : string
sql	string
return	string

GetDataTable() public method

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

Insert() public method

public Insert ( String tableName, String>.Dictionary data ) : bool
tableName	String
data	String>.Dictionary
return	bool

SQLiteDatabase() public method

public SQLiteDatabase ( ) : System
return	System

Update() public method

public Update ( String tableName, String>.Dictionary data, String where ) : bool
tableName	String
data	String>.Dictionary
where	String
return	bool