Dear Techies,
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:
class Customer
{
private:
int CustomerID;
string CustomerName;
List<string> Addresses;
List<Account> accounts;
}
class Account
{
private:
long AccountNumber;
List<Transaction> transactions;
Customer customer;
}
The Tables are defined like:
Table Customer
{
int CustomerID;
string CustomerName;
}
Table CustomerAddress
{
int CustomerID;
int Seqn;
string Address;
}
Table Account
{
long AccountNumber;
int CustomerID;
}
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,
Afsar Ali
Sr. Programmer Analyst,
PIBAS Pakistan (Pvt.) Ltd.
Data Access Layer Strategy.
