public void CreateTableAndInsertWorking() { // Prepare data. InitializeStorageAdapter(); // Create test table. CreateTable(); // Insert test data. InsertMockDataToTable(); var count = _adapter.Count(TableName, ColumnChannelName, StorageTestChannelName); Assert.AreEqual(1, count); // Verify. var testEntries = _adapter.Select(TableName, ColumnChannelName, StorageTestChannelName, null, null).ToList(); Assert.AreEqual(1, testEntries.Count); var entryId = 0L; testEntries.ForEach(entry => { entryId = (long)entry[0]; Assert.AreEqual(entry[1], StorageTestChannelName); Assert.AreEqual(entry[2], ""); }); _adapter.Delete(TableName, ColumnIdName, entryId); count = _adapter.Count(TableName, ColumnChannelName, StorageTestChannelName); Assert.AreEqual(0, count); }