public void TestInsert3ClassData()
{
Place p = new Place()
{
Address = "place", Description = "this is a place", Size = 100
};
Session.SaveOrUpdate(p);
Classroom c = new Classroom()
{
Address = "place", Description = "this is a place", Size = 100, RoomNumber = "301"
};
Session.SaveOrUpdate(c);
Lab l = new Lab()
{
Address = "place", Description = "this is a place", Size = 100, LabSubject = "Physical"
};
Session.SaveOrUpdate(l);
Session.Flush();
var list = NewSession.QueryOver <Place>().List();
Assert.Greater(list.Count, 0);
foreach (var place in list)
{
Debug.WriteLine(place.GetType().ToString());
}
}
public void SingleTableTestSearchSubClassByRootClassRepository()
{
var ems = NewSession.QueryOver <Employee>().Where(a => a.GetType() == typeof(Teacher)).List();
foreach (var employee in ems)
{
Debug.WriteLine(employee);
}
}
public void SingleTableTestSearchSubClass()
{
var ts = NewSession.QueryOver <Teacher>().List();
foreach (var teacher in ts)
{
Debug.WriteLine(teacher);
}
}
public void ClassTableTestSearchSubClass()
{
var ts = NewSession.QueryOver <Classroom>().List();
foreach (var s in ts)
{
Debug.WriteLine(s);
}
}
public void ConcreteTableTestSearchSubClassByRootClassRepository()
{
var ems = NewSession.QueryOver <Person>().Where(a => a.GetType() == typeof(Student)).List();
foreach (var employee in ems)
{
Debug.WriteLine(employee);
}
}
public void ConcreteTableTestSearchSubClass()
{
var ts = NewSession.QueryOver <Student>().List();
foreach (var s in ts)
{
Debug.WriteLine(s);
}
}
public void TestSearchEmployee()
{
var doors = NewSession.QueryOver <Education>()
.Fetch(a => a.Employee).Eager
.List <Education>();
foreach (var employee in doors)
{
// foreach (var employee in doorKey.Employees)
{
Debug.WriteLine(employee.Employee.GetType() + " ----" + employee.ToString());
}
}
}
public void SingleTableTestSearchSubClassByAssociation()
{
Employee e = null;
var ems = NewSession.QueryOver <DoorKey>()
.JoinAlias(d => d.Employees, () => e)
.Where(() => e.GetType() == typeof(Teacher))
.Select(d => e.Name)
.List <string>();
foreach (var employee in ems)
{
Debug.WriteLine(employee);
}
}
public void TestSearchTeacher()
{
var em = NewSession.QueryOver <Employee>().Where(e => e.Id == t1.Id).SingleOrDefault();
Debug.WriteLine(em.GetType() + "--" + em.ToString());
}
