public void EmployeeQueryEmptyWhere()
{
var qry = new EmployeeEmptyWhere();
using (var cn = GetConnection())
{
var results = qry.Execute(cn);
Assert.IsTrue(qry.ResolvedSql.Equals("SELECT [e].* FROM [dbo].[Employee] [e] ORDER BY [e].[LastName]"));
}
}
public void EmployeeQueryWithOrgJoin()
{
var qry = new EmployeeEmptyWhere()
{
WithOrgs = true
};
using (var cn = GetConnection())
{
var results = qry.Execute(cn);
Assert.IsTrue(qry.ResolvedSql.Equals("SELECT [e].* FROM [dbo].[Employee] [e] INNER JOIN [dbo].[Organization] [org] ON [e].[OrganizationId]=[org].[Id] ORDER BY [e].[LastName]"));
}
}
