public void query_over()
{
new QueryOver <User>(() =>
{
var db = GetConnection(); //any new connection resets table name
db.Open();
return(db);
}, _table).Select(d => d.FirstName, d => d.FirstName == "John").GetValue().Should()
.Be("John");
var u = new QueryOver <User>(() =>
{
var db = GetConnection();
db.Open();
return(db);
}, _table).SelectAllColumns(d => d.FirstName == "John").GetFirstRow();
u.FirstName.Should().Be("John");
var count = new QueryOver <User>(() =>
{
var db = GetConnection();
db.Open();
return(db);
}, _table).Build(q => q.Where(d => d.Id > 0).Select(d => d.Count())).GetValue();
count.Should().Be(_inserted.Length);
}