[TestMethod]
    public void TestSqlConnectionStringsCrudViaTableName()
    {
        // Setup
        var text = Helper.GetUnicodeString();
        var entity = new
        {
            SessionId = Guid.NewGuid(),
            ColumnChar = text,
            ColumnNChar = text,
            ColumnNText = text,
            ColumnNVarChar = text,
            ColumnText = text,
            ColumnVarChar = text
        };

        using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
        {
            // Act Insert
            var id = connection.Insert(ClassMappedNameCache.Get<StringsClass>(), entity);

            // Act Query
            var data = connection.Query(ClassMappedNameCache.Get<StringsClass>(), new { SessionId = (Guid)id }).FirstOrDefault();

            // Assert
            Assert.IsNotNull(data);
            Assert.AreEqual(entity.ColumnChar, data.ColumnChar.Trim());
            Assert.AreEqual(entity.ColumnNChar, data.ColumnNChar.Trim());
            Assert.AreEqual(entity.ColumnNText, data.ColumnNText);
            Assert.AreEqual(entity.ColumnNVarChar, data.ColumnNVarChar);
            Assert.AreEqual(entity.ColumnText, data.ColumnText);
            Assert.AreEqual(entity.ColumnVarChar, data.ColumnVarChar);
        }
    }