public void TestCreateSelectCommandWithDoubleCondition()
{
_sqlCommandBuilder.CreateSelectQuery(_table);
var idField = _table.Fields.FirstOrDefault(x => x.Name == "gid");
_sqlCommandBuilder.AddCondition(idField, "0");
var brandField = _table.Fields.FirstOrDefault(x => x.Name == "Brand");
_sqlCommandBuilder.AddCondition(brandField, "Audi");
var sqlQuery = _sqlCommandBuilder.CompleteQuery();
Assert.Equal("SELECT * FROM data.Car WHERE gid = '0' AND Brand = 'Audi'", sqlQuery);
}