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.
|