SqlClient

Namespace: AVEVA.IntegrationService.DataAPI.SDK

Interface: ISqlClient

Description: SqlClient is used to communicate with SQL Server ProductCategory products. It inherits all base methods from BaseClient.

Methods

SqlClient uses all methods from the BaseClient (refer Common Methods (Available in BaseClient) section for more information).

Example:

// Create the SQL client

string host = "https://your-server/integration/v1";

string token = "your-access-token";

var sqlClient = DataApiClientFactory.CreateDataApiClient<SqlClient>(

host: host,

authType: AuthenticationType.Connect,

waitingTimeInMinutesForLiveData: 60,

token: token,

hubCancellationToken: null

);

// Get all tables from SQL datasource

DataTable tables = await sqlClient.GetTables("MySQLDataSource");

// Get specific table data

DataTable employeeData = await sqlClient.GetTableData(

"MySQLDataSource",

"Employees",

filter: "Department eq 'Engineering'"

);

// Get table schema

DataTable schema = await sqlClient.GetTableSchema(

"MySQLDataSource",

"Employees"

);

// Post table data

DataTable newData = new DataTable("Employees");

newData.Columns.Add("Name", typeof(string));

newData.Columns.Add("Department", typeof(string));

newData.Rows.Add("John Doe", "Engineering");

AcknowledgementResult result = await sqlClient.PostTableData(

"MySQLDataSource",

"Employees",

newData,

""

);