Click or drag to resize

ITableOperations Methods

The ITableOperations type exposes the following members.

Methods
  Name Description
Public method AddNewOrUpdateRecord Adds the specified modeled table record to the database if the record has not defined any of its primary key values; otherwise, the database will be updated with the specified modeled table record.
Public method AddNewRecord(DataRow) Adds the specified row to the database.
Public method AddNewRecord(Object) Adds the specified modeled table record to the database.
Public method ApplyRecordDefaults Applies the default values on the specified modeled table record where any of the properties are marked with either DefaultValueAttribute or DefaultValueExpressionAttribute.
Public method ApplyRecordUpdates Applies the update values on the specified modeled table record where any of the properties are marked with UpdateValueExpressionAttribute.
Public method ClearPrimaryKeyCache Clears the primary key cache for this ITableOperations instance.
Public method DeleteRecord(DataRow) Deletes the record referenced by the specified row.
Public method DeleteRecord(Object) Deletes the specified modeled table record from the database.
Public method DeleteRecord(Object) Deletes the record referenced by the specified primaryKeys.
Public method DeleteRecord(RecordRestriction, NullableBoolean) Deletes the records referenced by the specified restriction.
Public method DeleteRecordWhere Deletes the records referenced by the specified SQL filter expression and parameters.
Public method FieldHasAttribute(String, Type) Determines if the specified field has an associated attribute.
Public method FieldHasAttributeTAttribute(String) Determines if the specified field has an associated attribute.
Public method GetFieldNames Gets the field names for the table; if escaped is true, also includes any escaping as defined in model.
Public method GetFieldType Gets the Type for the specified field.
Public method GetFieldValue Gets the value for the specified field.
Public method GetInterpretedFieldValue Gets the interpreted value for the specified field, encrypting or returning any intermediate IDbDataParameter value as needed.
Public method GetPageOfRecords Gets the specified page of records from the provided source records array.
Public method GetPrimaryKeyCacheSize Calculates the size of the current primary key cache, in number of records.
Public method GetPrimaryKeyFieldNames Get the primary key field names for the table; if escaped is true, also includes any escaping as defined in model.
Public method GetPrimaryKeys(DataRow) Gets the primary key values from the specified row.
Public method GetPrimaryKeys(Object) Gets the primary key values from the specified record.
Public method GetSearchRestriction Generates a RecordRestriction based on fields marked with SearchableAttribute and specified searchText.
Public method IsSearchMatch(Object, String) Determines if any record fields modeled with the SearchableAttribute match any of the specified searchValues.
Public method IsSearchMatch(Object, StringComparison, String) Determines if any record fields modeled with the SearchableAttribute match any of the specified searchValues.
Public method LoadRecord(DataRow) Creates a new modeled table record queried from the specified row.
Public method LoadRecord(Object) Creates a new modeled table record queried from the specified primaryKeys.
Public method NewRecord Creates a new modeled record instance, applying any modeled default values as specified by a DefaultValueAttribute or DefaultValueExpressionAttribute on the model properties.
Public method QueryRecord(RecordRestriction) Queries database and returns a single modeled table record for the specified restriction.
Public method QueryRecord(String, RecordRestriction) Queries database and returns a single modeled table record for the specified restriction, execution of query will apply orderByExpression.
Public method QueryRecordCount(RecordRestriction) Gets the record count for the specified restriction - or - total record count for the modeled table if restriction is null.
Public method QueryRecordCount(String) Gets the record count for the modeled table based on search parameter. Search executed against fields modeled with SearchableAttribute.
Public method QueryRecordCountWhere Gets the record count for the modeled table for the specified SQL filter expression and parameters.
Public method QueryRecords(RecordRestriction) Queries database and returns modeled table records for the specified restriction.
Public method QueryRecords(String, RecordRestriction, Int32) Queries database and returns modeled table records for the specified parameters.
Public method QueryRecords(String, Boolean, Int32, Int32, RecordRestriction) Queries database and returns modeled table records for the specified sorting and paging parameters.
Public method QueryRecords(String, Boolean, Int32, Int32, String) Queries database and returns modeled table records for the specified sorting, paging and search parameters. Search executed against fields modeled with SearchableAttribute.
Public method QueryRecordsWhere Queries database and returns modeled table records for the specified SQL filter expression and parameters.
Public method QueryRecordWhere Queries database and returns a single modeled table record for the specified SQL filter expression and parameters.
Public method SearchRecords Locally searches retrieved table records after queried from database for the specified sorting and search parameters. Search executed against fields modeled with SearchableAttribute. Function only typically used for record models that apply the EncryptDataAttribute.
Public method ToDataTable Converts the given collection of records into a DataTable.
Public method TryGetFieldAttribute(String, Type, Attribute) Attempts to get the specified attributeType for a field.
Public method TryGetFieldAttributeTAttribute(String, TAttribute) Attempts to get the specified attribute for a field.
Public method UpdateRecord(DataRow, RecordRestriction) Updates the database with the specified row, any model properties marked with UpdateValueExpressionAttribute will be evaluated and applied before the record is provided to the data source.
Public method UpdateRecord(Object, RecordRestriction, NullableBoolean) Updates the database with the specified modeled table record, any model properties marked with UpdateValueExpressionAttribute will be evaluated and applied before the record is provided to the data source.
Public method UpdateRecordWhere(DataRow, String, Object) Updates the database with the specified row referenced by the specified SQL filter expression and parameters, any model properties marked with UpdateValueExpressionAttribute will be evaluated and applied before the record is provided to the data source.
Public method UpdateRecordWhere(Object, String, Object) Updates the database with the specified modeled table record referenced by the specified SQL filter expression and parameters, any model properties marked with UpdateValueExpressionAttribute will be evaluated and applied before the record is provided to the data source.
Top
See Also