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);
}
