TimeSeriesLibrary.TSLibrary.DeleteMatchingSeries C# (CSharp) Method

DeleteMatchingSeries() public method

This method deletes any records from the table which match the given WHERE clause of a SQL command, using the given database connection number and database table name.
public DeleteMatchingSeries ( int connectionNumber, String tableName, String traceTableName, String whereClause ) : bool
connectionNumber int The serial number of the connection that is used to access the time series
tableName String The name of the database table that time series will be deleted from
traceTableName String The name of the database table that stores the BLOB for a single trace
whereClause String The WHERE clause of a SQL command, not including the word WHERE. /// For example, to delete delete all records where Id > 55, use the text "Id > 55".
return bool
        public bool DeleteMatchingSeries(
                int connectionNumber, String tableName, String traceTableName, String whereClause)
        {
            // Get the connection that we'll pass along.
            SqlConnection connx = GetConnectionFromId(connectionNumber);
            // Construct new TS object with SqlConnection object and table name
            TS ts = new TS(connx, ConnxObject, tableName, traceTableName);

            return ts.DeleteMatchingSeries(whereClause);
        }