Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where put SQL in DataAccess Class?
Message
 
To
27/01/2004 15:50:54
Del Despain
Colorado Plateau Associates
Hurricane, Utah, United States
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00871117
Message ID:
00871888
Views:
17
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform