Async sql connectivity

Question

Hi I am using wpf with sql server 2012. As I use sqlconnection.open (); it hangs the window till it the connection get established. So to overcome that i want to use Async programming and want to use sqlconnection.openasync (); so that window become reaponsive to user. Kindly anyone suggest me the best snippet to use the async for sql connectivity... and also have a timout of 30 sec to connect or returns fail if not connected. Thanks

Akshay Phadke · Answer

This link will will tell you how to use async in your wpf app http://www.c-sharpcorner.com/UploadFile/47548d/asynchronous-connection-in-net-framework-4-5/ I think you need to put in your connection string asynchronous processing=true;