Connected mode

Connected mode

In connected mode, the application connects to a database, sends SQL commands to it, and receives the result sets synchronously. The connection remains open until the application explicitly closes it or terminates. While the connection is open, the application can execute multiple SQL commands on the same connection, and the results are immediately available to the application.

In ADO.NET, the "connected mode" refers to a data access model where a connection to a data source is established and kept open throughout the duration of the data access operation.

This approach is useful when the application needs to perform a series of database operations that require multiple round trips to the database, as the open connection avoids the overhead of repeatedly opening and closing the connection.

Let us discuss how to create and read a database in connected mode using ADO.NET