How to get list of connection string keywords available in sqlclie

[=?Utf-8?B?UGV0ZXI=?=]

How can I get the list of connection string's keywords available in sqlclient
programmatically? I have found the list in here
http://msdn2.microsoft.com/en-us/lib...ng(vs.80).aspx
but I want to get this list programmatically.

[Armin Zingler]

"Peter" <Pe***@discussions.microsoft.comschrieb

How can I get the list of connection string's keywords available in
sqlclient programmatically? I have found the list in here
http://msdn2.microsoft.com/en-us/lib...ng(vs.80).aspx
but I want to get this list programmatically.

I think it's not possible. At least the provider specific keyword's are
interpreted by the data provider.

But maybe the System.Data.SqlClient.SqlConnectionStringBuilder class helps?
Armin

[=?Utf-8?B?UGV0ZXI=?=]

Hi Armin,

It seems that I can get the list from an instance of
System.Data.SqlClient.ConnectionStringBuilder. Not sure how to get it yet
since I'm not familiar of collections.

"Armin Zingler" wrote:

"Peter" <Pe***@discussions.microsoft.comschrieb

How can I get the list of connection string's keywords available in
sqlclient programmatically? I have found the list in here
http://msdn2.microsoft.com/en-us/lib...ng(vs.80).aspx
but I want to get this list programmatically.

I think it's not possible. At least the provider specific keyword's are
interpreted by the data provider.

But maybe the System.Data.SqlClient.SqlConnectionStringBuilder class helps?
Armin

[Armin Zingler]

"Peter" <Pe***@discussions.microsoft.comschrieb

Hi Armin,

It seems that I can get the list from an instance of
System.Data.SqlClient.ConnectionStringBuilder. Not sure how to get
it yet since I'm not familiar of collections.

"Armin Zingler" wrote:

"Peter" <Pe***@discussions.microsoft.comschrieb

How can I get the list of connection string's keywords available
in sqlclient programmatically? I have found the list in here
http://msdn2.microsoft.com/en-us/lib...ng(vs.80).aspx
but I want to get this list programmatically.

I think it's not possible. At least the provider specific
keyword's are interpreted by the data provider.

But maybe the System.Data.SqlClient.SqlConnectionStringBuilder
class helps?

I didn't think of this class as being a collection like data source, more I
pointed to it because you can browse the available properties/keywords and
explicitly set them "early bound" without the need to fill the values into a
connection string. Though, I had a closer look at it, finding that it
implements IEnumerable, so you can use For Each:

Dim sb As New System.Data.SqlClient.SqlConnectionStringBuilder

sb.ConnectTimeout = 17
sb.DataSource = "test"

For Each pair As KeyValuePair(Of String, Object) In sb
'access the Key and Value propertis of object 'pair'
Next

May I ask why you need this?

Armin

[=?Utf-8?B?UGV0ZXI=?=]

Thanks Armin. I'm thinking about providing administrator of an application
the ability to set some of those keywords and then build the connection
string dynamcially. I can hardcode them instead of retrieving them
programmatically.
I wonder whether those keywords will expand automatically when the
underlying sqlclient provider support more keywords.

Using your sample coding will only fetch those keywords which have values
assigned. If I want to get all the keywords, I need to go thru the
keys.syncroot array and I don't think I can use KeyValuePair to loop thru
them.

Peter

"Armin Zingler" wrote:

"Peter" <Pe***@discussions.microsoft.comschrieb

Hi Armin,

It seems that I can get the list from an instance of
System.Data.SqlClient.ConnectionStringBuilder. Not sure how to get
it yet since I'm not familiar of collections.

"Armin Zingler" wrote:

"Peter" <Pe***@discussions.microsoft.comschrieb
How can I get the list of connection string's keywords available
in sqlclient programmatically? I have found the list in here
http://msdn2.microsoft.com/en-us/lib...ng(vs.80).aspx
but I want to get this list programmatically.
>
I think it's not possible. At least the provider specific
keyword's are interpreted by the data provider.
>
But maybe the System.Data.SqlClient.SqlConnectionStringBuilder
class helps?

I didn't think of this class as being a collection like data source, more I
pointed to it because you can browse the available properties/keywords and
explicitly set them "early bound" without the need to fill the values into a
connection string. Though, I had a closer look at it, finding that it
implements IEnumerable, so you can use For Each:

Dim sb As New System.Data.SqlClient.SqlConnectionStringBuilder

sb.ConnectTimeout = 17
sb.DataSource = "test"

For Each pair As KeyValuePair(Of String, Object) In sb
'access the Key and Value propertis of object 'pair'
Next

May I ask why you need this?

Armin

[Armin Zingler]

"Peter" <Pe***@discussions.microsoft.comschrieb

Thanks Armin. I'm thinking about providing administrator of an
application the ability to set some of those keywords and then build
the connection string dynamcially. I can hardcode them instead of
retrieving them programmatically.
I wonder whether those keywords will expand automatically when the
underlying sqlclient provider support more keywords.

Using your sample coding will only fetch those keywords which have
values assigned. If I want to get all the keywords, I need to go
thru the keys.syncroot array and I don't think I can use
KeyValuePair to loop thru them.

Why don't you put all possible keywords into a list? Has to be done once
only.
Armin