public void TestMethod1() { Nglib.DATA.CONNECTOR.IDataConnector connector = new Nglib.DATA.CONNECTOR.ConnectorGeneric(); connector.SetConnectionString(TestConnectionString, "Npgsql"); connector.QueryCompleted += Connector_QueryCompleted; System.Data.DataTable ret = connector.QueryAsync("SELECT * FROM web_websites WHERE domainname=@p1;", "nuegy.net").GetAwaiter().GetResult(); connector.Query("SELECT * FROM web_websites;"); connector.QueryScalar("SELECT * FROM web_websites;"); connector.Query("SELECT * FROM web_websites;"); }
public async Task PertTest1_pre() { System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch(); int nb = 0; Nglib.DATA.CONNECTOR.IDataConnector connector = new Nglib.DATA.CONNECTOR.ConnectorGeneric(); connector.SetConnectionString(Nglib.DATA.CONNECTOR.ConnectorTests.TestConnectionString, "Npgsql"); connector.QueryCompleted += Connector_QueryCompleted; try { connector.Open(true); System.Data.Common.DbConnection connect = (System.Data.Common.DbConnection)connector.GetDbConnection(); watch.Start(); DataPoSampleProvider provider = new DataPoSampleProvider(connector); Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector)); CollectionPO <DataPoSample> listtest = provider.GetListPO("SELECT * FROM tests"); Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector)); nb = listtest.Count; for (int i = 0; i < 100; i++) { DataPoSample item = provider.GetFirstPO(6); item.Pseudo = "tesperf_po_" + i.ToString(); provider.SavePO(item); i++; } Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector)); await provider.InsertPOAsync(new DataPoSample() { Pseudo = "totu" }); watch.Stop(); } catch (Exception ex) { throw; } finally { connector.Close(); } Console.WriteLine(string.Format("elapsed:{0}ms - nb:{1} executes={2}ms -{3}ms", watch.ElapsedMilliseconds, nb, totalelapsedExecute, totalelapsedConnector)); }
public static Nglib.DATA.CONNECTOR.IDataConnector GetDefaultConenctor() { Nglib.DATA.CONNECTOR.IDataConnector connector = new Nglib.DATA.CONNECTOR.ConnectorGeneric(); connector.SetConnectionString(TestConnectionString, "Npgsql"); return(connector); }