nhibernate entities with complex db tables

Question

alt text http://img18.imageshack.us/img18/5668/dbdiagram.jpg

Hi i got a problem as shown at top.an Db desgin used with oracle is shown below.I want to devolop CRUD processeses for the entities that will be generated over this db diagram.I have to use nhiberante and hql queries.In the diagram relations are succeed over relatinal tables(unit-property relation is succeed over unitporperty table e.g) So how can be done the nhibarene entities and CRUD operations over this diagram complexity?

the diagram link is img18.imageshack.us/img18/5668/dbdiagram.jpg — dankyy1
– dankyy1, Commented Apr 14, 2009 at 11:33

Stuart Childs · Accepted Answer · 2009-04-14 14:44:44Z

1

There is nothing overly complex about that diagram, so I'm going to assume that you are new to NHibernate. In that case, I recommend reading the Quick Start Guide and any of the tutorials here.

The basic process is to create .NET classes which represent your database tables and create mapping files so that NHibernate knows about them. NHibernate will take care of creating the connection between your classes and the database so that you can run HQL queries to retrieve objects. Modify/Create objects in your code and then persist the changes to the database with ISession.Save(). The thing to remember is that (in general) you are not doing the CRUD operations, NHibernate is.

CREATE: new MyObject(); followed by session.Save()
UPDATE: MyObject.change(); followed by session.Save()
DELETE: session.Delete(MyObject);

answered Apr 14, 2009 at 14:44

Stuart Childs

3,3251 gold badge22 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Stuart Childs Over a year ago

Yeah, that one is the tutorials list but should probably be high up in that list instead of at the bottom. It's a good resource.

Stefan Steinegger Over a year ago

Correction UPDATE: MyObject.change(); followed by session.Update() or session.SaveOrUpdate()

Stuart Childs Over a year ago

Actually, it doesn't matter. Internally NHibernate converts all Save(), Update() and SaveOrUpdate() calls to firing the OnSaveOrUpdate event on a ISaveOrUpdateEventListener. These functions merely tell NHibernate to persist the object, it handles the rest. IOW, it's personal preference. :)

Collectives™ on Stack Overflow

nhibernate entities with complex db tables

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related