public byte[] ExecuteNonQuery(Guid instance, byte[] comm, out int ret)
{
SqlCommand cmd = Command(comm);
RemoteSqlInstance sql = Sql(instance);
ret = sql.ExecuteNonQuery(cmd);
return(SqlCommandSerializer.ToByteArray(cmd));
}
public byte[] DeriveParameters(Guid instance, byte[] comm)
{
SqlCommand cmd = Command(comm);
RemoteSqlInstance sql = Sql(instance);
sql.DeriveParameters(cmd);
return(SqlCommandSerializer.ToByteArray(cmd));
}
protected override DbDataReader ExecuteDbDataReader(CommandBehavior behavior)
{
byte[] outcmd;
var ret = m_proxy.ExecuteDbDataReader(Serialize(), behavior, out outcmd);
var cmd = SqlCommandSerializer.FromByteArray(outcmd);
MergePars(cmd.Parameters.Cast <SqlParameter>());
return(ret);
}
public byte[][] ExecuteDbDataReader(Guid instance, byte[] comm, CommandBehavior behavior)
{
SqlCommand cmd = Command(comm);
RemoteSqlInstance sql = Sql(instance);
DataSet ds = sql.ExecuteDbDataReader(cmd, behavior);
var ret = new byte[2][];
ret[0] = Serializer.ToByteArray(ds);
ret[1] = SqlCommandSerializer.ToByteArray(cmd);
return(ret);
}
private SqlParameter[] GetParameters(byte[] buf)
{
SqlCommand com = SqlCommandSerializer.FromByteArray(buf);
return(com.Parameters.Cast <SqlParameter>().Select(c =>
new SqlParameter
{
ParameterName = c.ParameterName,
DbType = c.DbType,
Direction = c.Direction,
Value = c.Value,
Size = c.Size,
IsNullable = c.IsNullable
}
).ToArray());
}
private SqlCommand Command(byte[] comm)
{
return(SqlCommandSerializer.FromByteArray(comm));
}
private byte[] Serialize()
{
return(SqlCommandSerializer.ToByteArray(m_command));
}
