public void ItShouldBePossibleToCreateASimpleSelectQueryWithOr() { var id = Guid.NewGuid(); const string userName = "******"; var table = new QueryTable("Users"); var creator = new SqLiteQueryCreator(); var expected = PurgeQuery(string.Format("SELECT {0}.Id AS {0}_Id,{0}.UserName AS {0}_UserName," + "{0}.Password AS {0}_Password FROM Users AS {0} WHERE" + " ( {0}.UserName = '******' OR {0}.Id = '{2}' )", table.Alias, userName, id)); table.AddField("Id"); table.AddField("UserName"); table.AddField("Password"); table.Or( table.Eq(userName).SetFieldName("UserName"), table.Eq(id).SetFieldName("Id") ); var result = PurgeQuery(creator.CreateQuery<string>(table)); Assert.AreEqual(expected, result); }