C# Class DataAccessFramework.MSSqlDataTool

An abstract generalization of the CreateCommand that can connect to an MS SqlServer database.

This has to be extended in a specific class that can provide logic for creating the connection.

This implementation implements the CreateXYZParameter functions and the DataTool function.

Inheritance: DataTool

Public Methods

Method	Description
CreateBinaryParameter ( string parameterName, byte value, int length ) : IDataParameter	Implements DataTool.CreateBinaryParameter(string,byte[],int?). Creates a database parameter for binary data.
CreateBoolParameter ( string parameterName, bool value ) : IDataParameter	Implements DataTool.CreateBoolParameter(string,bool). Creates a database parameter for a Boolean value.
CreateDateTimeParameter ( string parameterName, System.DateTime value ) : IDataParameter	Creates a database parameter for a datetime value
CreateDecimalParameter ( string parameterName, decimal value ) : IDataParameter	Creates database parameter for a decimal value.
CreateGuidParameter ( string parameterName, System.Guid value ) : IDataParameter	Creates database parameter for a GUID value.
CreateIntParameter ( string parameterName, int value ) : IDataParameter	Implements DataTool.CreateIntParameter(string,int?). Creates a database parameter for an integer value.
CreateLongParameter ( string parameterName, long value ) : IDataParameter
CreateMoneyParameter ( string parameterName, decimal value ) : IDataParameter	Creates a database parameter for a decimal value used for carrying monetary amount.
CreateStampParameter ( string parameterName, object value ) : IDataParameter	Creates a parameter for a timestamp field.
CreateStringParameter ( string parameterName, string value, int length ) : IDataParameter	Implements DataTool.CreateStringParameter. Creates a database parameter for a string value.

Method	Description
CreateCommand ( ) : IDbCommand	Implements DataTool.CreateCommand

Implements DataTool.CreateBinaryParameter(string,byte[],int?). Creates a database parameter for binary data.

public CreateBinaryParameter ( string parameterName, byte value, int length ) : IDataParameter
parameterName	string	/// The name of the parameter to create ///
value	byte	/// The value of the parameter. ///
length	int	/// The length of the parameter. If no value is passed /// a binary(MAX) parameter is created. ///
return	IDataParameter

Implements DataTool.CreateBoolParameter(string,bool). Creates a database parameter for a Boolean value.

public CreateBoolParameter ( string parameterName, bool value ) : IDataParameter
parameterName	string	/// The name of the parameter to create. ///
value	bool	/// The value for the parameter. ///
return	IDataParameter

Implements DataTool.CreateCommand

protected CreateCommand ( ) : IDbCommand
return	IDbCommand

Creates a database parameter for a datetime value

public CreateDateTimeParameter ( string parameterName, System.DateTime value ) : IDataParameter
parameterName	string	/// The name of the parameter. ///
value	System.DateTime	/// The value of the parameter ///
return	IDataParameter

Creates database parameter for a decimal value.

public CreateDecimalParameter ( string parameterName, decimal value ) : IDataParameter
parameterName	string	/// The name of the parameter. ///
value	decimal	/// The value of the parameter ///
return	IDataParameter

Creates database parameter for a GUID value.

public CreateGuidParameter ( string parameterName, System.Guid value ) : IDataParameter
parameterName	string	/// The name of the parameter. ///
value	System.Guid	/// The value of the parameter ///
return	IDataParameter

Implements DataTool.CreateIntParameter(string,int?). Creates a database parameter for an integer value.

public CreateIntParameter ( string parameterName, int value ) : IDataParameter
parameterName	string	/// The name of the parameter to create. ///
value	int	/// The value for the parameter. ///
return	IDataParameter

public CreateLongParameter ( string parameterName, long value ) : IDataParameter
parameterName	string
value	long
return	IDataParameter

Creates a database parameter for a decimal value used for carrying monetary amount.

public CreateMoneyParameter ( string parameterName, decimal value ) : IDataParameter
parameterName	string	/// The name of the parameter. ///
value	decimal	/// The value of the parameter ///
return	IDataParameter

Creates a parameter for a timestamp field.

public CreateStampParameter ( string parameterName, object value ) : IDataParameter
parameterName	string
value	object
return	IDataParameter

Implements DataTool.CreateStringParameter. Creates a database parameter for a string value.

public CreateStringParameter ( string parameterName, string value, int length ) : IDataParameter
parameterName	string	/// The name of the parameter to create. ///
value	string	/// The value of the parameter ///
length	int	/// The max length of the parameter. If no value is passed, /// a nvarchar(MAX) parameter is created. ///
return	IDataParameter