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. |