public override string Prepare(string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection();
#if NET_4_5
// FIXME: Passing null or DBNull fails with:
// The incoming tabular data stream (TDS) remote procedure call (RPC) protocol
// stream is incorrect. Parameter 1 ("@Handle"): Data type 0x26 has an invalid
// data length or metadata length.
TdsMetaParameter parm = new TdsMetaParameter("@Handle", "int", -1);
#else
TdsMetaParameter parm = new TdsMetaParameter("@Handle", "int", null);
#endif
parm.Direction = TdsParameterDirection.Output;
parms.Add(parm);
parms.Add(new TdsMetaParameter("@VarDecl", "nvarchar", BuildPreparedParameters()));
parms.Add(new TdsMetaParameter("@Query", "nvarchar", commandText));
ExecProc("sp_prepare", parms, 0, true);
SkipToEnd();
return(OutputParameters[0].ToString());
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}
public SybaseParameter Add(SybaseParameter value)
{
if (value.Container != null)
{
throw new ArgumentException("The SybaseParameter specified in the value parameter is already added to this or another SybaseParameterCollection.");
}
value.Container = this;
list.Add(value);
metaParameters.Add(value.MetaParameter);
return(value);
}
public override void Unprepare(string statementId)
{
TdsMetaParameterCollection parms = new TdsMetaParameterCollection();
parms.Add(new TdsMetaParameter("@P1", "int", Int32.Parse(statementId)));
ExecProc("sp_unprepare", parms, 0, false);
}
public override void ExecPrepared(string commandText, TdsMetaParameterCollection parameters, int timeout, bool wantResults)
{
Parameters = parameters;
// We are connected to a Sql 7.0 server
if (TdsVersion < TdsVersion.tds80 ||
Parameters == null || Parameters.Count < 1)
{
base.ExecPrepared(commandText, parameters, timeout, wantResults);
return;
}
TdsMetaParameterCollection parms = new TdsMetaParameterCollection();
parms.Add(new TdsMetaParameter("@Handle", "int", Int32.Parse(commandText)));
foreach (TdsMetaParameter parm in Parameters)
{
parms.Add(parm);
}
ExecRPC("sp_execute", parms, timeout, wantResults);
}
public override string Prepare(string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection();
TdsMetaParameter parm = new TdsMetaParameter("@Handle", "int", null);
parm.Direction = TdsParameterDirection.Output;
parms.Add(parm);
parms.Add(new TdsMetaParameter("@VarDecl", "nvarchar", BuildPreparedParameters()));
parms.Add(new TdsMetaParameter("@Query", "nvarchar", commandText));
ExecProc("sp_prepare", parms, 0, true);
SkipToEnd();
return(OutputParameters[0].ToString());
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}
public override string Prepare(string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection();
// Tested with MS SQL 2008 RC2 Express and MS SQL 2012 Express:
// You may pass either -1 or 0, but not null as initial value of @Handle,
// which is an output parameter.
TdsMetaParameter parm = new TdsMetaParameter("@Handle", "int", -1);
parm.Direction = TdsParameterDirection.Output;
parms.Add(parm);
parms.Add(new TdsMetaParameter("@VarDecl", "nvarchar", BuildPreparedParameters()));
parms.Add(new TdsMetaParameter("@Query", "nvarchar", commandText));
ExecProc("sp_prepare", parms, 0, true);
SkipToEnd();
return(OutputParameters[0].ToString());
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}
public override void Unprepare (string statementId)
{
TdsMetaParameterCollection parms = new TdsMetaParameterCollection ();
parms.Add (new TdsMetaParameter ("@P1", "int", Int32.Parse (statementId)));
ExecProc ("sp_unprepare", parms, 0, false);
}
public override string Prepare (string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection ();
TdsMetaParameter parm = new TdsMetaParameter ("@Handle", "int", null);
parm.Direction = TdsParameterDirection.Output;
parms.Add (parm);
parms.Add (new TdsMetaParameter ("@VarDecl", "nvarchar", BuildPreparedParameters ()));
parms.Add (new TdsMetaParameter ("@Query", "nvarchar", commandText));
ExecProc ("sp_prepare", parms, 0, true);
SkipToEnd ();
return OutputParameters[0].ToString () ;
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}
public override string Prepare (string commandText, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
TdsMetaParameterCollection parms = new TdsMetaParameterCollection ();
// Tested with MS SQL 2008 RC2 Express and MS SQL 2012 Express:
// You may pass either -1 or 0, but not null as initial value of @Handle,
// which is an output parameter.
TdsMetaParameter parm = new TdsMetaParameter ("@Handle", "int", -1);
parm.Direction = TdsParameterDirection.Output;
parms.Add (parm);
parms.Add (new TdsMetaParameter ("@VarDecl", "nvarchar", BuildPreparedParameters ()));
parms.Add (new TdsMetaParameter ("@Query", "nvarchar", commandText));
ExecProc ("sp_prepare", parms, 0, true);
SkipToEnd ();
return OutputParameters[0].ToString () ;
//if (ColumnValues == null || ColumnValues [0] == null || ColumnValues [0] == DBNull.Value)
// throw new TdsInternalException ();
//return string.Empty;
//return ColumnValues [0].ToString ();
}
