ConnectorLib .NET 24.2

# Introduction

The datastore is a feature of ConnectorLib .NET that allows a connector to store structured information in a file.

Each datastore file contains SQL-like tables with defined columns.

You can use the features provided by ConnectorLib .NET to create new tables in the datastore, store and retrieve information efficiently, and manage upgrades and versioning.

## Quick Guide

The following table summarizes the functionality offered by the datastore.

Functionality | Provided By
--- | ---
Create or open a datastore | Create a `DatastoreFile` object
Close a datastore | Dispose of the `DatastoreFile` object
Create or open a table | `DatastoreFile.NewTable`
Insert a record | `Table.Insert` (pass a Record with all fields set)
Update a record | `Table.Update` (only fields set in the Record are updated)
Remove a record | `Table.Remove`
Commit changes | `DatastoreFile.ProcessQueue`
Select a single record that matches a filter | `Table.SelectOne`
Select all records that match a filter | `Table.Select`
Specify constraints | Call `AddUniqueReplaceConstraint` on a `ColumnList` and pass it to `DatastoreFile.NewTable`
Add an index for faster queries | `Table.CreateIndex`
Upgrade a table | `Table.Modify`

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL ConnectorLib .NET 24.2

Topic Title: Introduction