public void SelectFieldWithAliasStatement_Success() { ICriteriaQuery cc = EJBContainer.Instance.EntityManager.GetCriteriaBuilder().CreateQuery(); IRoot r = cc.From("Students"); cc.Select(r.Get("FirstName").Alias("Name")); string s = cc.ToString(); Assert.AreEqual(s, "SELECT Students.FirstName AS Name FROM Students"); }
public void SelectMultipleFieldsStatement_Success() { ICriteriaQuery cc = EJBContainer.Instance.EntityManager.GetCriteriaBuilder().CreateQuery(); IRoot r = cc.From("Students"); cc.Select("FirstName", "LastName"); string s = cc.ToString(); Assert.AreEqual(s, "SELECT FirstName, LastName FROM Students"); }