static void Main(string[] args) { var clientManager = new BasicRedisClientManager("localhost:6379"); using (var client = clientManager.GetClient()) { client.FlushDb(); } RedisCacheProvider.SetClientManager(clientManager); // ClientManager = new BasicRedisClientManager(ValidHost); //Redis = ClientManager.GetClient(); //Redis.FlushDb(); using (var session = NHibernateSessionFactory.OpenSession()) { using (var transaction = session.BeginTransaction()) { var DepartmentObject = new Department { Name = "IT", PhoneNumber = "962788700227" }; session.Save(DepartmentObject); transaction.Commit(); Console.WriteLine("Department Created: " + DepartmentObject.Name); Console.ReadLine(); Department departmentAlias = null; var query = session.QueryOver <Employee>() .JoinAlias(x => x.EmployeeDepartment, () => departmentAlias, JoinType.LeftOuterJoin).Cacheable(); var c = query.List(); var d = query.List(); Console.WriteLine("Employee Listed: " + query.SingleOrDefault().FirstName); Console.ReadLine(); } } using (var session = NHibernateSessionFactory.OpenSession()) { using (var transaction = session.BeginTransaction()) { Department departmentAlias = null; var query = session.QueryOver <Employee>() .JoinAlias(x => x.EmployeeDepartment, () => departmentAlias, JoinType.LeftOuterJoin).Cacheable(); var c = query.List(); var d = query.List(); Console.WriteLine("Employee Listed: " + query.SingleOrDefault().FirstName); Console.ReadLine(); } } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RegisterGlobalFilters(GlobalFilters.Filters); RegisterRoutes(RouteTable.Routes); var clientManager = new BasicRedisClientManager("localhost:6379"); using (var client = clientManager.GetClient()) { client.FlushDb(); } RedisCacheProvider.SetClientManager(clientManager); var dbFile = HttpContext.Current.Server.MapPath("~/App_Data/sample.db"); if (File.Exists(dbFile)) { File.Delete(dbFile); } var configuration = Fluently.Configure() .Database( SQLiteConfiguration.Standard.UsingFile(dbFile) ) .Mappings(m => { m.FluentMappings.Add(typeof(BlogPostMapping)); }) .ExposeConfiguration(cfg => { cfg.SetProperty(NHibernate.Cfg.Environment.GenerateStatistics, "true"); }) .Cache(c => { c.UseQueryCache().UseSecondLevelCache().ProviderClass <RedisCacheProvider>(); }) .BuildConfiguration(); new SchemaExport(configuration).Create(false, true); SessionFactory = configuration.BuildSessionFactory(); }