|
ITableOperationsUpdateRecordWhere(DataRow, String, Object) Method
|
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.
Namespace: GSF.Data.ModelAssembly: GSF.Core (in GSF.Core.dll) Version: 2.4.248-beta+a497a19de709fd99e2448886199a2c8824265ddf
Syntaxint UpdateRecordWhere(
DataRow row,
string filterExpression,
params Object[] parameters
)
Function UpdateRecordWhere (
row As DataRow,
filterExpression As String,
ParamArray parameters As Object()
) As Integer
int UpdateRecordWhere(
DataRow^ row,
String^ filterExpression,
... array<Object^>^ parameters
)
abstract UpdateRecordWhere :
row : DataRow *
filterExpression : string *
parameters : Object[] -> int
function UpdateRecordWhere(row, filterExpression, ... parameters);
View SourceParameters
- row DataRow
- DataRow of queried data to be updated.
- 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.
Return Value
Int32Number of rows affected.
Remarks
Record restriction is only used for custom update expressions or in cases where modeled
table has no defined primary keys.
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 specified 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 the 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.
This is a convenience call to UpdateRecord(DataRow, RecordRestriction).
See Also