When using .net SqlConnection to connect to the DB, what network protocol does it use to connect the application to the database? I tried googling it and reading the docs but couldn't find anything. Is it HTTP or something else?
The network protocol for SQL Server is the Tabular Data Stream Protocol or TDS, and it runs over TCP/IP, Named Pipes, or (for local connections) Shared Memory.