Hello, I am using DbMetal with the --sprocs option to generate methods from Stored Procedures but I see that this returns DataSets and not Linq objects. I have found this workaround:
http://groups.google.com/group/dblinq/browse_thread/thread/100b87265520b820/8163163aaf04b3e8 which suggests calling the SP with ExecuteQuery<T> and set T to the desired return type. Unfortunately in this case the DataReader is still open when looping through the results so making additional database calls is not possible. There is also a method here http://groups.google.com/group/dblinq/browse_thread/thread/2f3c88b8863f729a/00f39486317e597f which uses reflection to make this cast for each row but seems like a roundabout and undesirable way to accomplish this. Am I missing something here? Is there any possible way to accomplish getting all results in an in-memory array of strongly typed objects, even if I need to specify the object/shape to use?
-- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
