I have a query about the Microsoft's Enterprise Library Data Access Application Block and NHibernate.
We are in the designing phase of our Software of Anti Money Laundering.
The Criteria is as below:
We have Customer Class which contains Account Class in One to Many relationship. The model is as follows: Customer 1->M Accounts
The Classes are defined like:
The Tables are defined like:
We have decided to go for Designing our Data Access Layer either with MSEL or NHibernate. So Can you guide me that:
- What are the Pros & Cons of either of these Strategies?
- Should we Combine NHibernate with MSEL?
- Should we go for our own designed ORM based strategy with MSEL?
- Or some other Strategy from you technical Architect?
Please help me in this regard: which strategy is best? Or provide any other strategy. Please give your rationale as well.
Thanks & Regards,
Sr. Programmer Analyst,
PIBAS Pakistan (Pvt.) Ltd.