internal void DeriveParameters ()
{
if (commandType != CommandType.StoredProcedure)
throw new InvalidOperationException (String.Format ("SybaseCommand DeriveParameters only supports CommandType.StoredProcedure, not CommandType.{0}", commandType));
ValidateCommand ("DeriveParameters");
SybaseParameterCollection localParameters = new SybaseParameterCollection (this);
localParameters.Add ("@P1", SybaseType.NVarChar, commandText.Length).Value = commandText;
string sql = "sp_procedure_params_rowset";
Connection.Tds.ExecProc (sql, localParameters.MetaParameters, 0, true);
SybaseDataReader reader = new SybaseDataReader (this);
parameters.Clear ();
object[] dbValues = new object[reader.FieldCount];
while (reader.Read ()) {
reader.GetValues (dbValues);
parameters.Add (new SybaseParameter (dbValues));
}
reader.Close ();
}
void Close ()
{
if (transaction != null && transaction.IsOpen)
transaction.Rollback ();
if (dataReader != null) {
if(tds != null) tds.SkipToEnd ();
dataReader = null;
}
if (tds != null && tds.IsConnected) {
if (pooling && tds.Pooling) {
if(pool != null) pool.ReleaseConnection (tds);
}else
if(tds != null) tds.Disconnect ();
}
if (tds != null) {
tds.TdsErrorMessage -= new TdsInternalErrorMessageEventHandler (ErrorHandler);
tds.TdsInfoMessage -= new TdsInternalInfoMessageEventHandler (MessageHandler);
}
ChangeState (ConnectionState.Closed);
}
