Allows to perform relational database operations.

You can use $Database.Get method to perform query on existing records, make changes on returned DataTable instance and persist all changes with DataTable.Save method.

If you need to just insert new values you can use the $Database.Empty method to create a empty DataTable to add new rows and save table.

This class also provides $Database.ImportFromXml and $Database.ExportToXml methods to map database to Data Model (Xml) for allow user to make changes interactive.

 To update or insert a single row you can use $Database.EnsureData method to perform single row updates with less code.