public Thread TestDbWithThread()
{
var workThread = new Thread(() =>
{
var db = new AdoNet();
using (var conn = db.CreateConnection())
{
var products = db.GetProducts(conn, false);
Thread.Sleep(2000);
var fileName = "test.txt";
using (StreamWriter file = new StreamWriter(fileName))
{
foreach (var product in products)
{
file.WriteLine($"ProductId = {product.Id}\tProduct Name = {product.ProductName}\tPrice = {product.Price}");
}
}
Console.WriteLine($"Writing to file completed. File name = {fileName}");
}
});
workThread.Start();
return(workThread);
}
public async Task TaskTestDbWithAsync()
{
var db = new AdoNet();
using (var conn = await db.CreateConnectionAsync())
{
var products = await db.GetProductsAsync(conn);
var fileName = "test.txt";
using (StreamWriter file = new StreamWriter(fileName))
{
foreach (var product in products)
{
await file.WriteLineAsync($"ProductId = {product.Id}\tProduct Name = {product.ProductName}\tPrice = {product.Price}");
}
}
Console.WriteLine($"Writing to file completed. File name = {fileName}");
}
}