Obtain a pooled connection : SqlConnection « Database ADO.net « VB.Net

1. VB.Net
2. Database ADO.net
3. SqlConnection

Obtain a pooled connection

  
Imports System
Imports System.Data.SqlClient

    Public Class MainClass
        Public Shared Sub Main()
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;Min Pool Size=5;Max Pool Size=15;Connection Reset=True;Connection Lifetime=600;"
                con.Open()
                con.Close()
            End Using
            Using con As New SqlConnection
                con.ConnectionString = "Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=SSPI;Pooling=False;"
                con.Open()
                con.Close()
            End Using
        End Sub

    End Class

   
    
  

Related examples in the same category

1.	Connection state change event
2.	Info Message Event
3.	Display the information about the connection.
4.	Execute Non Query Example
5.	Parameterized Command Example
6.	Parse the SQL Server connection string and display the component configuration parameters.
7.	SQL Server Online Check