Click or drag to resize

AdapterBaseConnectionString Property

Gets or sets key/value pair connection information specific to this AdapterBase.

Namespace: GSF.TimeSeries.Adapters
Assembly: GSF.TimeSeries (in GSF.TimeSeries.dll) Version: 2.4.207-beta
Syntax
public virtual string ConnectionString { get; set; }
View Source

Property Value

String

Implements

IAdapterConnectionString
Remarks

Example connection string using manually defined measurements:
inputMeasurementKeys={P1:1245;P1:1247;P2:1335};
outputMeasurements={P3:1345,60.0,1.0;P3:1346;P3:1347}
When defined manually, elements in key:
* inputMeasurementKeys are defined as "ArchiveSource:PointID"
* outputMeasurements are defined as "ArchiveSource:PointID,Adder,Multiplier", the adder and multiplier are optional defaulting to 0.0 and 1.0 respectively.

Example connection string using measurements defined in a DataSource table:
inputMeasurementKeys={FILTER ActiveMeasurements WHERE Company='GSF' AND SignalType='FREQ' ORDER BY ID};
outputMeasurements={FILTER ActiveMeasurements WHERE SignalType IN ('IPHA','VPHA') AND Phase='+'}

Basic filtering syntax is as follows:

{FILTER <TableName> WHERE <Expression> [ORDER BY <SortField>]}

Source tables are expected to have at least the following fields:
NameTypeDescription.
IDNVARCHARMeasurement key formatted as: ArchiveSource:PointID.
PointTagNVARCHARPoint tag of measurement.
AdderFLOATAdder to apply to value, if any (default to 0.0).
MultiplierFLOATMultiplier to apply to value, if any (default to 1.0).

See Also