CommandBuilder Cursor Leaks when using Factory Classes *HELP*
Using conn As Oracle.DataAccess.Client.OracleConnection = New Oracle.DataAccess.Client.OracleConnection
conn.ConnectionString = connectionString
conn.Open()
For i As Integer = 0 To 1000
Using cmd As Oracle.DataAccess.Client.OracleCommand = conn.CreateCommand
cmd.Connection = conn
cmd.CommandText = "SELECT * FROM TESTER WHERE ID = " & i
Using da As Oracle.DataAccess.Client.OracleDataAdapter = New Oracle.DataAccess.Client.OracleDataAdapter
da.SelectCommand = cmd
Using cb As DbCommandBuilder = New Oracle.DataAccess.Client.OracleCommandBuilder
cb.DataAdapter = da