Gemstone Data Library
Show/Hide TOC

# RootQueryRestrictionAttribute Constructor

Creates a new parameterized RootQueryRestrictionAttribute with the specified SQL filter expression and parameters.

## Definition

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

    public RootQueryRestrictionAttribute(
    	string filterExpression,
    	params Object?[]? parameters
    )

VB
View Source Request Example

    Public Sub New (
    	filterExpression As String,
    	ParamArray parameters As Object()
    )

C++
View Source Request Example

    public:
    RootQueryRestrictionAttribute(
    	String^ filterExpression,
    	... array<Object^>^ parameters
    )

JavaScript
View Source Request Example

    Gemstone.Data.Model.RootQueryRestrictionAttribute = function(filterExpression, ... parameters);

#### Parameters

filterExpression String
  Filter SQL expression for restriction as a composite format string - does not include WHERE. When escaping is needed for field names, use standard ANSI quotes.
parameters Object
  Restriction parameter values.

## Remarks

Each indexed parameter, e.g., "{0}", in the composite format filterExpression will be converted into query parameters where each of the corresponding values in the parameters collection will be applied as IDbDataParameter values to an executed IDbCommand query.

If needed, field names that are escaped with standard ANSI quotes in the filter expression will be updated to reflect what is defined in the user model.

## See Also

#### Reference

RootQueryRestrictionAttribute Class
Gemstone.Data.Model Namespace