Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Professionals
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 3.5 Professionals If you are an experienced ASP.NET programmer, this is the forum for your 3.5 questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Professionals section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old February 19th, 2009, 02:18 AM
Registered User
 
Join Date: Feb 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data Access Layer Strategy.

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:
  1. What are the Pros & Cons of either of these Strategies?
  2. Should we Combine NHibernate with MSEL?
  3. Should we go for our own designed ORM based strategy with MSEL?
  4. 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.
  #2 (permalink)  
Old February 19th, 2009, 07:58 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

Hello.

Will your application grow or this is the full schema???
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========
  #3 (permalink)  
Old February 19th, 2009, 08:12 AM
Registered User
 
Join Date: Feb 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Will Grow

This is just a sample of schema. Our Schema will certainly grow and more than 20 tables will be there.

Thanks & Regards,
Afsar Ali
Snr. Programmer Analyst
  #4 (permalink)  
Old February 19th, 2009, 08:23 AM
Registered User
 
Join Date: Feb 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Will Grow

This is just a sample of schema. Our Schema will certainly grow and more than 20 tables will be there.

Thanks & Regards,
Afsar Ali
Snr. Programmer Analyst
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Access Layer Question AgentSmith ASP.NET 3.5 Professionals 4 December 16th, 2008 05:49 AM
Handle error from database layer to applican layer khatu_jec ASP.NET 2.0 Basics 1 November 9th, 2008 03:51 PM
Independent Data Access Layer Sumith Asanka .NET Framework 2.0 2 September 28th, 2007 02:20 AM
Design Strategy zoltac007 ASP.NET 1.x and 2.0 Application Design 2 October 3rd, 2006 11:56 AM
Data Abstraction Layer kcraft Pro PHP 6 March 18th, 2006 04:29 PM



All times are GMT -4. The time now is 09:13 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.