SqlConnectionStringBuilder

More Examples of my Inefficiency

Blog By Bob — Thu, 28 Dec 2006 03:13:17 GMT

A coworker of mine saw my magically cool connection string parsing routine the other day and quickly

re: SqlConnectionStringBuilder

William — Wed, 20 Apr 2005 21:13:00 GMT

Hi !
Just a bit help please !
With VB .net 2005 Beta1 I was using this to load my main form:
Dim settings As Configuration.SettingsProviderCollection = System.Configuration.ConfigurationSettings.ConnectionString

and

Dim setting As SqlConnectionStringBuilder = settings.Item("VBXMP3.MySettings.Connection")

With the Beta2 I got a: Connectionstring is not a member of configurationSettings.

have you an idea to workaround this issue ?
Thanx a lot !

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 19:31:00 GMT

True, although from what I've briefly read about MARS it doesn't sound like it will be for everyday use, or perform well, and it will only work with the SqlClient talking to Sql Server. Mostly I was thinking about the object factory functionality. Although I'm looking forward to the ObjectDataSource.

Don't get me started on the sealed classes in the framework.

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 16:38:00 GMT

I guess theoretically we could have written it all ourselves but take for instance MARS - that's a new feature that would be difficult to implement. moreover a lot of the classes are sealed so you can't augment them - you'd be forced to rewrite them from scratch. I'm not sure how you'd write the resultset for SqlMobile -

Yes, basically there's a lot of stuff that is in there that for all practical purposes - we couldn't have written. Technically we probably could have but there's no way you'd want to in most instances.

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 16:33:00 GMT

Is there anything in ASP.NET and ADO.NET 2.0 that we couldn't, or haven't already, written ourselves?

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 03:18:00 GMT

I've written my own such utility - and it's definitely not a Must have feature - but it's cool - definitley makes things easy - without connectionstrings.com I would have been hating life many times over.

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 03:06:00 GMT

Hey Bill/Andy,

In addition to connectionstrings.com, you could always create a .udl file on your desktop, double click it, and then open it in notepad for connectionstring goodness.

But in addition to sb.Encrypt = true as shown above, there's another hella neat way to protect connection strings in your ADO.NET 2.0 applications. The technique will work in November CTP onwards (doesn't work in Beta1) and is described here -- http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/12/20/37936.aspx

- Sahil

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 03:02:00 GMT

Since my dealing with databases is generally sparadic my memory for connection strings is horrible so I use this site:
http://www.connectionstrings.com/

It has come in very handy in the past.

I actually do have an OO wrapper for ODBC connections in C++ but that d@mn string still has to get built somehow. If there were two things I could have for dealing with databases it would be an querybuilder class and a connectionstring building class. I guess I'll just have to sit down and write them when I get a chance. Because the ODBC API is in C not C++ it's no kind of OO at all. But it's easily wrapped luckily.

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 01:22:00 GMT

Looks useful, I hate working with Connection Strings, they really go against the grain. Nice to see an OO approach to the subject!

re: SqlConnectionStringBuilder

William — Tue, 04 Jan 2005 01:22:00 GMT

Hey Bill,

I just got hold of the SQL Server 2005 resource kit and it IS wicked!!

best feature so far, now that i've just installed it, is that it will run on Win XP Pro - yeah baby!

Also not to mention that the server image (win 2003) comes with it pre-installed plus contain a copy of Visual Studio .Net 2005.

If you don't have it already (or if anybody else is looking), you can order it here -> http://msstore.datacom.com.au/sqlbeta