MSSqlUtility Class

Provides various utility methods for use with Microsoft SQL databases.

Inheritance Hierarchy

SystemObject
Galactic.SqlSqlUtility
Galactic.Sql.MSSqlMSSqlUtility

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

Syntax

public class MSSqlUtility : SqlUtility

Public Class MSSqlUtility
	Inherits SqlUtility

public ref class MSSqlUtility : public SqlUtility

type MSSqlUtility =  
    class
        inherit SqlUtility
    end

The MSSqlUtility type exposes the following members.

Constructors

	Name	Description
	MSSqlUtility	Initializes a new instance of the MSSqlUtility class

Properties

	Name	Description
	MAX_NCHAR_LENGTH	The maximum length of a NCHAR field in the database. (Overrides SqlUtilityMAX_NCHAR_LENGTH.)
	MAX_NVARCHAR_LENGTH	The maximum length of a NVARCHAR field in the database. (Overrides SqlUtilityMAX_NVARCHAR_LENGTH.)
	MAX_VARCHAR_LENGTH	The maximum length of a VARCHAR field in the database. (Overrides SqlUtilityMAX_VARCHAR_LENGTH.)

Methods

	Name	Description
	BuildConnectionString	Builds a connection string.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	ExecuteNonQuery	Executes the non-query TSQL command provided. (Overrides SqlUtilityExecuteNonQuery(String, String, EventLog).)
	ExecuteNonQuerySQLFile	Executes the SQL statements in a file given its path, and a connection string to the database. (Inherited from SqlUtility.)
	ExecuteQuery	Executes the TSQL query provided. (Overrides SqlUtilityExecuteQuery(String, String, EventLog).)
	ExecuteQuerySQLFile	Executes the SQL query in a file given its path, and a connection string to the database. (Inherited from SqlUtility.)
	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. (Inherited from SqlUtility.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	RunScript	Runs SQL script files given their path. (Inherited from SqlUtility.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)