DataTableDictionary.Ensure
Overview
Adds or updates rows in DataTable and DataTableDictionary by specified key and properties .
Updates or creates a row with given input properties. If key does not exists initializes new row with initInput properties.
(
DataRow | Array<
DataRow> ) myDataTableDictionary.Ensure(key: string, input: object, initInput: object)
Arguments
string key
Required. Key of rows to be updated or added.
object input
Row properties to be updated.
object initInput
Row properties to be updated if no match found.
Returns
Matching row instance.
Remarks
initProperties argument used as to initialize a new row no matching row found in DataTable
This method inserts or updates rows in DataTable
Example
var table = $Database.Get({
Parameters : {
TargetSchema : 'HR',
TargetTable : 'Groups'
}
});
var list = table.ToDictionary('Name');
var myGroup = list.Ensure("MyGroup", {
Name : 'MyGroup',
Code : '123'
}, {
Id : Script.NewId()
});
list.Save();
See Also
Copyright © 2010 - 2023 Emakin. All rights reserved.