Difference between SqlConnection and SqlConnectionStringBuilder

Question

I would like to know what is different between SqlConnection and SqlConnectionStringBuilder

marc_s · Accepted Answer · 2013-11-15 05:42:54Z

7

Apples and Oranges.

SqlConnection actually controls the connection to the database.

SqlConnectionStringBuilder helps to dynamically create the connection string used in the SqlConnection.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection(v=vs.110).aspx

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder(v=vs.110).aspx

edited Nov 15, 2013 at 5:42

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Nov 15, 2013 at 4:43

TyCobb

9,1091 gold badge36 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

senthilkumar2185 · Accepted Answer · 2013-11-15 05:47:49Z

7

SqlConnectionStringBuilder is simple a nifty utility to build/parse/modify a connection string. It's not esssential, and often it's entirely unnecessary.

SqlConnection is the actual database connection. You pass a connection string to it (doesn't matter if it came from a SqlConnectionStringBuilder or not) and you can talk to the database.

edited Nov 15, 2013 at 5:47

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

answered Nov 15, 2013 at 4:58

Brendan Hill

3,8124 gold badges38 silver badges69 bronze badges

Collectives™ on Stack Overflow

Difference between SqlConnection and SqlConnectionStringBuilder

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related