private async Task ExecuteNonQuery(DataSItem temp) { using (frmparamLoad load = new frmparamLoad(_selectedProcedure)) { if (load.ShowDialog() == DialogResult.OK) { if (load.Result != null) { _selectedProcedure = load.Result; lblStatues.Text = "Loading NonQuery procedure "; ExecAsyncResult result = await _selectedProcedure.ExecuteNonQueryAsync(_currentAgent); lblStatues.Text = "Done."; rTxtresult.AppendColorText(result.ToString(), Color.Blue); if (_selectedProcedure.HasOutputParam) { rTxtresult.AppendColorText("Output Params", Color.GreenYellow); foreach (DataParam dataParam in _selectedProcedure.OutputParams.Values) { rTxtresult.AppendColorText(dataParam.Name + " = " + dataParam.Value, Color.Green); } rTxtresult.AppendColorText(new string('-', 30), Color.GreenYellow); } } } } }
static void ModelsGET(DbAgent agent) { DataSItem _selectedProcedure = new DataSItem(); _selectedProcedure.Schema = "auto"; _selectedProcedure.Name = "Models_Get"; DataSet ds = new DataSet(); // _selectedProcedure.FillPRocedureParamsFromSQLAgent(agent); _selectedProcedure.ExecDataSet(agent, out ds); DataTable dt = ds.Tables[0]; foreach (DataRow rw in dt.Rows) { foreach (var s in rw.ItemArray) { Console.Write(s.ToString() + " - "); } Console.WriteLine(); // Console.WriteLine(rw[0].ToString()); } }
private async Task ExecuteDs(DataSItem temp) { using (frmparamLoad load = new frmparamLoad(temp)) { if (load.ShowDialog() == DialogResult.OK) { if (load.Result != null) { _selectedProcedure = load.Result; lblStatues.Text = "Loading dataSetExecution ..."; ExecAsyncResult result = await _selectedProcedure.ExecDataSetAsync(_currentAgent); lblStatues.Text = "Done."; rTxtresult.AppendColorText(result.ToString(), Color.Blue); DataSet rsSet = result.Object as DataSet; if (rsSet.Tables.Count > 0) { dataGridSet.DataSource = rsSet.Tables[0]; } if (_selectedProcedure.HasOutputParam) { rTxtresult.AppendColorText("Output Params", Color.GreenYellow); foreach (DataParam dataParam in _selectedProcedure.OutputParams.Values) { rTxtresult.AppendColorText(dataParam.Name + " = " + dataParam.Value, Color.Green); } rTxtresult.AppendColorText(new string('-', 30), Color.GreenYellow); } } } } }
static async Task ImagesGetAsyncMUltiple(DbAgent agent) { if (agent.ConnectionLevel == ConnectionLevel.AllInOne) { await agent.OpenConnectionAsync(); } DataSItem itm = new DataSItem(); itm.Schema = "general"; itm.Name = "Images_Get"; // itm.AddParam(new DataParam("@path", CustomSqlTypes.String)); itm.AddReturnParam(CustomSqlTypes.Int); // itm.FillPRocedureParamsFromSQLAgent(agent); // itm.Params.Add("@path",new DataParam()); for (int i = 0; i < 1000; i++) { ExecAsyncResult res1 = await itm.ExecuteDataReaderByRefAsync <Img>(agent); IBag <Img> images = res1.Object as IBag <Img>; Console.WriteLine("Item Count : " + images.Objects.Count.ToString() + " " + res1.ToString()); } if (agent.ConnectionLevel == ConnectionLevel.AllInOne) { agent.Dispose(); } }
static async void NewImages(int count, DbAgent agent) { //Images_NewINstance DataSItem itm = new DataSItem { // itm.Schema = "general"; Schema = "dbo", 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 void ImagesGet(int count, DbAgent agent) { //Images_NewINstance DataSItem itm = new DataSItem(); itm.Schema = "general"; itm.Name = "Images_Get"; // 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.ExecuteDataReaderByRefAsync <Img>(agent); IBag <Img> images = res.Object as IBag <Img>; Console.WriteLine("Item Count : " + images.Objects.Count.ToString() + " " + 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(); }
private void lstProcs_SelectedIndexChanged(object sender, EventArgs e) { _selectedProcedure = (lstProcs.SelectedItem as DataSItem); if (lstProcs.Items.Count < 1) { BtnStates(false); } }
static async void ImagesGetAsyncNewTest(DbAgent agent) { if (agent.ConnectionLevel == ConnectionLevel.AllInOne) { await agent.OpenConnectionAsync(); } DataSItem itm = new DataSItem(); itm.Schema = "general"; itm.Name = "Images_Get"; // itm.AddParam(new DataParam("@path", CustomSqlTypes.String)); itm.AddReturnParam(CustomSqlTypes.Int); // itm.FillPRocedureParamsFromSQLAgent(agent); // itm.Params.Add("@path",new DataParam()); List <Task <ExecAsyncResult> > _alltaskst = new List <Task <ExecAsyncResult> >(); for (int i = 0; i < 2; i++) { Task <ExecAsyncResult> t = itm.ExecuteDataReaderByRefAsync <Img>(agent); _alltaskst.Add(t); } while (_alltaskst.Count > 0) { Task <ExecAsyncResult> fintask = await Task.WhenAny(_alltaskst); _alltaskst.Remove(fintask); ExecAsyncResult result = await fintask; IBag <Img> images = result.Object as IBag <Img>; Console.WriteLine("Item Count : " + images.Objects.Count.ToString() + " " + result.ToString()); } // itm.Params["@path"].Value = Guid.NewGuid().ToString(); // Console.WriteLine(string.Format("Starting task {0}", x)); // await Task.Delay(1000); //Thread.Sleep(methodWait); // Console.WriteLine(string.Format("Finishing task {0}", x)); if (agent.ConnectionLevel == ConnectionLevel.AllInOne) { agent.Dispose(); } }
static async Task ReflectionGetAsync(DbAgent agent) { DataSItem itm = new DataSItem(); itm.Schema = "general"; itm.Name = "Images_Get"; // itm.AddParam(new DataParam("@path", CustomSqlTypes.String)); itm.AddReturnParam(CustomSqlTypes.Int); ExecAsyncResult res = await itm.ExecuteDataReaderByRefAsync <Img>(agent); IBag <Img> images = res.Object as IBag <Img>; Console.WriteLine("Item Count : " + images.Objects.Count.ToString() + " " + res.ToString()); }
public static Dictionary <string, DataSItem> GetAllSqlProcedures(DbAgent agent = null) { string source; Dictionary <string, DataSItem> procedures = new Dictionary <string, DataSItem>(); try { if (agent != null) { source = agent.ConnectionString; } else { source = _currentagent.ConnectionString; } using (SqlConnection con = new SqlConnection(source)) { con.Open(); using (SqlCommand cmd = new SqlCommand(_getAllProcedures, con)) { cmd.CommandType = CommandType.Text; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DataSItem proc = new DataSItem(); proc.ConnectionString = "-1"; proc.Schema = reader[0].ToString(); proc.Name = reader[1].ToString(); procedures.Add(proc.Value, proc); } } } } catch (Exception exc) { throw exc; } return(procedures); }
//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); } } } }
static void GetImgsync(DbAgent agent) { DataSItem itm = new DataSItem(); itm.Schema = "general"; itm.Name = "Images_Get"; // itm.AddParam(new DataParam("@path", CustomSqlTypes.String)); itm.AddReturnParam(CustomSqlTypes.Int); IBag <Img> images; ExecResult res = itm.ExecuteDataReaderByRef(agent, out images); foreach (Img img in images.Objects) { Console.WriteLine(string.Format("Id : {0} - Path : {1}", img.Id.ToString(), img.Path)); } Console.WriteLine("Item Count : " + images.Objects.Count.ToString() + " " + res.ToString()); }
private async void btnExecuteDs_Click(object sender, EventArgs e) { try { if (lstProcs.SelectedItems.Count > 0) { _selectedProcedure = (lstProcs.SelectedItem as DataSItem); } DataSItem temp = _selectedProcedure; btnExecuteDs.Enabled = false; await ExecuteDs(temp); btnExecuteDs.Enabled = true; } catch (Exception exc) { rTxtresult.AppendColorText(exc.ToString(), Color.Red); btnExecuteDs.Enabled = true; } }
private void btnOk_Click(object sender, EventArgs e) { try { foreach (Contrl contrl in flowLayoutPanel1.Controls) { if (contrl.HasValue) { _selectedProcedure.Params[contrl.Description].Value = contrl.Body; } else { _selectedProcedure.Params.Remove(contrl.Description); } } _result = _selectedProcedure; this.DialogResult = DialogResult.OK; } catch (Exception exc) { MessageBox.Show(exc.ToString()); } }
static async Task ImagesGigImagesGET(int count, DbAgent agent) { DataSItem itm = new DataSItem(); itm.Schema = "general"; itm.Name = "Images_Get"; // 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() => { Console.WriteLine("Start! "); // itm.Params["@path"].Value = Guid.NewGuid().ToString(); ExecAsyncResult res = await itm.ExecuteDataReaderByRefAsync <Img>(agent); IBag <Img> images = res.Object as IBag <Img>; Console.WriteLine("Item Count : " + images.Objects.Count.ToString() + " " + res.ToString()); }, TaskCreationOptions.LongRunning)); await compleateT; }
public frmparamLoad(DataSItem procedure) { InitializeComponent(); _selectedProcedure = procedure; }
/* * 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(); }