Doc.md

Dysnomia.Common.SQL

Contents

• DataTableHelper
  • CreateDataTableFromObject``1(myObject)
• DbHelper
  • ExecStoredProcedure(connection,procName,parameters,transaction)
  • ExecuteNonQuery(connection,sqlStatement,parameters,transaction)
  • ExecuteQuery(connection,sqlStatement,parameters,transaction)
• DbNullHelper
  • DbNullOrString(val)
  • DbNullOrValue(val)
• DbReaderMapper
  • GetBoolean()
  • GetDateTime()
  • GetDecimal()
  • GetDouble()
  • GetGuid()
  • GetGuid()
  • GetGuid()
  • GetInt()
  • GetInt16()
  • GetInt32()
  • GetInt64()
  • GetLong()
  • GetNullableBoolean()
  • GetNullableDateTime()
  • GetNullableDecimal()
  • GetNullableDouble()
  • GetNullableGuid()
  • GetNullableInt()
  • GetNullableInt16()
  • GetNullableInt32()
  • GetNullableInt64()
  • GetNullableLong()
  • GetNullableShort()
  • GetNullableUInt()
  • GetNullableUInt16()
  • GetNullableUInt32()
  • GetNullableUInt64()
  • GetNullableULong()
  • GetNullableUShort()
  • GetShort()
  • GetString()
  • GetUInt()
  • GetUInt16()
  • GetUInt32()
  • GetUInt64()
  • GetULong()
  • GetUShort()

DataTableHelper type

Namespace

Dysnomia.Common.SQL

CreateDataTableFromObject``1(myObject) method

Summary

Generates a datatable from an object

Returns

Parameters

Name	Type	Description
myObject	``0

Generic Types

Name	Description
T	Any type

DbHelper type

Namespace

Dysnomia.Common.SQL

ExecStoredProcedure(connection,procName,parameters,transaction) method

Summary

Execute SQL stored procedure with reader as a result

Returns

Parameters

Name	Type	Description
connection	System.Data.IDbConnection	Database connection
procName	System.String	Procedure to execute
parameters	System.Collections.Generic.Dictionary{System.String,System.Object}	Statement parameters
transaction	System.Data.IDbTransaction	(Optional) Transaction this statement should be in

ExecuteNonQuery(connection,sqlStatement,parameters,transaction) method

Summary

Execute SQL query without any result returned

Returns

Parameters

Name	Type	Description
connection	System.Data.IDbConnection	Database connection
sqlStatement	System.String	Statement to execute
parameters	System.Collections.Generic.Dictionary{System.String,System.Object}	Statement parameters
transaction	System.Data.IDbTransaction	(Optional) Transaction this statement should be in

ExecuteQuery(connection,sqlStatement,parameters,transaction) method

Summary

Execute SQL query with reader as a result

Returns

Parameters

Name	Type	Description
connection	System.Data.IDbConnection	Database connection
sqlStatement	System.String	Statement to execute
parameters	System.Collections.Generic.Dictionary{System.String,System.Object}	Statement parameters
transaction	System.Data.IDbTransaction	(Optional) Transaction this statement should be in

DbNullHelper type

Namespace

Dysnomia.Common.SQL

DbNullOrString(val) method

Summary

Return string or DbNull if the string is null or empty

Returns

Parameters

Name	Type	Description
val	System.String

DbNullOrValue(val) method

Summary

Return value or DbNull if the value is null

Returns

Parameters

Name	Type	Description
val	System.Object

DbReaderMapper type

Namespace

Dysnomia.Common.SQL

GetBoolean() method

Parameters

This method has no parameters.

GetDateTime() method

Parameters

This method has no parameters.

GetDecimal() method

Parameters

This method has no parameters.

GetDouble() method

Parameters

This method has no parameters.

GetGuid() method

Parameters

This method has no parameters.

GetGuid() method

Parameters

This method has no parameters.

GetGuid() method

Parameters

This method has no parameters.

GetInt() method

Parameters

This method has no parameters.

GetInt16() method

Parameters

This method has no parameters.

GetInt32() method

Parameters

This method has no parameters.

GetInt64() method

Parameters

This method has no parameters.

GetLong() method

Parameters

This method has no parameters.

GetNullableBoolean() method

Parameters

This method has no parameters.

GetNullableDateTime() method

Parameters

This method has no parameters.

GetNullableDecimal() method

Parameters

This method has no parameters.

GetNullableDouble() method

Parameters

This method has no parameters.

GetNullableGuid() method

Parameters

This method has no parameters.

GetNullableInt() method

Parameters

This method has no parameters.

GetNullableInt16() method

Parameters

This method has no parameters.

GetNullableInt32() method

Parameters

This method has no parameters.

GetNullableInt64() method

Parameters

This method has no parameters.

GetNullableLong() method

Parameters

This method has no parameters.

GetNullableShort() method

Parameters

This method has no parameters.

GetNullableUInt() method

Parameters

This method has no parameters.

GetNullableUInt16() method

Parameters

This method has no parameters.

GetNullableUInt32() method

Parameters

This method has no parameters.

GetNullableUInt64() method

Parameters

This method has no parameters.

GetNullableULong() method

Parameters

This method has no parameters.

GetNullableUShort() method

Parameters

This method has no parameters.

GetShort() method

Parameters

This method has no parameters.

GetString() method

Parameters

This method has no parameters.

GetUInt() method

Parameters

This method has no parameters.

GetUInt16() method

Parameters

This method has no parameters.

GetUInt32() method

Parameters

This method has no parameters.

GetUInt64() method

Parameters

This method has no parameters.

GetULong() method

Parameters

This method has no parameters.

GetUShort() method

Parameters

This method has no parameters.