SQLHandler Class

Provides a singleton handler for SQL queries with SQL server.

Inheritance Hierarchy

SystemObject
CADSharpTools.DatabaseSQLHandler

Namespace: CADSharpTools.Database
Assembly: CADSharpTools.PDM (in CADSharpTools.PDM.dll) Version: 1.4.16.0 (1.4.16)

Syntax

public class SQLHandler

Public Class SQLHandler

The SQLHandler type exposes the following members.

Properties

	Name	Description
	Connection	Singleton's SqlConnection object.
	ConnectionString	Singleton's connection string.

Methods

	Name	Description
	Close	Closes the connection. Connection can be reopened.
	Dispose	Closes and disposes of the connection.
	Open	Opens a connection to the database.
	PerformSQLTransaction(FuncSqlConnection, MethodReturnBoolean)	Performs a SQL transaction.
	PerformSQLTransactionT(FuncSqlConnection, MethodReturnT)	Performs a SQL transaction. Generic variation.
	SetConnectionString	Sets ConnectionString property.

Remarks

To use the SQLHandler class:

Set the ConnectionString property.
Invoke Open to connect to the database.
Perform your SQL transaction by invoking PerformSQLTransaction(FuncSqlConnection, MethodReturnBoolean) if you don't require a return or PerformSQLTransactionT(FuncSqlConnection, MethodReturnT) if you require a return value.
Close connection when done. You may reinvoke Open to reopen the connection.
Dispose when application is exiting.