NHibernate+SQLite 学习笔记（二）+使用FLuent NHibernate 建立会话工厂(session factory) 并对数据库进行操作(open Session）

#region //********************创建一个会话工厂---Create Session Factory*******************//
private void btnCreateSessionFactory_Click(object sender,RoutedEventArgs e)
{
var factory = CreateSessionFactory();
}
private ISessionFactory CreateSessionFactory()
{
//*********************SQL Server************************//
//return Fluently.Configure()
//.Database(MsSqlConfiguration
//.MsSql2012
//.ConnectionString(connString))
//.Mappings(m => m.FluentMappings
//.AddFromAssemblyOf<ProductMap>())
//.BuildSessionFactory();
//*********************SQLite************************//
return Fluently.Configure().Database(SQLiteConfiguration.Standard.UsingFile(datasource))
.Mappings(m => m.FluentMappings
.AddFromAssemblyOf<ProductMap>())
//.ExposeConfiguration(CreateSchema)     ////因为CreateSchema是重新映射了一次数据库，存在这句的时候当对表进行添加数据时永远只有一个值，其他的都会消失，而不存在这句时候则会新增加数据。
.BuildSessionFactory();
}
#endregion

#region //*************************打开会话，对数据库进行操作*********************//
//******************************打开一个会话，不操作****************************//
private void btnCreateSession_Click(object sender,RoutedEventArgs e)
{
var factory = CreateSessionFactory();
using (var session = factory.OpenSession())
{
// do something with the session
}
}

//******************************打开一个会话对数据库进行增操作****************************//
private void btnAddCategory_Click(object sender,RoutedEventArgs e)
{
var factory = CreateSessionFactory();
using (var session = factory.OpenSession())
{
var category = new Category
{
Name = txtCategoryName.Text,
Description = txtCategoryDescription.Text
};
session.Save(category);
}
}

//**************************打开会话对数据库进行查操作************************************//
private void btnLoadCategories_Click(object sender, RoutedEventArgs e)
{
var factory = CreateSessionFactory();
using (var session = factory.OpenSession())
{
var categories = session.Query<Category>()
.OrderBy(c => c.Name).ToList();
lstCategories.ItemsSource = categories;
lstCategories.DisplayMemberPath = "Name";
}
}
#endregion