|
ITable
|
Defines a common interface for implementations of TableOperationsT.
Namespace: GSF.Data.Model
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta
SyntaxThe ITableOperations type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | ApplyRootQueryRestrictionToDeletes | Gets or sets flag that determines if RootQueryRestriction should be applied to delete operations. |
| ApplyRootQueryRestrictionToUpdates | Gets or sets flag that determines if RootQueryRestriction should be applied to update operations. |
| ExceptionHandler | Gets or sets delegate used to handle table operation exceptions. |
| HasPrimaryKeyIdentityField | Gets flag that determines if modeled table has a primary key that is an identity field. |
| PrimaryKeyCache | Gets or sets primary key cache. |
| RootQueryRestriction | Gets or sets root record restriction that applies to query table operations. |
| TableName | Gets the table name defined for the modeled table, includes any escaping as defined in model. |
| UnescapedTableName | Gets the table name defined for the modeled table without any escape characters. |
| UseCaseSensitiveFieldNames | Gets or sets flag that determines if field names should be treated as case sensitive. Defaults to false. |
Methods| Name | Description | |
|---|---|---|
 | 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. |
| AddNewRecord(DataRow) | Adds the specified row to the database. |
| AddNewRecord(Object) | Adds the specified modeled table record to the database. |
| ApplyRecordDefaults | Applies the default values on the specified modeled table record where any of the properties are marked with either DefaultValueAttribute or DefaultValueExpressionAttribute. |
| ApplyRecordUpdates | Applies the update values on the specified modeled table record where any of the properties are marked with UpdateValueExpressionAttribute. |
| ClearPrimaryKeyCache | Clears the primary key cache for this ITableOperations instance. |
| DeleteRecord(DataRow) | Deletes the record referenced by the specified row. |
| DeleteRecord(Object) | Deletes the specified modeled table record from the database. |
| DeleteRecord(Object) | Deletes the record referenced by the specified primaryKeys. |
| DeleteRecord(RecordRestriction, NullableBoolean) | Deletes the records referenced by the specified restriction. |
| DeleteRecordWhere | Deletes the records referenced by the specified SQL filter expression and parameters. |
| FieldHasAttribute(String, Type) | Determines if the specified field has an associated attribute. |
| FieldHasAttributeTAttribute(String) | Determines if the specified field has an associated attribute. |
| GetFieldNames | Gets the field names for the table; if escaped is true, also includes any escaping as defined in model. |
| GetFieldType | Gets the Type for the specified field. |
| GetFieldValue | Gets the value for the specified field. |
| GetInterpretedFieldValue | Gets the interpreted value for the specified field, encrypting or returning any intermediate IDbDataParameter value as needed. |
| GetPageOfRecords | Gets the specified page of records from the provided source records array. |
| GetPrimaryKeyCacheSize | Calculates the size of the current primary key cache, in number of records. |
| GetPrimaryKeyFieldNames | Get the primary key field names for the table; if escaped is true, also includes any escaping as defined in model. |
| GetPrimaryKeys(DataRow) | Gets the primary key values from the specified row. |
| GetPrimaryKeys(Object) | Gets the primary key values from the specified record. |
| GetSearchRestriction | Generates a RecordRestriction based on fields marked with SearchableAttribute and specified searchText. |
| IsSearchMatch(Object, String) | Determines if any record fields modeled with the SearchableAttribute match any of the specified searchValues. |
| IsSearchMatch(Object, StringComparison, String) | Determines if any record fields modeled with the SearchableAttribute match any of the specified searchValues. |
| LoadRecord(DataRow) | Creates a new modeled table record queried from the specified row. |
| LoadRecord(Object) | Creates a new modeled table record queried from the specified primaryKeys. |
| NewRecord | Creates a new modeled record instance, applying any modeled default values as specified by a DefaultValueAttribute or DefaultValueExpressionAttribute on the model properties. |
| QueryRecord(RecordRestriction) | Queries database and returns a single modeled table record for the specified restriction. |
| QueryRecord(String, RecordRestriction) | Queries database and returns a single modeled table record for the specified restriction, execution of query will apply orderByExpression. |
| QueryRecordCount(RecordRestriction) | Gets the record count for the specified restriction - or - total record count for the modeled table if restriction is null. |
| QueryRecordCount(String) | Gets the record count for the modeled table based on search parameter. Search executed against fields modeled with SearchableAttribute. |
| QueryRecordCountWhere | Gets the record count for the modeled table for the specified SQL filter expression and parameters. |
| QueryRecords(RecordRestriction) | Queries database and returns modeled table records for the specified restriction. |
| QueryRecords(String, RecordRestriction, Int32) | Queries database and returns modeled table records for the specified parameters. |
| QueryRecords(String, Boolean, Int32, Int32, RecordRestriction) | Queries database and returns modeled table records for the specified sorting and paging parameters. |
| 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. |
| QueryRecordsWhere | Queries database and returns modeled table records for the specified SQL filter expression and parameters. |
| QueryRecordWhere | Queries database and returns a single modeled table record for the specified SQL filter expression and parameters. |
| 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. |
| ToDataTable | Converts the given collection of records into a DataTable. |
| TryGetFieldAttribute(String, Type, Attribute) | Attempts to get the specified attributeType for a field. |
| TryGetFieldAttributeTAttribute(String, TAttribute) | Attempts to get the specified attribute for a field. |
| 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. |
| 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. |
| 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. |
| 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. |
See Also