Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where put SQL in DataAccess Class?
Message
From
29/01/2004 14:48:45
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:
00871978
Views:
19
Nope, I didn't get it and didn't see it in another thread.

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,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform