to sql_connection.Open() or .sql_connection.OpenAsync()?

Question

Hi,

Can someone explain is it better to use sql_connection.Open() or sql_connection.OpenAsync()?

For example in WinForm? Website? Mobile app?

Which one is better for best performance and memory management?

Thanks,

Jassim

Answer 1

OpenAsync is only meaningful if you have something else you want to do while you are waiting for the connection to open.

---

Erland Sommarskog, SQL Server MVP, [e-mail]