From what I've read about the NHibernate product, I'm somewhat encouraged that perhaps I've found a solution to a certain web aplication development challenge.
I want to use the AJAX ReorderList control. The control allows a user to reorder a list on a web page. The list items are stored in a MS SQL Server table which has a "Priority" column. Each list item has a priority number. For example, the database table might look like.
ItemID *** ItemDescription *** Priority
1 *** IPod *** 1
2 *** XBox *** 2
3 *** Nike Shoes *** 3
4 *** Dell PC *** 4
When placed on a web page, the ReorderList control will display the list items and allow the user to 'grab' any one list item with his/her mouse and move the item(s) into a different spot within the list. As each item is grabbed via a left mouse click and hold and then dropped into a different spot by letting go of the mouse button, a database update event is fired, assigning a different Priority number to the list items.
I am hoping that NHibernate can help me reduce the number of database update events.
In my ideal scenario, the user would spend time reordering his/her list and then, when the reordering was completed, an event would fire that would do the updates. Can NHibernate help me do something like this?
See the control at work:
http://www.lowfatcow.com/SQLServerReorder.aspx
Regards,
John Happy III
Spokane, WA
john@johnhappy.com