Click or drag to resize

DataUtils Methods

The DataUtils type exposes the following members.

Methods
  NameDescription
Public methodStatic memberConvertToSqlDateTime
Converts a DateTime into a SqlDateTime
Public methodStatic memberCreateConnectionString
This method will create connection string based on every possibility of collector variables
Public methodStatic memberCreateIdListTempTable
Creates a temporary db table with one integer column for holding ids.
Public methodStatic memberExecuteNonQuery
Public methodStatic memberExecuteReader
Public methodStatic memberExecuteScalar
Public methodStatic memberGetDatabaseCollation
Returns the collation setting of the database
Public methodStatic memberGetDatabaseName
Use this method to extract database name (in uppercase) from the sql connection string.
Public methodStatic memberGetGuids
Returns collection of Guids. The value must be in the ordinal 0 of the cursor
Public methodStatic memberGetIntFieldList
Public methodStatic memberGetTransactionCount
Public methodStatic memberPopulateTempIdTable
Obsolete: Use ControllerBase.PopulateTempTable(T)(string, IEnumerable(T), TempTableOptions) instead.
Public methodStatic memberPopulateTempTableT
Creates a temporary db table with a single column and populates it with values.
Public methodStatic memberSetCommandTimeout
Top
Extension Methods
  NameDescription
Public Extension MethodToBool
Converts object to boolean.
(Defined by ObjectExtensions.)
Public Extension MethodToDateTime
Converts object to DateTime.
(Defined by ObjectExtensions.)
Public Extension MethodToInt
Converts object to integer.
(Defined by ObjectExtensions.)
Top
See Also