static async void NewImages(int count, DbAgent agent)
{
//Images_NewINstance
DataSItem itm = new DataSItem();
// itm.Schema = "general";
itm.Schema = "dbo";
itm.Name = "Images_NewINstance";
itm.AddParam(new DataParam("@path", CustomSqlTypes.String));
itm.AddReturnParam(CustomSqlTypes.Int);
// itm.FillPRocedureParamsFromSQLAgent(agent);
// itm.Params.Add("@path",new DataParam());
Task compleateT = RunLimitedNumberAtATime(10, Enumerable.Range(1, count), async x =>
Task.Factory.StartNew(async() =>
{
itm.Params["@path"].Value = Guid.NewGuid().ToString();
ExecAsyncResult res = await itm.ExecuteNonQueryAsync(agent);
Console.WriteLine(res.ToString());
// Console.WriteLine(string.Format("Starting task {0}", x));
// await Task.Delay(1000);
//Thread.Sleep(methodWait);
// Console.WriteLine(string.Format("Finishing task {0}", x));
}, TaskCreationOptions.LongRunning));
await compleateT;
}
static async Task NewImagesViaAgent(DbAgent agent)
{
DataSItem itm = new DataSItem
{
// itm.Schema = "general";
Schema = "general",
Name = "Images_NewINstance"
};
itm.AddParam(new DataParam("@path", CustomSqlTypes.String, ParamDirection.Input, Guid.NewGuid().ToString()));
itm.AddReturnParam(CustomSqlTypes.Int);
// itm.Params["@path"].Value = Guid.NewGuid().ToString();
await agent.OpenConnectionAsync();
ExecAsyncResult res = await itm.ExecuteNonQueryAsync(agent);
Console.WriteLine(res.ToString());
itm.Params["@path"].Value = Guid.NewGuid().ToString();
res = await itm.ExecuteNonQueryAsync(agent);
Console.WriteLine(res.ToString());
agent.Dispose();
}
//fill procedure with param and return
public static void FillPRocedureParamsFromSQLAgent(this DataSItem procedure, DbAgent agent = null)
{
string source;
if (agent != null)
{
source = agent.ConnectionString;
}
else
{
source = _currentagent.ConnectionString;
}
using (SqlConnection con = new SqlConnection(source))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(string.Format(_getParamsOFProc, procedure.Name), con))
{
procedure.Params.Clear();
cmd.CommandType = CommandType.Text;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DataParam prm = new DataParam();
prm.Name = reader[0].ToString();
prm.Default = "";
prm.Direction = GetDirection(reader[1].ToString());
prm.Type = GetType(reader[2].ToString());
prm.SetParent(procedure);
procedure.AddParam(prm);
}
}
}
}
/*
* Start !
* First Path : 558278df-28d0-4bb5-82a1-87d2397569fb
* Code : 1 - Execution Time : 224.06 ms
* Compleated : 1256
* Second Path : 67e1ed21-3570-4a64-8647-5b030ea03c40
* Code : 1 - Execution Time : 8.617 ms
*/
static void NewImagesViaAgentSync(DbAgent agent)
{
DataSItem itm = new DataSItem
{
// itm.Schema = "general";
Schema = "general",
Name = "Images_NewINstance"
};
itm.AddParam(new DataParam("@path", CustomSqlTypes.String));
itm.AddReturnParam(CustomSqlTypes.Int);
string first = Guid.NewGuid().ToString();
itm.Params["@path"].Value = first;
Console.WriteLine("First Path : " + first);
// agent.OpenConnection();
//using (agent)
//{
// agent.OpenConnection();
agent.OpenConnection();
ExecResult res = itm.ExecuteNonQuery(agent);
Console.WriteLine(res.ToString());
first = Guid.NewGuid().ToString();
for (int i = 0; i < 25000; i++)
{
first = Guid.NewGuid().ToString();
itm.Params["@path"].Value = first;
Console.WriteLine($"ThreadId : {Thread.CurrentThread.ManagedThreadId.ToString()} Path i : {i.ToString()} : " + first);
res = itm.ExecuteNonQuery(agent);
Console.WriteLine(res.ToString());
}
bool firstfin = false;
Thread t = new Thread(new ThreadStart(delegate
{
for (int i = 0; i < 25000; i++)
{
first = Guid.NewGuid().ToString();
itm.Params["@path"].Value = first;
Console.WriteLine($"ThreadId : {Thread.CurrentThread.ManagedThreadId.ToString()} Path i : {i.ToString()} : " + first);
res = itm.ExecuteNonQuery(agent);
Console.WriteLine(res.ToString());
}
firstfin = true;
}));
bool sec = false;
Thread t2 = new Thread(new ThreadStart(delegate
{
for (int i = 0; i < 25000; i++)
{
first = Guid.NewGuid().ToString();
itm.Params["@path"].Value = first;
Console.WriteLine($"ThreadId : {Thread.CurrentThread.ManagedThreadId.ToString()} Path i : {i.ToString()} : " + first);
res = itm.ExecuteNonQuery(agent);
Console.WriteLine(res.ToString());
}
sec = true;
}));
t.Start();
t2.Start();
while (!(firstfin && sec))
{
if (firstfin && sec)
{
agent.Dispose();
break;
}
}
// agent.CloseConnection();
//itm.Params["@path"].Value = first;
//Console.WriteLine("Second Path : " + first);
//res = itm.ExecuteNonQuery(agent);
//Console.WriteLine(res.ToString());
//}
// agent.Dispose();
}
