Connection object question...

[mandelbrot]

Just a quick one here - if I have more than one DatAdapter, can I use the same connection to read data, or do I need to use multiple connections?


Thanks,
Paul.

 

[PlausiblyDamp]

You can use one connection for multiple DataAdapters just fine. The only time this could be a problem is if you are using multiple threads / async methods to run multiple adapters on the same connection at the same time.

 

[mandelbrot]

Thanks, PD - thats what I expected. I must have some bad SQL somewhere, then!