Published on November 15, 2008
Samnang Chhun (email@example.com) Software Engineer, http://tech.wowkhmer.com
Introduction to Object-Relational Mapping Introduction to NHibernate NHibernate Basics Mapping Inheritance hierarchies Advanced Querying Additional Reading 2
Object-relational mapping (aka ORM, O/RM, and O/R mapping) is a programming technique for converting data between incompatible type systems in relational databases and object-oriented programming languages (Wikipedia) Objects are hierarchical Databases are relational ORM Objects Relational 4
Performance or Scalability Productivity: less code to write/maintain Abstraction: transient to different DB technologies Simplification and Consistency Quality: depending on the product 5
ADO.NET Entity Framework (released with .NET 3.5 SP1) Business Logic Toolkit for .NET Castle ActiveRecord IBatis.Net LightSpeed Linq (Language Integrated Query) LLBLGen LLBLGen Pro NHibernate Neo …etc 6
Initially developed for Java created in late 2001 by Gavin King absorbed by the JBoss Group / Red Hat Ported to .NET 1.1, 2.0, 3.5 Resulting product called “NHibernate” All popular databases supported Oracle, SQL Server, DB2, SQLite, PostgreSQL, MySQL, Sybase, Firebird, … XML-based configuration files Good community support Free/open source - NHibernate is licensed under the LGPL (Lesser GNU Public License) 8
ISessionFactory One per database (or application) Expensive to create Reads configuration ISession Portal to the database Saves, retrieves ITransaction Encapsulates database transactions SessionFactory Session Transaction 10
<class> declare a persistent class <id> defines the mapping from that property to the primary key column Specifies strategy <property> declares a persistent property of the class <component> maps properties of a child object to columns of the table of a parent class. Associations One-to-Many Many-to-One Many-to-Many One-to-One (uncommon) 13
Element Description .NET Type <set> An unordered collection Iesi.Collections.ISet that does not allow Iesi.Collections.Generic.ISet<T> duplicates. <list> An ordered collection that System.Collections.IList allows duplicates System.Collections.Generic.IList<T> <bag> An unordered collection System.Collections.IList that allow duplicatd System.Collections.Generic.IList<T> 14
<class name=quot;Animalquot;> <id name=quot;Idquot;> <generator class=quot;nativequot; /> </id> <discriminator column=quot;AnimalTypequot; length=quot;5quot; /> <property name=quot;Namequot; /> <subclass name=quot;Dogquot; discriminator-value=quot;Dogquot;> <property name=quot;Breedquot; /> </subclass> <subclass name=“Frogquot; discriminator-value=“Frogquot;> <property name=“TongueLengthquot; /> </subclass> </class> 16
Pros Simple approach Easy to add new classes, you just need to add new columns for the additional data Data access is fast because the data is in one table Ad-hoc reporting is very easy because all of the data is found in one table. Cons Coupling within the class hierarchy is increased because all classes are directly coupled to the same table. A change in one class can affect the table which can then affect the other classes in the hierarchy Space potentially wasted in the database Table can grow quickly for large hierarchies. 17
<class name=quot;Animalquot;> <id name=quot;Idquot;> <generator class=quot;nativequot; /> </id> <property name=quot;Namequot; /> <joined-subclass name=quot;Dogquot;> <key column=quot;Idquot; /> <property name=quot;Breedquot; /> </joined-subclass> <joined-subclass name=quot;Frogquot;> <key column=quot;Idquot; /> <property name=quot;TongueLengthquot; /> </joined-subclass> </class> 18
Pros Easy to understand because of the one-to-one mapping Very easy to modify superclasses and add new subclasses as you merely need to modify/add one table Data size grows in direct proportion to growth in the number of objects. Cons There are many tables in the database, one for every class (plus tables to maintain relationships) Potentially takes longer to read and write data using this technique because you need to access multiple tables Ad-hoc reporting on your database is difficult, unless you add views to simulate the desired tables. 19
<class name=quot;Frogquot;> <id name=quot;Idquot;> <generator class=quot;nativequot; /> </id> <property name=quot;Namequot; /> <property name=quot;TongueLengthquot; /> </class> <class name=quot;Dogquot;> <id name=quot;Idquot;> <generator class=quot;nativequot; /> </id> <property name=quot;Namequot; /> <property name=quot;Breedquot; /> </class> 20
Pros Easy to do ad-hoc reporting as all the data you need about a single class is stored in only one table Good performance to access a single object’s data. Cons When you modify a class you need to modify its table and the table of any of its subclasses. 21
Object oriented querying Increase compile-time syntax-checking Easy to write Hard to read ICriteria crit = sess.CreateCriteria(typeof(Cat)); crit.SetMaxResults(50); List topCats = crit.List(); IList cats = sess.CreateCriteria(typeof(Cat)) .Add( Restrictions.Like(quot;Namequot;, quot;Fritz%quot;)) .Add( Restrictions.Between(quot;Weightquot;, minWeight, maxWeight)) .List(); 24
String based querying Object-Oriented SQL Similar to SQL Speak in terms of objects Case sensitive Very flexible Zero compile-time syntax-checking • from Customer c where c.Name like :name • select count(*) from Customer c 25
Powerful way to (simply) return a group of like objects from the DB. Wonderfully simple to work with Great way to quickly process a “…where A=<something> and B=<something> and C=<something>…” Cat cat = new Cat(); cat.Sex = 'F'; cat.Color = Color.Black; List results = session.CreateCriteria(typeof(Cat)) .Add( Example.Create(cat) ) .List(); 26
You can submit SQL statements to NHibernate if the other methods of querying a database do not fit your needs utilize database specific features • sess.CreateSQLQuery(quot;SELECT * FROM CATSquot;) .AddScalar(quot;IDquot;, NHibernateUtil.Int32) .AddScalar(quot;NAMEquot;, NHibernateUtil.String) .AddScalar(quot;BIRTHDATEquot;, NHibernateUtil.Date); • sess.CreateSQLQuery(quot;SELECT * FROM CATSquot;) .AddEntity(typeof(Cat)); 27
Nhibernate.Contrib Mapping.Attributes Cache Search Validator Burrow LINQ to NHibernate Shards Fluent Interface to NHibernate 30
http://en.wikipedia.org/wiki/Object-relational_mapping NHibernate in Action NHibernate Reference Documentation 1.2.0 http://code.google.com/p/sharp-architecture/ http://www.codeproject.com/KB/database/Nhibernate_M ade_Simple.aspx http://www.codeproject.com/KB/architecture/NHibernate BestPractices.aspx www.hibernate.org NHibernate FAQ Summer of NHibernate 31
This article is about the .NET and Mono library. ... solution for the Microsoft .NET platform. ... NHibernate is free ...
... (ORM) tool for the .Net platform ... available for .Net however NHibernate seems to have a lot ... for NHibernate; Use a simple web form to ...
NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database.
The official NHibernate community site. Download NHibernate. Read blogs. Contribute to the NHibernate Wiki. Find reference documentation.
ABCs of NHibernate, ... (ORM) solution for the .NET Platform. ... It's primary feature is mapping from .NET classes to database tables and from CLR data ...
.NET Persisrence API offers a veriaty of features that covers every aspect of ORM and persistence. ... in the .NET platform under the name 'NHibernate'. ...
Try NHibernate as a great ORM ... a matter of time before Hibernate was ported to .NET and thus NHibernate was born. ... Merges for Multiple Platforms;
... 1065-4c56-bd12-e95f5a545a02/the-best-orm-for-net Question 34 3/14/2006 11 ... NHibernate and LLBLGen Pro was also ... the best ORM for .net.