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