public void can_create_session_query_using_and_comparator() { session.CreateQueryFor <Account>() .Select(SelectionOptions.AllFrom <Account>()) .CreateCriteria(Restrictions.EqualTo <Account>(a => a.AccountNumber, "12234")) .SingleOrDefault(); }
public void can_create_session_query_using_and_comparator_with_component() { session.CreateQueryFor <Employee>() .Select(SelectionOptions.AllFrom <Employee>()) .CreateCriteria(Restrictions.GreaterThanOrEqualTo <Employee>(a => a.EmployeeNumber, "12234")) .SingleOrDefault(); }
public void can_generate_exception_on_creating_session_query_when_specified_query_value_does_not_match_property_type() { try { // account number is a string and an integer is used on input: session.CreateQueryFor <Account>() .Select(SelectionOptions.AllFrom <Account>()) .CreateCriteria(Restrictions.EqualTo <Account>(a => a.AccountNumber, 123456)) .SingleOrDefault(); Assert.False(true, "The exception for mismatch query to property type was not thrown."); } catch (Exception exception) { System.Diagnostics.Debug.WriteLine(exception.ToString()); Assert.Equal(typeof(InvalidCastException), exception.GetBaseException().GetType()); } //Assert.Throws<InvalidCastException>(() => // { // // account number is a string and an integer is used on input: // session.CreateQueryFor<Account>() // .Select(SelectionOptions.AllFrom<Account>()) // .CreateCriteria(Restrictions.EqualTo<Account>(a => a.AccountNumber, 123456)) // .SingleOrDefault(); // } //); }
public void can_find_entity_by_query() { using (var session = factory.OpenSession()) { var department = session.CreateQueryFor <Department>() .Select(SelectionOptions.AllFrom <Department>()) .CreateCriteria(Restrictions.Like <Department>(d => d.Description, "#2")) .SingleOrDefault(); Assert.NotNull(department); } }
public void can_find_entity_set_by_query() { using (var session = factory.OpenSession()) { var department = session.CreateQueryFor <Department>() .Select(SelectionOptions.AllFrom <Department>()) .CreateCriteria(Restrictions.EqualTo <Department>(d => d.Id, 1)) .SingleOrDefault(); System.Diagnostics.Debug.WriteLine(department.Instructors.Count); Assert.True(department.Instructors.Count > 0); } }