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