Stick to option a.
The connection pooling is your friend.
More Related Contents:
- An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
- in a “using” block is a SqlConnection closed on return or exception?
- Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
- ASP.NET use SqlConnection connect MySQL
- Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
- How to run multiple SQL commands in a single SQL connection?
- SqlCommand with using statement
- Do I have to Close() a SQLConnection before it gets disposed?
- Is it better to execute many sql commands with one connection, or reconnect every time?
- SqlConnection Thread-Safe?
- How can I evaluate a C# expression dynamically?
- What is the simplest method of inter-process communication between 2 C# processes?
- How to get memory available or used in C#
- Accessing Imap in C# [closed]
- Word wrap for a label in Windows Forms
- Mapping object to dictionary and vice versa
- How to format a string as a telephone number in C#
- Configure JSON.NET to ignore DataContract/DataMember attributes
- Using the null-conditional operator on the left-hand side of an assignment
- How does static field initialization work in C#?
- What is the JSON.NET equivalent of XML’s XPath, SelectNodes, SelectSingleNode?
- how to change originating IP in HttpWebRequest
- Getting binary data using SqlDataReader
- Is IDisposable.Dispose() called automatically? [duplicate]
- How to Compare two objects in unit test?
- Newtonsoft.Json deserialize object in Xamarin iOS project
- Can Unity be made to not throw SynchronizationLockException all the time?
- Show detailed Folder Browser from a PropertyGrid
- Get a value of an attribute by XPath and HtmlAgilityPack
- WPF – converting Bitmap to ImageSource