C# 클래스 Nagru___Manga_Organizer.SQL.SQLBase

Holds the connection object and provides the 'base' functionality of the SQL implementation

상속: IDisposable

파일 보기 프로젝트 열기: Nagru/Manga-Organizer

Private Properties

프로퍼티	타입	설명
BackupDB	void
BeginTransaction	int
Cleanse	string
Close	void
Connect	void
CreateDatabase	void
EndTransaction	int
ExecuteNonQuery	int
ExecuteQuery	System.Data.DataTable
HandledDisconnect	bool
NewParameter	System.Data.SQLite.SQLiteParameter
SQLBase	System
UpdateVersion	void

공개 메소드들

메소드	설명
Dispose ( ) : void	Public implementation of Dispose

보호된 메소드들

메소드	설명
Dispose ( bool Disposing ) : void	Protected implementation of Dispose

비공개 메소드들

메소드	설명
BackupDB ( ) : void	Creates a backup of the database
BeginTransaction ( bool SetGlobal = false ) : int	Begins a transaction. NOTE: SQLite ONLY SUPPORTS ONE TRANSACTION AT A TIME
Cleanse ( string sRaw ) : string	Removes SQl characters from raw strings. Should be removed at some point in favor of parameters.
Close ( ) : void	Closes the connection to the database
Connect ( ) : void	Establishes a connection with the database or, if one is not found, create a new instance
CreateDatabase ( ) : void	Creates the tables and triggers in the new DB
EndTransaction ( bool Commit = true, bool EndGlobal = false ) : int	Ends the current transaction.
ExecuteNonQuery ( string CommandText ) : int	Wrapper around SQLite's ExecuteNonQuery for convenience
ExecuteQuery ( string CommandText ) : DataTable	Wrapper around SQLite's ExecuteQuery for convenience
HandledDisconnect ( ) : bool	Displays an error if the connection is lost. Used to wrap the base access functions to prevent possible hard errors.
NewParameter ( string ParameterName, DbType dbType, object value ) : SQLiteParameter	Wrapper around SQLiteParameter for convenience
SQLBase ( ) : System	Establish a DB connection when instantiated
UpdateVersion ( ) : void	Check if there are updates to the DB, and if so deploy them

메소드 상세

Dispose() 공개 메소드

Public implementation of Dispose

public Dispose ( ) : void
리턴	void

Dispose() 보호된 메소드

Protected implementation of Dispose

protected Dispose ( bool Disposing ) : void
Disposing	bool	Whether we are calling the method from the Dispose override
리턴	void