Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Where put SQL in DataAccess Class?
Message
 
À
27/01/2004 15:50:54
Del Despain
Colorado Plateau Associates
Hurricane, Utah, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
00871117
Message ID:
00871888
Vues:
18
Del,

I actually answered this one the other day, but I don't see my response...did you get it?

>For simplicity, MM jump start applications/examples have the business objects send SQL statements to the data access class for execution, such as with calls to GetDataSet(). However, if I have multiple custom data access classes for a business object (one for each backend database supported), where is it recommended that I put code for selecting and generating the appropriate SQL statements?
>
>I assume that each data access class should stand on its own and generate the needed SQL statements. Not only might there be more than one backend, but the query statments may vary depending on various parameters/needs, which means the business object will have to inform the data access class with various parameters, etc. what is needed.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform