public override void ExecProc (string commandText, TdsMetaParameterCollection parameters, int timeout, bool wantResults)
{
Parameters = parameters;
ExecuteQuery (BuildProcedureCall (commandText), timeout, wantResults);
}
public override string Prepare (string sql, TdsMetaParameterCollection parameters)
{
Parameters = parameters;
Random rand = new Random ();
StringBuilder idBuilder = new StringBuilder ();
for (int i = 0; i < 25; i += 1)
idBuilder.Append ((char) (rand.Next (26) + 65));
string id = idBuilder.ToString ();
//StringBuilder declare = new StringBuilder ();
sql = String.Format ("create proc {0} as\n{1}", id, sql);
short len = (short) ((id.Length) + sql.Length + 5);
Comm.StartPacket (TdsPacketType.Normal);
Comm.Append ((byte) TdsPacketSubType.Dynamic);
Comm.Append (len);
Comm.Append ((byte) 0x1); // PREPARE
Comm.Append ((byte) 0x0); // UNUSED
Comm.Append ((byte) id.Length);
Comm.Append (id);
Comm.Append ((short) sql.Length);
Comm.Append (sql);
Comm.SendPacket ();
MoreResults = true;
SkipToEnd ();
return id;
}
public override void ExecPrepared (string id, TdsMetaParameterCollection parameters, int timeout, bool wantResults)
{
Parameters = parameters;
bool hasParameters = (Parameters != null && Parameters.Count > 0);
Comm.StartPacket (TdsPacketType.Normal);
Comm.Append ((byte) TdsPacketSubType.Dynamic);
Comm.Append ((short) (id.Length + 5));
Comm.Append ((byte) 0x02); // TDS_DYN_EXEC
Comm.Append ((byte) (hasParameters ? 0x01 : 0x00));
Comm.Append ((byte) id.Length);
Comm.Append (id);
Comm.Append ((short) 0);
if (hasParameters) {
SendParamFormat ();
SendParams ();
}
MoreResults = true;
Comm.SendPacket ();
CheckForData (timeout);
if (!wantResults)
SkipToEnd ();
}
public override void Execute (string sql, TdsMetaParameterCollection parameters, int timeout, bool wantResults)
{
Parameters = parameters;
string ex = BuildExec (sql);
ExecuteQuery (ex, timeout, wantResults);
}
internal SybaseParameterCollection (SybaseCommand command)
{
this.command = command;
metaParameters = new TdsMetaParameterCollection ();
}
internal SqlParameterCollection (SqlCommand command)
{
this.command = command;
metaParameters = new TdsMetaParameterCollection ();
}
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 void Execute (string commandText, TdsMetaParameterCollection parameters, int timeout, bool wantResults)
{
// We are connected to a Sql 7.0 server
if (TdsVersion < TdsVersion.tds80) {
base.Execute (commandText, parameters, timeout, wantResults);
return;
}
Parameters = parameters;
string sql = commandText;
if (Parameters != null && Parameters.Count > 0) {
ExecRPC (TdsRpcProcId.ExecuteSql, commandText, parameters, timeout, wantResults);
} else {
if (wantResults)
sql = BuildExec (commandText);
ExecuteQuery (sql, timeout, wantResults);
}
}
internal TdsParameterCollection (TdsCommand command)
{
this.command = command;
metaParameters = new TdsMetaParameterCollection ();
}
