public async Task MultiPOTest()
{
var connector = Nglib.DATA.CONNECTOR.ConnectorTests.GetDefaultConenctor();
DataPoSampleProvider dataPoSampleProvider = new DataPoSampleProvider(connector);
CollectionPO <DataPoSample> samples = new CollectionPO <DataPoSample>();
for (int i = 0; i < 50; i++)
{
samples.Add(new DataPoSample()
{
Pseudo = "manysamples" + i.ToString()
});
}
await dataPoSampleProvider.InsertPOAsync(samples.ToArray());
foreach (var item in samples)
{
item.Pseudo = "Oi" + item.Pseudo;
}
await dataPoSampleProvider.SavePOAsync(samples.ToArray());
Console.WriteLine(samples.Count);
}
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));
}
