Click or drag to resize

TableOperationsT Methods

The TableOperationsT 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(T) 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 Static member ApplyRecordDefaultsFunction Gets a delegate for the ApplyRecordDefaults(T) method for specified type T.
Public method ApplyRecordUpdates Applies the update values on the specified modeled table record where any of the properties are marked with UpdateValueExpressionAttribute.
Public method Static member ApplyRecordUpdatesFunction Gets a delegate for the ApplyRecordUpdates(T) method for specified type T.
Public method ClearPrimaryKeyCache Clears the primary key cache for this TableOperationsT instance.
Public method DeleteRecord(DataRow) Deletes the record referenced by the specified row.
Public method DeleteRecord(Object) Deletes the record referenced by the specified primaryKeys.
Public method DeleteRecord(T) Deletes the specified modeled table record from the database.
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 Equals Determines whether the specified object is equal to the current object.
(Inherited from Object)
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.
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object)
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 GetHashCode Serves as the default hash function.
(Inherited from Object)
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(T) 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 Static member GetTableName Gets table name for model applying model attributes TableNameAttribute, ConfigFileTableNamePrefixAttribute, and UseEscapedNameAttribute
Public method GetType Gets the Type of the current instance.
(Inherited from Object)
Public method IsSearchMatch(T, String) Determines if any record fields modeled with the SearchableAttribute match any of the specified searchValues.
Public method IsSearchMatch(T, 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 Static member LoadRecordFunction Gets a delegate for the LoadRecord(DataRow) function for specified type T.
Protected method MemberwiseClone Creates a shallow copy of the current Object.
(Inherited from Object)
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 Static member NewRecordFunction Gets a delegate for the NewRecord function for specified type T.
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 ToString Returns a string that represents the current object.
(Inherited from Object)
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(T, 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(T, 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
Extension Methods
  Name Description
Public Extension Method GetEnumValueOrDefault Gets the enumeration constant for value, if defined in the enumeration, or a default value.
(Defined by EnumExtensions)
Public Extension Method GetEnumValueOrDefaultT Gets the enumeration constant for this value, if defined in the enumeration, or a default value.
(Defined by EnumExtensions)
Top
See Also