I've been playing around with the DataBasics data access trying to get a complex query to return a result set. The ExecuteStoredProcedure method returns an object, which cannot be converted to a DataSet (or can it?). So I can't use that method. The query is complex enough, that I don't feel comfortable using BO's.



The crux of the issue, is that I don't want to put connection strings in my code (one of the main reasons for getting StrataFrame in the first place). I could do that but then I'm making a custom copy of the connection code even though it already exists.



That being said, the other method I was looking at was the GetDataSet method, which requires a SQLCommand variable populated with the connection string. My question is, can I get the connection string from StrataFrame and put it into that variable?



Thanks,

Doug.