public void FormatCount_WhereForEmail_SameSql()
{
var sqlProvider = new MsSqlProvider {
SetContext = { TableType = typeof(SysUser) }
};
sqlProvider.SetContext.WhereExpression =
(Expression <Func <SysUser, bool> >)(a => a.Email == "*****@*****.**");
sqlProvider.SetContext.NoLock = true;
sqlProvider.FormatCount();
Equal("SELECT COUNT(1) FROM [SYS_USER] (NOLOCK) WHERE ([EMAIL] = @Email)", sqlProvider.SqlString.Trim());
}
