Is NHibernate a solution to DAL? Will it be better to use it in database driven web applications like- a shopping cart or so? Actually I m concerned about the logics normally written within stored procedures. What will happen to those logics, do v have to implement them to Bussiness Logic layer?
Hi, I am unable to find and any benefit using stored procedures and calling them in NHibernate. Don't u think NHibernate layer in this case will not be of any use.
I think using using NHibernate to purely call sp's will give you very litte if any benefit for the effort involved. Have you considered using Linq to SQL to call your stored procedures as these make this task very simple.
No I haven't used Linq to SQL. Actually we were told to use NHibernate in a datacentric application where in we are unable to find any benefit of this technology besides the simple DML operations of save, update and delete. I m new to this technology, but it seems as if an extra mapping layer of Object-Relation will make things more complex for complex datastructures (having complex relationships). So question is, why not go with normal ADO approach?
I cannot see the benefit of NHibernate as you say. However Linq to Sql will generate classes to represent your business entities from the stored procs and create methods to call the stored procs. This will save you development time over writing normal ADO.
