Overview
Adds or updates rows in DataTable and DataTableDictionary by specified key and properties .( DataRow | Array<DataRow> ) DataTableDictionary.Ensure(key: string, input: object)
( DataRow | Array<DataRow> ) DataTableDictionary.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.
Remarks
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();
Remarks
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();
Examples
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();