Simplify Database Operations with Generic Fluent NHibernate

Cayen Systems, Kieran Maltz

Rate me:

4.86/5 (6 votes)

30 May 2012CPOL7 min read

75.8K

2.9K

This article describes database communication using a generic Fluent NHibernate implementation.

Sample.FluentNHibernate.zip
- NHibSample.sql
- Sample.FluentNHibernate
  - packages
    - EntityFramework.4.1.10331.0
      - EntityFramework.4.1.10331.0.nupkg
      - lib
        
        EntityFramework.dll
        
        EntityFramework.xml
    - FluentNHibernate.1.3.0.717
      - FluentNHibernate.1.3.0.717.nupkg
      - lib
        
        FluentNHibernate.dll
        
        FluentNHibernate.pdb
    - Iesi.Collections.3.2.0.4000
      - Iesi.Collections.3.2.0.4000.nupkg
      - lib
        
        Net35
        
        Iesi.Collections.dll
        
        Iesi.Collections.xml
    - jQuery.1.5.1
      - Content
        
        Scripts
        
        jquery-1.5.1.js
        
        jquery-1.5.1.min.js
      - jQuery.1.5.1.nupkg
    - jQuery.UI.Combined.1.8.11
      - Content
        
        Content
        
        themes
        
        base
        
        images
        
        ui-bg_flat_0_aaaaaa_40x100.png
        
        ui-bg_flat_75_ffffff_40x100.png
        
        ui-bg_glass_55_fbf9ee_1x400.png
        
        ui-bg_glass_65_ffffff_1x400.png
        
        ui-bg_glass_75_dadada_1x400.png
        
        ui-bg_glass_75_e6e6e6_1x400.png
        
        ui-bg_glass_95_fef1ec_1x400.png
        
        ui-bg_highlight-soft_75_cccccc_1x100.png
        
        ui-icons_222222_256x240.png
        
        ui-icons_2e83ff_256x240.png
        
        ui-icons_454545_256x240.png
        
        ui-icons_888888_256x240.png
        
        ui-icons_cd0a0a_256x240.png
        
        jquery.ui.accordion.css
        
        jquery.ui.all.css
        
        jquery.ui.autocomplete.css
        
        jquery.ui.base.css
        
        jquery.ui.button.css
        
        jquery.ui.core.css
        
        jquery.ui.datepicker.css
        
        jquery.ui.dialog.css
        
        jquery.ui.progressbar.css
        
        jquery.ui.resizable.css
        
        jquery.ui.selectable.css
        
        jquery.ui.slider.css
        
        jquery.ui.tabs.css
        
        jquery.ui.theme.css
        
        Scripts
        
        jquery-ui-1.8.11.js
        
        jquery-ui-1.8.11.min.js
      - jQuery.UI.Combined.1.8.11.nupkg
    - jQuery.Validation.1.8.0
      - Content
        
        Scripts
        
        jquery.validate.js
        
        jquery.validate.min.js
        
        jquery.validate-vsdoc.js
      - jQuery.Validation.1.8.0.nupkg
    - jQuery.vsdoc.1.5.1
      - Content
        
        Scripts
        
        jquery-1.5.1-vsdoc.js
      - jQuery.vsdoc.1.5.1.nupkg
    - Modernizr.1.7
      - Content
        
        Scripts
        
        modernizr-1.7.js
        
        modernizr-1.7.min.js
      - Modernizr.1.7.nupkg
    - NHibernate.3.2.0.4000
      - lib
        
        Net35
        
        NHibernate.dll
        
        NHibernate.license.txt
        
        NHibernate.readme.html
        
        NHibernate.releasenotes.txt
        
        NHibernate.xml
        
        nhibernate-configuration.xsd
        
        nhibernate-mapping.xsd
        
        NHibernateXmlConfigurationTemplates
        
        FireBird.cfg.xml
        
        MSSQL.cfg.xml
        
        MySql.cfg.xml
        
        Oracle.cfg.xml
        
        PostgreSQL.cfg.xml
        
        SQLite.cfg.xml
        
        SybaseASE.cfg.xml
      - NHibernate.3.2.0.4000.nupkg
    - repositories.config
  - Sample.FluentNHibernate.sln
  - Sample.FluentNHibernate.suo
  - Sample.FluentNHibernate.UI
    - App_Data
    - Content
      - Site.css
      - themes
        
        base
        
        images
        
        ui-bg_flat_0_aaaaaa_40x100.png
        
        ui-bg_flat_75_ffffff_40x100.png
        
        ui-bg_glass_55_fbf9ee_1x400.png
        
        ui-bg_glass_65_ffffff_1x400.png
        
        ui-bg_glass_75_dadada_1x400.png
        
        ui-bg_glass_75_e6e6e6_1x400.png
        
        ui-bg_glass_95_fef1ec_1x400.png
        
        ui-bg_highlight-soft_75_cccccc_1x100.png
        
        ui-icons_222222_256x240.png
        
        ui-icons_2e83ff_256x240.png
        
        ui-icons_454545_256x240.png
        
        ui-icons_888888_256x240.png
        
        ui-icons_cd0a0a_256x240.png
        
        jquery.ui.accordion.css
        
        jquery.ui.all.css
        
        jquery.ui.autocomplete.css
        
        jquery.ui.base.css
        
        jquery.ui.button.css
        
        jquery.ui.core.css
        
        jquery.ui.datepicker.css
        
        jquery.ui.dialog.css
        
        jquery.ui.progressbar.css
        
        jquery.ui.resizable.css
        
        jquery.ui.selectable.css
        
        jquery.ui.slider.css
        
        jquery.ui.tabs.css
        
        jquery.ui.theme.css
    - Controllers
      - AccountController.cs
      - HomeController.cs
    - Global.asax
    - Global.asax.cs
    - Models
      - AccountModels.cs
    - obj
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        ResolveAssemblyReference.cache
        
        Sample.FluentNHibernate.UI.csproj.FileListAbsolute.txt
        
        Sample.FluentNHibernate.UI.dll
        
        Sample.FluentNHibernate.UI.pdb
        
        TempPE
    - packages.config
    - Properties
      - AssemblyInfo.cs
    - Sample.FluentNHibernate.UI.csproj
    - Sample.FluentNHibernate.UI.csproj.user
    - Scripts
    - Views
      - _ViewStart.cshtml
      - Account
        
        ChangePassword.cshtml
        
        ChangePasswordSuccess.cshtml
        
        LogOn.cshtml
        
        Register.cshtml
      - Home
        
        About.cshtml
        
        Index.cshtml
      - Shared
        
        _Layout.cshtml
        
        _LogOnPartial.cshtml
        
        Error.cshtml
      - Web.config
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - Sample.FluentNHibernate
    - Database
      - DataManager
        
        FNHRepository.cs
        
        FNHSessionManager.cs
      - Interfaces
        
        IFNHRepository.cs
        
        IFNHSessionManager.cs
    - Domain
      - Mappings
        
        EmployeeMap.cs
        
        RoleMap.cs
        
        TaskMap.cs
      - Objects
        
        Employee.cs
        
        Role.cs
        
        Task.cs
    - obj
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        ResolveAssemblyReference.cache
        
        Sample.FluentNHibernate.csproj.FileListAbsolute.txt
        
        Sample.FluentNHibernate.dll
        
        Sample.FluentNHibernate.pdb
        
        TempPE
    - packages.config
    - Properties
      - AssemblyInfo.cs
    - Sample.FluentNHibernate.csproj

