Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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}");
            }
        }