How to get connection string from another project in LINQ to SQL?

Question

I've 3 different projects in one solution. I placed my connection string in first project like this

 <connectionString name="My Connection String">
     <parameters>
     <parameter name="Integrated Security" value="True" />
     <parameter name="server" value=".\SQLEXPRESS" isSensitive="true" />
     <parameter name="database" value="MyDatabase" isSensitive="false" />
     </parameters>
  </connectionString>

Now in another project I make LINQ to SQL class and it generated app.config file and make it's connection string in it? How can I make to read connection string from my exisiting .config file from another project?

you want to get the connection string of one project from another project? You just have to expose it via some class/property — gideon
– gideon, Commented Feb 29, 2012 at 6:49
Can you explain it? I want to change my LINQ to SQL class's connection string to read it from another project's connection string. — Chuck Norris
– Chuck Norris, Commented Feb 29, 2012 at 6:51
is that connectionString setted in a web.config or an app.config file inside your solution? — Luiggi Mendoza
– Luiggi Mendoza, Commented Feb 29, 2012 at 6:54

gideon · Accepted Answer · 2012-02-29 07:00:29Z

4

I'm assuming you're using Application Settings and have a connection string in your FirstProject.

Like this:

enter image description here

The generated Settings class is marked internal sealed partial .. so you can't directly access it via MyProject.Properties.Settings...

You just create a class to expose it:

namespace FirstProject
{
    public class ThisProjectSettings
    {
        public static string ConnectionString
        {
            get
            {
                return Settings.Default.Conn;
            }
        }
    }
}

Then use it from your second project like this:

FirstProject.ThisProjectSettings.ConnectionString

answered Feb 29, 2012 at 7:00

gideon

19.5k11 gold badges74 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chuck Norris Over a year ago

I've thought about this. But in this case, I don't want to add first project's reference to second. I don't think it correct, because first is Backend, and second is UI. They might be independent. So is any better way, to make it more generic. For example, make connection string file for all projects.

gideon Over a year ago

So the UI is not dependant on the backend in any way? You could roll out your own configuration storage mechanism but you should figure out if you really need to do that.

Collectives™ on Stack Overflow

How to get connection string from another project in LINQ to SQL?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related