DatabaseFileExtensions class | QSYS API Reference Guide
Estimated reading time: 2 minutes
Defines a collection of extension methods to aid in operating with the file’s dataset.
Namespace: ASNA.QSys.Runtime Assembly: ASNA.QSys.Runtime.dll
Inheritance: Object
Methods
| Signature | Description |
|---|---|
| GetAdgTable(AdgDataSet, String) | Finds the data table/record format in the file represented dataset. |
| GetUpdatedDataSet(FileAdapter, Dictionary<String, String>) | Allocates a file’s dataset, to hold the data communicated between the program and the database. |
| SetActive(AdgDataSet, String) | Sets the active record format in a file and returns it. |
| ToDataSetValues(IEnumerable<Object>) | Converts a collection of fixed-sized values into a collection of basic .Net scalar types. |
AdgTable GetAdgTable(AdgDataSet dataSet, string formatName)
Finds the data table/record format in the file represented dataset.
AdgTable GetAdgTable(AdgDataSet dataSet, string formatName)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| AdgDataSet | dataSet | The AdgDataSet that represents the file to query for a table. |
| String | formatName | The table name, or “*FILE” to return the only table in a single format file. |
Returns
| Type | Description |
|---|---|
| AdgTable | The record format as an AdgTable object of the table that matches the given name in the dataset. |
AdgDataSet GetUpdatedDataSet(FileAdapter fileAdapter, Dictionary<string, string> formatIDs)
Allocates a file’s dataset, to hold the data communicated between the program and the database.
AdgDataSet GetUpdatedDataSet(FileAdapter fileAdapter, Dictionary<string, string> formatIDs)
AdgTable SetActive(AdgDataSet dataSet, string formatName)
Sets the active record format in a file and returns it.
AdgTable SetActive(AdgDataSet dataSet, string formatName)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| AdgDataSet | dataSet | The AdgDataSet that represents the file. |
| String | formatName | The table name, or “*FILE” to select the only table in a single format file. |
Returns
| Type | Description |
|---|---|
| AdgTable | The active record format AdgTable object. |
IEnumerable<object> ToDataSetValues(IEnumerable<object> stronglyTypedValues)
Converts a collection of fixed-sized values into a collection of basic .Net scalar types.
IEnumerable<object> ToDataSetValues(IEnumerable<object> stronglyTypedValues)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| IEnumerable<Object> | stronglyTypedValues | Collection of fixed-sized values. |
Returns
| Type | Description |
|---|---|
| IEnumerable`1 | The converted collection of .Net scalar values. |