public void ManyToMany()
{
var c = new IndexController {
Session = session,
Cfg = NHWebConsoleSetup.Configuration(),
RawUrl = "/pepe.aspx",
};
var link = c.BuildCollectionLink(typeof(Territory), typeof(Employee), 1);
Console.WriteLine(link);
Assert.IsNotNull(link);
}
public void ExecQuery()
{
var c = new IndexController {
Session = session,
Cfg = NHWebConsoleSetup.Configuration(),
RawUrl = "/pepe.aspx",
};
var model = new Context {
Query = "from System.Object",
QueryType = QueryType.HQL,
ImageFields = new string[0],
};
c.ExecQuery(model);
Assert.IsNotNull(model.Results);
Assert.Greater(model.Results.Count, 0);
foreach (var r in model.Results)
{
foreach (var m in r)
{
Console.WriteLine("{0}: {1}", m.Key, m.Value);
}
}
}
public static void CreateSampleData(string pictureFile)
{
using (var session = NHWebConsoleSetup.OpenSession()) {
var customer = new Customer {
Name = "John Doe",
Title = "CEO",
History = LipsumGenerator.Generate(5),
SomeHtml = LipsumGenerator.GenerateHtml(5),
Picture = pictureFile == null ? null : File.ReadAllBytes(pictureFile),
Address = new Address {
City = "Buenos Aires",
Country = "Argentina",
State = "Buenos Aires",
Street = "El Cuco 123",
}
};
session.Save(customer);
var employee = new Employee {
FirstName = "Employee",
LastName = "of the Month",
Address = new Address {
City = "Düsseldorf",
Country = "Deutschland",
State = "Nordrhein-Westfalen",
Street = "Königsallee 44",
}
};
session.Save(employee);
foreach (var i in Enumerable.Range(1, 100))
{
session.Save(new Employee {
FirstName = "Juan",
LastName = "Perez",
});
}
session.Save(new Order {
Customer = customer,
Employee = employee,
OrderDate = DateTime.Now,
});
session.Save(new Order {
Customer = customer,
Employee = employee,
OrderDate = DateTime.Now.AddMonths(1),
});
session.Save(new Order {
Customer = customer,
Employee = employee,
OrderDate = DateTime.Now.AddDays(1),
});
var territory = new Territory {
Name = "America",
};
session.Save(territory);
employee.Territories = new HashedSet <Territory> {
territory,
};
session.Save(employee);
session.Flush();
}
}
