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);
}
}
