|
RecordRestriction Constructor
|
Creates a new parameterized
RecordRestriction with the specified SQL filter
expression and parameters.
Namespace: GSF.Data.ModelAssembly: GSF.Core (in GSF.Core.dll) Version: 2.4.182-beta
Syntax public RecordRestriction(
string filterExpression,
params Object[] parameters
)
Public Sub New (
filterExpression As String,
ParamArray parameters As Object()
)
public:
RecordRestriction(
String^ filterExpression,
... array<Object^>^ parameters
)
new :
filterExpression : string *
parameters : Object[] -> RecordRestriction
GSF.Data.Model.RecordRestriction = function(filterExpression, ... parameters);
View SourceParameters
- 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 any of the parameters reference a table field that is modeled with either
an EncryptDataAttribute or FieldDataTypeAttribute, then the function
GetInterpretedFieldValue(String, Object) will need to be called, replacing the
target parameter with the returned value so that the field value will be properly set prior to
executing any database function.
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