SqlUtility Class

Provides various utility methods for use with SQL databases.

Inheritance Hierarchy

Namespace: Galactic.Sql
Assembly: Galactic.Sql (in Galactic.Sql.dll) Version: 1.3.0.499 (1.3.0.499)

Syntax

public abstract class SqlUtility

Public MustInherit Class SqlUtility

public ref class SqlUtility abstract

[<AbstractClassAttribute>]
type SqlUtility =  class end

The SqlUtility type exposes the following members.

Constructors

	Name	Description
	SqlUtility	Initializes a new instance of the SqlUtility class

Properties

	Name	Description
	MAX_NCHAR_LENGTH	The maximum length of a NCHAR field in the database.
	MAX_NVARCHAR_LENGTH	The maximum length of a NVARCHAR field in the database.
	MAX_VARCHAR_LENGTH	The maximum length of a VARCHAR field in the database.

Methods

	Name	Description
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	ExecuteNonQuery	Executes the non-query SQL command provided.
	ExecuteNonQuerySQLFile	Executes the SQL statements in a file given its path, and a connection string to the database.
	ExecuteQuery	Executes the SQL query provided.
	ExecuteQuerySQLFile	Executes the SQL query in a file given its path, and a connection string to the database.
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	LogException	Logs an exception to the event log.
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	RunScript	Runs SQL script files given their path.
	ToString	Returns a string that represents the current object. (Inherited from Object.)