public void CanReadStoredProcedureSchema()
{
string procedure = "sp_Report_Agent_Wity_Listing";
var dataProvider = new DataProvider(connection, procedure);
var sqlParms = dataProvider.ReadStoreProcedureSchema(procedure)
.Parameters;
Assert.AreEqual(4, sqlParms.Count);
}