I have wrote the following method, which I hoped to make the method run faster by executing the tasks in parallel: Unfortunately, I receive the following exception: System.InvalidOperationException: ‘BeginExecuteReader requires an open and available Connection. The connection’s current state is connecting.’ How should I implement it correctly? Answer First things first, executing many commands in parallel against a database will
Tag: asynchronous
Multithreading to load data to SQL tables?
On a weekly basis, I run a Python script that migrates data from a PostgreSQL server to a Teradata server. One table at a time, this script: DROP/CREATEs the Teradata version of the table, pulls the new data from PostgreSQL, saves a copy of the table data as a CSV in a network drive (for business reasons), adds the data
How can I best implement async into my WPF application?
I’m working on a WPF application that runs SQL queries and returns a data grid of the results when pressed. Currently, the structure of my methods as I try to figure out async is as follows: Depending on the query ran, my application can get for anywhere between 30 seconds to 20 minutes. I have a progressbar on my application
ASynchronous Creation of Temp Tables in SQL Server
I’m currently trying to determine possible issues with creating temporary tables from a web application and how SQL Server naturally determines separate sessions. SELECT blabla, lala FROM table INTO #…