👁 Image
Simplify.FluentNHibernate 3.3.1

Simplify.FluentNHibernate Documentation

Provides:

• FluentConfiguration class extensions which allow you to easily configure your database connection.
• NHibernate ISession extensions which allow you to write queries with lambda expressions.
• FluentConfiguration extensions for schema management (ExportSchema, UpdateSchema).

Available at NuGet as binary package

Quick Start Example

Configuration through Microsoft.Extensions.Configuration

Session factory setup

namespace MyApp.Database
{
 public class MyDbSessionFactoryBuilder
 {
 private readonly ISessionFactory _instance;

 public ISessionFactory Instance => _instance;

 public MyDbSessionFactoryBuilder(IConfiguration cfg, string configSectionName = "MyDatabaseConnectionSettings")
 {
 var configuration = Fluently.Configure();
 configuration.InitializeFromConfigMsSql(cfg, configSectionName);
 configuration.AddMappingsFromAssemblyOf<MyDbSessionFactoryBuilder>();
 _instance = configuration.BuildSessionFactory();
 }
 }
}

IConfiguration settings example based on appsettings.json

{
 "MyDatabaseConnectionSettings":
 {
 "ServerName": "Server name",
 "DataBaseName": "database name",
 "UserName": "user name",
 "UserPassword": "password"
 }
}

Configuration through *.config files

Session factory setup

namespace MyApp.Database
{
 public class MyDbSessionFactoryBuilder
 {
 private readonly ISessionFactory _instance;

 public ISessionFactory Instance => _instance;

 public MyDbSessionFactoryBuilder(string configSectionName = "MyDatabaseConnectionSettings")
 {
 var configuration = Fluently.Configure();
 configuration.InitializeFromConfigMsSql(configSectionName);
 configuration.AddMappingsFromAssemblyOf<MyDbSessionFactoryBuilder>();
 _instance = configuration.BuildSessionFactory();
 }
 }
}

Configuration file

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <configSections>
 <section name="MyDatabaseConnectionSettings" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" />
 </configSections>

 <MyDatabaseConnectionSettings>
 <add key="ServerName" value="Server name" />
 <add key="DataBaseName" value="database name" />
 <add key="UserName" value="user name" />
 <add key="UserPassword" value="password" />
 </MyDatabaseConnectionSettings>
</configuration>

FluentNHibernate quick setup variants

Additional configuration options

Custom NHibernate configuration

Can be specified via lambda extension, for example, a custom dialect:

configuration.InitializeFromConfigMsSql(configSectionName, c => c.Dialect<MsSql2012Dialect>());

Session lambda extensions for data retrieval

Example

var user = session.GetSingleObject(x => x.Name == "FooName");
var users = session.GetList(x => x.Name.StartsWith("A"));

More examples here