I noticed something with SubSonic 2.x that I'm sure others have run into...
Calling a sproc with results = SPs.SpGetCountryList().GetDataSet(); I kept getting a Null reference exception.
To get around this, I added a dummy parameter in my sproc, and called the same function with an irrelevant number - SPs.SpGetCountryList(1).GetDataSet();.
Sure enough, this worked.
Wondering if I missed something in calling sporc's w/o parameters or if anyone else has noticed this?
Thanks.