Subsonic MSSQL Stored Proc with no parameters
February 9th, 2009
Typically you would call a stored proc using Subsonic using the following.
public DataSet OverallStatus()
{
return SPs.PGetColorCoding().GetDataSet();
}
However, Subsonic has a problem getting the Object class for your stored proc when there are no parameters to pass in. So we just we just convert it to a string doing the following
public DataSet OverallStatus()
{
StoredProcedure sp = SPs.PGetColorCoding();
string dummy = sp.Command.CommandSql;
return sp.GetDataSet();
}
