$Database¶
$Database allows you to perform relational database operations.
You can use the $Database.Get method to query existing records, make changes on the returned DataTable instance, and persist all changes with the DataTable.Save method.
If you need to just insert new values, you can use the $Database.Empty method to create an empty to add new rows and save the table.
This class also provides the $Database.ImportFromXml and $Database.ExportToXml methods to map the database to a Data Model (XML) to allow users to make interactive changes.
To update or insert a single row, you can use the $Database.EnsureData method to perform single-row updates with less code.
1 | |