I feel like a bit of an idiot, but I have read all of the forums posts on this subject, but I still haven't figured out how one does this:
Dim x as Dataset = xxxxxxx.ExecuteDataset("select * from some_table")
or
xxxxxxxxx.ExecuteNonQuery("delete from some_table")
I'm hoping to avoid creating my own SQLConnection object (to avoid database specific code), and obviously would like to use the same connection object and support transactions andparameters properly.
SD.LLBLGen.Pro.ORMSupportClasses.DaoBase looks to be the place that contains very close to the functionality I am looking for (except it tends to use datareaders whereas I want to retrieve a dataset), but how to extend this I can't seem to figure out (if this is in fact the correct place).
There seems to be a fair amount of people wanting to do this so it would be really nice if there was a simple way to execute raw SQL via LLBLGen without having to extend the framework.....or at the very least if an extension has to be made that some sort of an all inclusive example could be posted in once place (in my case for self-servicing).
Help!!??