Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

ConnectionStringBuilder in ADO.Net v2.0 - a Primer

Sushil's WebLog — Thu, 31 Mar 2005 01:22:00 GMT

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

ShadowChaser — Thu, 31 Mar 2005 04:04:00 GMT

GREAT news!!

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

Sahil Malik — Thu, 31 Mar 2005 05:05:00 GMT

I've written a command line utility (for fun), to work with various databases I might want to work with. So I could pass commands like below ..

sqlsh$ connection local
localdb\test\>DataTable dt = select * from customers.
localdb\test\>dt.WriteXml("C:\1.xml")
! (this will put be back to shell mode, so I can jump from db to db)
sqlsh$ notepad c:\1.xml

For the above to work, I have leveraged ConnectionString builder to create any number of connectionstrings and work with them interactively, and then I can jump back n forth between them and work with data at a high speed that SQL Server Management Studio doesn't let me (too heavy an app, but good nonetheless).

KOOL HUH? :-D

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

Sushil Chordia [MS] — Fri, 01 Apr 2005 20:29:00 GMT

Sahil, Its rewarding to see you playing around with ConnectionStringBuilder while building your own shell app. Nice!

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

Greg V — Tue, 05 Apr 2005 17:03:09 GMT

This is a great blog! Keep it going!

One question: Does the Oledb and ODBC ConnectionStringBuilder keep track of all the connection keywords and expose them as properties? This seems a difficult problem, since the connection properties depend on the underlying Provider for Oledb and Driver for ODBC.

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

Sushil Chordia [MS] — Tue, 05 Apr 2005 18:23:19 GMT

Greg, you are right.Not all the properties that are provider(/Driver) specific in OleDb(/ODBC) are part of the ConnectionStringBuilder. Some that are well known for OleDb are part of the builder, like - provider,DataSource,OleDbServices,FileName,PersistSecurityInfo. Since the builder implements IDictionary, for adding addition keyword-value pairs, you can add them as follows:
builder.Add("File Name", "C:\DataFile");

ADO.NET 2's SqlConnectionStringBuilder

John Papa — Tue, 05 Apr 2005 23:17:37 GMT

The ADO.NET team is working on a building an object called&nbsp;SqlConnectionStringBuilder. The object&nbsp;is...

ADO.NET 2.0 Gem

Service Station, by Aaron Skonnard — Thu, 28 Apr 2005 08:28:12 GMT

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

Andres Aguiar — Thu, 28 Apr 2005 21:12:02 GMT

I've seen that when you bind the SqlConnectionStringBuilder to a Property Grid, you get a decent way to ask for the properties to the user.

I wonder if you plan to have a standard Windows Forms control that asks for the basic properties (user/pwd/database/host) and has an 'Advanced' dialog with the bound SqlConnectionStringBuilder, or if we will need to write it ourselves.

Thanks

Andres

re: Primer to ConnectionStringBuilder in ADO.Net v2.0 [Sushil Chordia]

DataWorksBlog — Fri, 29 Apr 2005 18:24:30 GMT

Aaron, Thanks for your comment that you posted on your blog (http://pluralsight.com/blogs/aaron/archive/2005/04/28/7815.aspx)

Andres, We dont have a plan to implement a Windows Forms Control for basic properties. Binding ConnectionStringBuilder to the property grid is the one way, through which you can write this yourself. Thanks for the feedback, though.

Sushil Chordia [MS]

Primer to ConnectionStringBuilder in ADO.Net v2.0

TrackBack — Sat, 11 Jun 2005 08:15:05 GMT

Работа с ConnectionString в ADO.Net 2.0

Gollum's den — Thu, 04 Aug 2005 11:04:38 GMT

C помощью класса SqlConnectionStringBuilder стало еще удобнее работать со строками соединения.
1)
SqlConnectionStringBuilder...

Работа с ConnectionString в ADO.Net 2.0

Gollum's den — Thu, 04 Aug 2005 11:39:02 GMT

C помощью класса SqlConnectionStringBuilder стало еще удобнее работать со строками соединения.
1)
SqlConnectionStringBuilder...

Работа с ConnectionString в ADO.Net 2.0

Gollum's den — Fri, 05 Aug 2005 12:28:11 GMT

Работа с ConnectionString в ADO.Net 2.0

Gollum's den — Fri, 05 Aug 2005 12:29:24 GMT

Primer to EntityConnectionStringBuilder

Zlatko Michailov — Sat, 15 Mar 2008 01:23:45 GMT

Following the spirit of Primer to ConnectionStringBuilder from ADO.NET 2.0, let’s see how the pattern

MCTS 70-561: Conexión a una fuente de datos

SergioTarrillo's RichWeblog — Fri, 21 Mar 2008 11:09:33 GMT

Revisando este tema recién me entero de la existencia de ConnectionStringBuilder , pues recontra útil

MCTS 70-561: Conexion a una fuente de datos

ASP.NET Espanol Blogs — Wed, 26 Mar 2008 19:26:23 GMT

Revisando este tema recién me entero de la existencia de ConnectionStringBuilder , pues recontra útil

Data Access blog Primer to ConnectionStringBuilder in ADO Net v2 0 | Outdoor Ceiling Fans

Sun, 31 May 2009 16:14:16 GMT

PingBack from http://outdoorceilingfansite.info/story.php?id=5156