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

  • 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?



    Tuesday, July 16, 2019 8:57 PM

All replies

  • 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,

    Tuesday, July 16, 2019 9:17 PM