public void ShouldAddWhereClauseToExistingQueryBuilder()
{
transaction.Query <object>().Returns(TableQueryBuilder("Accounts"));
var query = transaction.Query <object>();
// ReSharper disable once ReturnValueOfPureMethodIsNotUsed
query.Where("Id", UnarySqlOperand.Equal, 1);
// Old versions of Query returned a stateful object, while now each call is stateless - it returns a new object.
// It's invalid to call a method twice
Assert.Throws <Exception>(() => query.ToList());
}
public override void SetUp()
{
base.SetUp();
var config = new RelationalStoreConfiguration(ConnectionString);
config.DocumentMaps.Register(new CustomerMap());
store = new RelationalStore(config);
transaction = store.BeginReadTransaction();
allIdsRandomlySorted = transaction.Query <Customer>().ToList().Select(p => p.Id).OrderByDescending(p => Guid.NewGuid()).ToList();
}
public List <Customer> List100CustomersQueryWhereText()
{
return(EnsureResults(
transaction.Query <Customer>().Where("FirstName = @name").Parameter("name", "Robert").Take(100).ToList()
));
}