Multiple Connection Strings for Multiple Dlls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msnews.microsoft.com - 19 Mar 2008 08:22 GMT

Hi!

I am facing a small problem.
Actually i have a solution having around 5 Dll Projects. Each dll project is
named as Project1.DAO, Project2.DAO ......

Now i have a connectionstring each of the project which is named as :-
Project1.DAO.ConnectionString
Project2.DAO.ConnectionString

which are accessing the same database.

The Problem i am facing is.. when i reference these dll's from a exe project
i have to add all the COnnection string into the exeprojects app.config.
whihc is a lot of redundant info as all the connection string values are
same.

Please suggest a solution

Reply to this Message

Paul O'Flaherty - 19 Mar 2008 14:04 GMT

Hi

Have you thought about using an xml file to hold the connection string. If
the xml file is installed in the same path as the dll's you can access this
xml using:

StrAssemblyLocation = Me.GetType().Assembly.Location
StrPathToSettingsFile = Left(StrAssemblyLocation,
InStrRev(StrAssemblyLocation, "\"))

You could then read this file to get the connection string.

Have a look at this article about using serialization to do this exact thing
http://www.codeproject.com/KB/cs/ReadWriteConfig.aspx?df=100&forumid=308512&exp=
0&select=1511421

> Hi!
>
[quoted text clipped - 14 lines]
>
> Please suggest a solution

Reply to this Message

Rate this thread:

Multiple Connection Strings for Multiple Dlls

Free Magazines