J
Jens Weiermann
Hi,
I have a question regarding the handling of connection strings.
I have (finally) written a data access assembly that does all the reading /
writing from/to the database. Basically, this is a Dataset.xsd type thingie
with all the table adapters and stuff.
Now I want to use this data access assembly in all other parts of my
application - windows forms apps, web apps, web services and windows
services. Depending on where these apps are run, the connection string has
to be different (some machines are in the domain so I can use trusted
connections, some are outside so I must use sql authentication), but all of
them connect to the same database. Plus I must be able to change between
development / production databases without changing the source code.
How would I best go about managing these connection strings?
Thanks in advance!
Jens
I have a question regarding the handling of connection strings.
I have (finally) written a data access assembly that does all the reading /
writing from/to the database. Basically, this is a Dataset.xsd type thingie
with all the table adapters and stuff.
Now I want to use this data access assembly in all other parts of my
application - windows forms apps, web apps, web services and windows
services. Depending on where these apps are run, the connection string has
to be different (some machines are in the domain so I can use trusted
connections, some are outside so I must use sql authentication), but all of
them connect to the same database. Plus I must be able to change between
development / production databases without changing the source code.
How would I best go about managing these connection strings?
Thanks in advance!
Jens