public void MssqlSelect_Count_With_Where()
{
IQueryBuilder qBuilder = new MsSqlQueryBuilder();
var expected = "SELECT COUNT(1) FROM [Sale] WITH(NOLOCK) WHERE Id=1";
var actualSql = qBuilder.Count().From("Sale").Where("Id=1").Sql();
Assert.AreEqual(expected, actualSql);
}
public void MssqlSelect_Count_Without_Where()
{
IQueryBuilder qBuilder = new MsSqlQueryBuilder();
var expected = "SELECT COUNT(1) FROM [User] WITH(NOLOCK)";
var actualSql = qBuilder.Count().From("User").Sql();
Assert.AreEqual(expected, actualSql);
}