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.

I see a couple of ways to possibly handle this, but I think I might be missing the simple approach. Any direction or suggestions would be appreciated.

Thanks!

Del