//public int TestAssignPrimaryKeys()
//{
// this.AssignPrimaryKeys();
// return this.Table.PrimaryKey.Length;
//}
//public int TestRemovePrimaryKeys()
//{
// this.RemovePrimaryKeys();
// return this.Table.PrimaryKey.Length;
//}
public void TestParamsWithScale()
{
esParameter myParam = new esParameter("Salary", 12.34);
myParam.DbType = DbType.Decimal;
myParam.Precision = 18;
myParam.Scale = 2;
myParam.Direction = esParameterDirection.InputOutput;
esParameters parms = new esParameters();
parms.Add(myParam);
parms.Add("DepartmentID", 1);
//parms.Add("DepartmentID", null);
parms.Add("FirstName", "Entity");
parms.Add("LastName", "Spaces");
parms.Add("Age", 100);
parms.Add("HireDate", "2000-12-31 00:00:00");
parms.Add("IsActive", false);
this.ExecuteNonQuery(esQueryType.StoredProcedure, "proc_esTestInsert", parms);
}
private void OnMessageReceived(object sender, XDMessageEventArgs e)
{
try
{
esTracePacket entry = new esTracePacket();
string[] fields = e.DataGram.Message.Split('±');
if (fields[0].Length > 0)
{
entry.TransactionId = Convert.ToInt32(fields[0]);
}
if (fields[1].Length > 0)
{
entry.ObjectType = fields[1];
}
entry.CallStack = fields[2];
entry.ApplicationName = fields[3];
entry.TraceChannel = fields[4];
entry.ThreadId = Convert.ToInt32(fields[5]);
entry.Sql = fields[6];
entry.Duration = Convert.ToInt64(fields[7]);
entry.Ticks = Convert.ToInt64(fields[8]);
entry.PacketOrder = Convert.ToInt64(fields[9]);
entry.Action = fields[10];
entry.Syntax = fields[11];
entry.Exception = fields[12];
if (fields[13].Length > 0)
{
// Parse Parameters
string[] parameters = fields[13].Split('«');
esParameter param = null;
for (int i = 0; i < parameters.Length; i += 5)
{
if (param == null) param = new esParameter();
param.Name = parameters[i];
param.Direction = parameters[i + 1];
param.ParamType = parameters[i + 2];
if (parameters[i + 3] != "null")
{
param.BeforeValue = parameters[i + 3];
}
if (parameters[i + 4] != "null")
{
param.AfterValue = parameters[i + 4];
}
entry.SqlParameters.Add(param);
param = null;
}
}
switch (entry.TraceChannel)
{
case Channels.Channel_1: AddEntryToList(channel_1, entry); break;
case Channels.Channel_2: AddEntryToList(channel_2, entry); break;
case Channels.Channel_3: AddEntryToList(channel_3, entry); break;
case Channels.Channel_4: AddEntryToList(channel_4, entry); break;
case Channels.Channel_5: AddEntryToList(channel_5, entry); break;
case Channels.Channel_6: AddEntryToList(channel_6, entry); break;
case Channels.Channel_7: AddEntryToList(channel_7, entry); break;
case Channels.Channel_8: AddEntryToList(channel_8, entry); break;
case Channels.Channel_9: AddEntryToList(channel_9, entry); break;
case Channels.Channel_10: AddEntryToList(channel_10, entry); break;
}
}
catch { }
}
