Gemstone Data Library
Show/Hide TOC

# SecureTableOperations T Class

A wrapper class for TableOperationsT

## Definition

Namespace: Gemstone.Data.Model
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.177 -- Release Build+d96749616716c7e31d7afb14792fd635b01e16cd
C#
View Source Request Example

    public class SecureTableOperations<T>
    where T : class, new()

VB
View Source Request Example

    Public Class SecureTableOperations(Of T As {Class, New})

C++
View Source Request Example

    generic<typename T>
    where T : ref class, gcnew()
    public ref class SecureTableOperations

JavaScript
View Source Request Example

    JavaScript does not support generic types or methods.

Inheritance
  Object SecureTableOperationsT

#### Type Parameters

T
  Modeled table.

## Constructors

SecureTableOperationsT(AdoDataConnection) | Creates a new SecureTableOperationsT
SecureTableOperationsT(TableOperationsT) | Creates a new SecureTableOperationsT

## Properties

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.
BaseOperations | TableOperationsT which performs DB operations.
Connection | Gets AdoDataConnection instance associated with this TableOperationsT used for database 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.
WildcardChar | Gets the wildcard character used for pattern matching within queries.

## Methods

DeleteRecord(ClaimsPrincipal, T) | Deletes the specified modeled table record from the database.
DeleteRecord(ClaimsPrincipal, RecordRestriction, NullableBoolean) | Deletes the records referenced by the specified restriction.
DeleteRecordAsync(ClaimsPrincipal, T, CancellationToken) | Deletes the specified modeled table record from the database.
DeleteRecordAsync(ClaimsPrincipal, RecordRestriction, CancellationToken, NullableBoolean) | Deletes the records referenced by the specified restriction.
DeleteRecordWhere | Deletes the records referenced by the specified SQL filter expression and parameters.
DeleteRecordWhereAsync | Deletes the records referenced by the specified SQL filter expression and parameters.
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object)
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object)
GetHashCode | Serves as the default hash function. (Inherited from Object)
GetType | Gets the Type of the current instance. (Inherited from Object)
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object)
NewRecord | Creates a new modeled record instance, applying any modeled default values as specified by a DefaultValueAttribute or DefaultValueExpressionAttribute on the model properties.
QueryRecord(ClaimsPrincipal, RecordRestriction) | Queries database and returns a single modeled table record for the specified restriction.
QueryRecord(ClaimsPrincipal, String, RecordRestriction) | Queries database and returns a single modeled table record for the specified restriction, execution of query will apply orderByExpression.
QueryRecordAsync(ClaimsPrincipal, RecordRestriction, CancellationToken) | Queries database and returns a single modeled table record for the specified restriction.
QueryRecordAsync(ClaimsPrincipal, String, RecordRestriction, CancellationToken) | Queries database and returns a single modeled table record for the specified restriction, execution of query will apply orderByExpression.
QueryRecordCount(ClaimsPrincipal) | Gets total record count for the modeled table.
QueryRecordCount(ClaimsPrincipal, IRecordFilter) | Gets the record count for the modeled table based on search parameter. Search executed against fields modeled with SearchableAttribute.
QueryRecordCount(ClaimsPrincipal, RecordRestriction) | Gets the record count for the specified restrictions - or - total record count for the modeled table if restrictions is null.
QueryRecordCountAsync(ClaimsPrincipal, CancellationToken) | Gets total record count for the modeled table.
QueryRecordCountAsync(ClaimsPrincipal, CancellationToken, IRecordFilter) | Gets the record count for the modeled table based on search parameter. Search executed against fields modeled with SearchableAttribute.
QueryRecordCountAsync(ClaimsPrincipal, CancellationToken, RecordRestriction) | Gets the record count for the specified restrictions - or - total record count for the modeled table if restrictions is null.
QueryRecordCountWhere | Gets the record count for the modeled table for the specified SQL filter expression and parameters.
QueryRecordCountWhereAsync | Gets the record count for the modeled table for the specified SQL filter expression and parameters.
QueryRecords(ClaimsPrincipal, RecordRestriction) | Queries database and returns modeled table records for the specified restriction.
QueryRecords(ClaimsPrincipal, String, RecordRestriction, Int32) | Queries database and returns modeled table records for the specified parameters.
QueryRecords(ClaimsPrincipal, String, Boolean, Int32, Int32) | Queries database and returns modeled table records for the specified sorting and paging parameters.
QueryRecords(ClaimsPrincipal, String, Boolean, Int32, Int32, IRecordFilter) | Queries database and returns modeled table records for the specified sorting, paging and search parameters. Search executed against fields modeled with SearchableAttribute.
QueryRecords(ClaimsPrincipal, String, Boolean, Int32, Int32, RecordRestriction) | Queries database and returns modeled table records for the specified sorting and paging parameters.
QueryRecordsAsync(ClaimsPrincipal, RecordRestriction, CancellationToken) | Queries database and returns modeled table records for the specified restriction.
QueryRecordsAsync(ClaimsPrincipal, String, RecordRestriction, Int32, CancellationToken) | Queries database and returns modeled table records for the specified parameters.
QueryRecordsAsync(ClaimsPrincipal, String, Boolean, Int32, Int32, CancellationToken) | Queries database and returns modeled table records for the specified sorting and paging parameters.
QueryRecordsAsync(ClaimsPrincipal, String, Boolean, Int32, Int32, CancellationToken, IRecordFilter) | Queries database and returns modeled table records for the specified sorting, paging and search parameters. Search executed against fields modeled with SearchableAttribute.
QueryRecordsAsync(ClaimsPrincipal, String, Boolean, Int32, Int32, CancellationToken, RecordRestriction) | Queries database and returns modeled table records for the specified sorting and paging parameters.
QueryRecordsWhere | Queries database and returns modeled table records for the specified SQL filter expression and parameters.
QueryRecordsWhereAsync | 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.
QueryRecordWhereAsync | Queries database and returns a single modeled table record for the specified SQL filter expression and parameters.
ToString | Returns a string that represents the current object. (Inherited from Object)
UpdateRecord(ClaimsPrincipal, 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(ClaimsPrincipal, 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.
UpdateRecordAsync(ClaimsPrincipal, DataRow, CancellationToken, 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.
UpdateRecordAsync(ClaimsPrincipal, T, CancellationToken, 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(ClaimsPrincipal, 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.
UpdateRecordWhere(ClaimsPrincipal, 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.
UpdateRecordWhereAsync(ClaimsPrincipal, T, String, CancellationToken, 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.
UpdateRecordWhereAsync(ClaimsPrincipal, DataRow, String, CancellationToken, 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.

## See Also

#### Reference

Gemstone.Data.Model Namespace