SQLUtilities Methods
The SQLUtilities type exposes the following members.
Methods
Name | Description | |
---|---|---|
addOrderBy |
adds order by sentence to SQL string.
|
|
AddTableToWhere(String, eWhereType) |
Adds the table to a where sentence.
|
|
AddTableToWhere(String, String, eWhereType) |
Adds the table to a where sentence.
|
|
AddTableToWhereSimple |
Adds the table to a where sentence (second implementation).
|
|
AddWhere |
Adds a where sentence to a SQL sentence.
|
|
appendOrderBy |
appends an order by to another one.
|
|
ArrayToDatatable(array<Object>[]()[][]) |
Converts an object array into a datatable
|
|
ArrayToDatatable(IList) | ||
BuildCount |
Builds a count sentence.
|
|
cloneSQLParams | ||
ConvertToSQLDate |
Converts a Date Object to a SQL date.
|
|
DataRowToList |
Converts a DataRow Object to a JSON Serializable List.
|
|
DataTableToList |
Converts a DataTable Object to a JSON Serializable List.
|
|
DataTableToTypedList<(Of <<'(T>)>>) |
Converts a DataTable Object to a JSON Serializable List.
|
|
DataTasetToList |
Converts a DataSet Object to a JSON Serializable List.
|
|
FormatField(Object, Byte, Boolean, Boolean) |
Formats the field depending on its TypeCode
|
|
FormatField(Type, Object, Byte, Boolean, Boolean) |
Formats the field depending on its TypeCode
|
|
FormatField(SqlDbType, Object, Boolean, Boolean) |
Formats the field depending on its SqlDbType
|
|
FormatField(DbType, Object, Boolean, Boolean) |
Formats the field.
|
|
FormatField(TypeCode, Object, Byte, Boolean, Boolean) |
Formats the field depending on its TypeCode
|
|
GenerateStreamFromString |
Generate a stream from text string
|
|
GetAlias |
Gets the alias for a field name in as SQL sentence.
|
|
GetDatePart |
Gets date part.
|
|
GetFrom |
Gets the Table name from SQL Sentence.
|
|
GetTableSchema | ||
JSONToDatatable | ||
ParseSQLValue |
Converts a .Net Object to a SQL object.
|
|
Permissions |
Checks for the permissions for running a process.
|
|
ProcessOrderBy(String%) |
Processes the order by sentence from a SQL sentence.
|
|
ProcessOrderBy(String%, String) |
Processes the order by from aSQL and returns the order by with the table name.
|
|
RemoveOrderBy |
Removes order by from a SQL sentence.
|
|
StructToWhere |
Converts a structure to a where sentence.
|
|
WhereToStruct |
Converts a where sentence to a structure.
|