Data Class

Class for methods for managing System.Data.

Definition

Namespace: Aliquo.Core
Assembly: Aliquo.Core (in Aliquo.Core.dll) Version: 5.0.9179.22651
C#
public class Data
Inheritance
Object    Data

Constructors

DataInitializes a new instance of the Data class

Methods

ChangeColumnMappingFromHiddenToElement(DataSet) Change columns mapped as hidden (Hidden) to elements (Element).
ChangeColumnMappingFromHiddenToElement(DataTable) Change columns mapped as hidden (Hidden) to element (Element).
ChangeColumnMappingWithValueChanges(DataRow, DataRowVersion) Change columns mapped as hidden (Hidden) to element (Element) if any value of the column changes.
ChangeColumnMappingWithValueChanges(DataTable, DataRowVersion) Change columns mapped as hidden (Hidden) to element (Element) if any value of the column changes.
ContainsField Evaluates whether the model list DataField contains a model that matches the given name.
CopyRow(DataRow) Create a copy of the row structure and data.
CopyRow(DataRow, DataRow, String) Transfer the data from the source row to the destination row of the indicated fields.
CopyRow(DataRow, DataRow, Boolean, Boolean, String) Transfer the data from the source row to the destination row allowing columns to be excluded.
CopyRowID Copies a row of data using a new ID (negative ID) for the new row.
CopyRows(Data, DataTable) Copy the content of the data source to the destination table.
CopyRows(ListData, DataSet) Copies the content of the data source to the corresponding target tables.
CopyRowsID Copies the content of the source table to the destination table using a new ID (negative ID) for the new row.
CopyTable Create a copy of the table structure and data.
CreateRowID(DataTable, String) Creates a new data row with a new non-existing ID (negative ID).
CreateRowID(DataSet, String, String) Creates a new data row with a new non-existing ID (negative ID).
DuplicateRowID Duplicates a row of data using a new ID (negative ID) for the new row.
EmptyToDBNull Converts to DBNull when the indicated value is Empty.
Exist Indicates if the datarow contains data.
ExistField Indicates whether a field exists in a datarow by combining the table and the field (field or table.field).
ExistRows(DataTable) Indicates if there are rows in the indicated table.
ExistRows(DataView) Indicates if there are rows in the indicated table.
ExistRows(DataSet, Int32) Indicates if there are rows in the indicated table.
ExistRows(DataSet, String) Indicates if there are rows in the indicated table.
ExistTable(DataSet, Int32) Indicates whether the dataset contains the indicated table.
ExistTable(DataSet, String) Indicates whether the dataset contains the indicated table.
ExistTables Indicates if the dataset contains tables.
FindField Searches a list of the model DataField for a model with the given name and returns that model.
FindRow(DataTable, String, Object, String, String) Searches a row of data based on the indicated parameters.
FindRow(DataSet, Int32, String, Object, String, String) Searches a row of data based on the indicated parameters
FindRow(DataSet, String, String, Object, String, String) Searches a row of data based on the indicated parameters.
GetValue(DataRow, String, Object) Allows obtain the value of a field from a datarow.
GetValue(DataRow, String, String, Object) Allows obtain the value of a datarow by combining the table and the field (field or table.field).
HasChanges(DataRow, DataRow, String) Compares if there are changes between two DataRow.
HasChanges(DataRow, DataRowVersion, String) Compares if there are changes between two DataRow.
HasChanges(DataRow, DataRow, String, String) Compares if there are changes between two DataRow.
HasChanges(DataRow, DataRowVersion, String, String) Compares if there are changes between the DataRow and a version of it.
HasChanges(DataTable, DataTable, String, String) Compares whether two DataTable changes exist.
HasChanges(DataTable, DataView, String, String) Compare if there are changes in a DataTable and a DataView.
NewRowID Gets a new ID (negative ID) of non-existing data row.
NothingToDBNull Converts to DBNull when the given value is .
RowToData Convert a DataRow to a Data.
SetDateTimeMode(DataSet, DataSetDateTime) Sets the datatimemode of the datetime columns.
SetDateTimeMode(DataTable, DataSetDateTime) Sets the datatimemode of the datetime columns.
SetDateTimeModeUnspecified(DataSet) Set the datatimemode of the datetime columns to Unspecified to prevent time offset.
SetDateTimeModeUnspecified(DataTable) Set the datatimemode of the datetime columns to Unspecified to avoid time offset.
SetValue Assigns a value to a field based on the column type.
SetValues Assigns the value of some fields to the corresponding column of the DataRow.
SetValuesFromModel Passes values from a model to a DataRow using property attributes.
SetValuesToModel Passes the values of the DataRow to the model using property attributes.
StringFormat(String, DataRow, CultureInfo) Converts a format string with field names to a string with values
StringFormat(String, String, Object, CultureInfo) Converts a format string by finding the given field name and converting the value.
StringFormatSQL(String, DataRow) Converts a format string with field names to a string with SQL values.
StringFormatSQL(String, String, Object) Converts a format string with field names to a string with SQL values.
TablesToData Converts the content of the tables into a list of Data.
TableToData Converts the content of the tables into a list of Data.
ToDataViewBoolean Convert a value to a string with a boolean for DataView.
ToDataViewDataType Converts a value to a text string for DataView based on data type.
ToDataViewDate Converts a value to a date string for the DataView.
ToDataViewDateTime Converts a value to a datetime string for DataView.
ToDataViewDateTimeOffset Converts a value to a date, time, and time offset string for DataView.
ToDataViewNumber Convert a value to a string with a number for DataView.
ToDataViewString Convert a value to a text string for DataView.
ToDataViewTime Converts a value to a time string for DataView.
ToSQLBoolean Convert a value to a string with a boolean for SQL.
ToSQLDataType Convert a value to a text string for SQL based on data type.
ToSQLDate Converts a value to a date string for SQL.
ToSQLDateTime Converts a value to a datetime string for SQL.
ToSQLDateTimeOffset Converts a value to a date, time, and time offset string for SQL.
ToSQLNumber Convert a value to a string with a number for SQL.
ToSQLString Converts a value into a text string for SQL and can add quotes.
ToSQLTime Converts a value into a time string for SQL and can add quotes.
ToSQLValues(ListDateTime) Converts a list of values to a value expression for SQL.
ToSQLValues(ListInt32) Converts a list of values to a value expression for SQL.
ToSQLValues(ListInt64) Convierte una lista de valores en una expresión de valores para SQL
ToSQLValues(ListString) Converts a list of values to a value expression for SQL.
ToSQLValuesT(ListT) Converts a list of values to a value expression for SQL.
ToSQLValuesT(ListT, Boolean) Converts a list of values to a value expression for SQL.
ValueIsDBNull Indicates whether a value is DBNull.
ValueToBoolean Convert a value to Boolean.
ValueToByte Convert a value to Byte.
ValueToDate Convert a value to a date without times.
ValueToDateTime Convert a value to DateTime.
ValueToDecimal Convert a value to Decimal.
ValueToInt16 Convert a value to Int16.
ValueToInt32 Convert a value to Int32.
ValueToInt64 Convert a value to Int64.
ValueToString Convert a value to String.
ValueToTime Convert a value to a date without times.
ValueToType(DataColumn, Object, Boolean, CutTypeString) Converts a value to the indicated column type.
ValueToType(Object, Type, Boolean, Boolean) Converts a value to the indicated column type.
ZeroToDBNull Convierte a DBNull cuando el valor indicado es 0.

Extension Methods

GetAttributeFromT Get attribute from a class.
(Defined by ObjectExtensions)
ValidateDataAnnotations Validate class with validator of DataAnnotations.
(Defined by ObjectExtensions)

See Also