How to execute long running SQL query or stored-procedure from .net

SQL Server takes significant time to process (long running SQL statements) which leads to block the execution of your .net code i.e. main UI thread. [More]