public IEnumerable <IAssemblyData> Dequeue(int batchSize)
{
string text = string.Format("SELECT TOP {0} * FROM T_FEED_QUEUE WHERE F_DATE_STARTED IS NULL ORDER BY F_DATE_CREATED", batchSize);
SqlCommand cmd = Db.GetCommand(text, CommandType.Text);
List <AssemblyData> list = new List <AssemblyData>();
Db.ExecuteDataReader(cmd, dr =>
{
while (dr.Read())
{
list.Add(new AssemblyData()
{
Assembly = AssemblySerializer.GetAssemblyFromByteArray(dr["F_ASSEMBLY"]),
MethodParametersTypes = GetCastedByteArray <Type[]>(dr["F_METHOD_PARAM_TYPES"]),
ConstructorParameters = GetCastedXml <object[]>(dr["F_CONSTRUCTOR_PARAMETERS"]),
MethodParameters = GetCastedXml <object[]>(dr["F_METHOD_PARAMETERS"]),
FullyQualifiedName = Conversions.GetString(dr["F_FULLY_QUALIFIED_CLASS_NAME"]),
Id = Conversions.GetCastValue <Guid>(dr["F_GUID"]),
MethodToRun = Conversions.GetString(dr["F_METHOD_NAME"]),
TimeoutMilliseconds = Conversions.GetCastValue <int>(dr["F_TIMEOUT_MILLISECONDS"])
});
}
});
return(list);
}
private int Enqueue(IAssemblyData[] rows)
{
StringBuilder sb = new StringBuilder();
List <SqlParameter> allParams = new List <SqlParameter>();
string text = @"INSERT INTO T_FEED_QUEUE
(F_GUID, F_STATUS, F_DATE_CREATED, F_TIMEOUT_MILLISECONDS, F_ASSEMBLY, F_METHOD_PARAM_TYPES, F_CONSTRUCTOR_PARAMETERS, F_METHOD_PARAMETERS, F_FULLY_QUALIFIED_CLASS_NAME, F_METHOD_NAME)
VALUES
(@guid{0},0,GETDATE(),@timeoutms{0},@assembly{0},@paramTypes{0},@consParams{0},@methodParams{0},@fullyQName{0},@method{0});" ;
for (int i = 0; i < rows.Length; i++)
{
sb.AppendFormat(text, i);
allParams.Add(Db.GetParam(string.Format("@guid{0}", i), SqlDbType.UniqueIdentifier, rows[i].Id));
allParams.Add(Db.GetParam(string.Format("@timeoutms{0}", i), SqlDbType.Int, rows[i].TimeoutMilliseconds <= 0 ? -1 : rows[i].TimeoutMilliseconds));
allParams.Add(Db.GetParam(string.Format("@assembly{0}", i), SqlDbType.Binary, AssemblySerializer.SerializeAssembly()));
allParams.Add(Db.GetParam(string.Format("@paramTypes{0}", i), SqlDbType.Binary, Serializer.Serialize(rows[i].MethodParametersTypes)));
allParams.Add(Db.GetParam(string.Format("@consParams{0}", i), SqlDbType.Xml, Serializer.XmlSerialize(rows[i].ConstructorParameters)));
allParams.Add(Db.GetParam(string.Format("@methodParams{0}", i), SqlDbType.Xml, Serializer.XmlSerialize(rows[i].MethodParameters)));
allParams.Add(Db.GetParam(string.Format("@fullyQName{0}", i), SqlDbType.VarChar, rows[i].FullyQualifiedName));
allParams.Add(Db.GetParam(string.Format("@method{0}", i), SqlDbType.VarChar, rows[i].MethodToRun));
}
SqlCommand cmd = Db.GetCommand(sb.ToString(), CommandType.Text);
cmd.Parameters.AddRange(allParams.ToArray());
cmd.Connection = Db.GetConnection();
return(Db.ExecuteNonQuery(cmd));
}