public NorthwindDbFixture()
{
//DataSource=:memory: makes Sqlite use in memory
SessionFactory = NhFactory.CreateNhSessionFactory <SQLiteDialect, MicrosoftDataSqliteDriver> ("DataSource=:memory:");
using (var sr = new StreamReader("build_northwind.sql"))
{
var s = sr.ReadToEnd();
_buildCommands = s.Split(';');
}
}
public static void StartUp(TestContext ctx)
{
Thread.CurrentPrincipal = new GenericPrincipal(new GenericIdentity("Test", string.Empty),
new[]
{
string.Empty
});
_sessionFactory =
NhFactory.CreateNhSessionFactory(ConfigurationManager.ConnectionStrings["NORTHWIND"].ConnectionString, null,
false);
}
static void GetData()
{
using (var sessionFactory =
NhFactory.CreateNhSessionFactory <Oracle10gDialect, OracleManagedDataClientDriver>(Configuration.GetConnectionString("NorthwindDb")))
{
using (var session = sessionFactory.OpenSession())
using (var txn = session.BeginTransaction())
{
var query = session.Query <Product>().Where(o => o.Id > 25).OrderByDescending(o => o.ProductName)
.ToList();
foreach (var item in query.ToList())
{
Console.WriteLine(item.ProductName);
}
txn.Commit();
}
}
}