<html>
	<head>
		<title>NHibernate.org - Welcome</title>
	</head>
	<body>
		<h1>Welcome to NHibernate!</h1>
		<hr>
		<p>
			<a href="http://www.nhforge.org/">NHibernate</a> is a .NET based object persistence library for relational databases. 
			NHibernate is a port of the excellent Java <a href="http://www.hibernate.org/">Hibernate</a>
			relational persistence tool.
		</p>
		<p>
			You can find tutorials and samples in the <a href="http://www.nhforge.org/">NHibernate community site</a>
			<a href="http://nhforge.org/wikis/">wiki</a> and <a href="http://nhforge.org/blogs/nhibernate/">blog</a>.
		</p>
		<h2>Latest Version</h2>
		<p>
			Details of the latest version of NHibernate can be found on SourceForge at
			<a href="http://sourceforge.net/projects/nhibernate/">http://sourceforge.net/projects/nhibernate/</a>.
		</p>

		<h2>Documentation</h2>
		<p>
			All available resources on NHibernate can be found online:
			<a href="http://nhibernate.deepgrok.com/">NHibernate deep grok</a>.
		</p>
		<p>
			The reference documentation for NHibernate is available <a
			href="http://nhforge.org/doc/nh/en/index.html">on-line on the website</a>.
		</p>

		<h2>Bug Reports</h2>
		<p>
			If you find any bugs please use the <a href="http://jira.nhforge.org/">JIRA bug tracker</a>.
		</p>

		<h2>Licenses</h2>
		<p>
			This software is distributed under the terms of the FSF Lesser GNU Public License (see lgpl.txt).
		</p>
		
		<p>
			This product uses software developed by the Apache Software Foundation (http://www.apache.org/).
		</p>
		<ul>
			<li>log4net</li>
		</ul>
		
		<p>
			This product includes source code from an article written by Jason Smith.
		</p>
		<ul>
			<li>
				Iesi.Collections - original code can be found at <a href="http://www.codeproject.com/csharp/sets.asp">
					Add Support for "Set" Collections to .NET</a>
			</li>
		</ul>
	</body>
</html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Cayen Systems

Cayen Systems

United States

Cayen Systems develops online data management software for non-profit and education organizations with a team of experienced and dedicated individuals located in Milwaukee, Wisconsin. We provide the most comprehensive software solutions for information management, tracking and data reporting available today. Specializing in developing easy to use and efficient solutions, we consistently help our clients increase their productivity and reduce the costs of program management.

This is a Organisation

21 members

Written By

Kieran Maltz

Software Developer (Senior) Cayen Systems

United States

I am a software engineer based in Milwaukee, Wisconsin. I have been developing software as a hobby since high school and professionally since 2006. I am on a never-ending quest for proper programming principles and clean coding techniques.

Simplify Database Operations with Generic Fluent NHibernate

License

Comments and Discussions