How To Make A Dll As A Connection String Using C#

Question

2.50/5 (2 votes)

See more:

HI Guys

I was just wondering if i can make a dll as a connection string so that i can use in my winform and just add reference in my project and use the dll as a connection string.
so that if the server has change all i need to do is just make a new dll and not go edit the whole program.
Hope u guys get my point.
Please provide with an example or demo project. since im new into c# and making dll.
thanks

Posted 28-Aug-14 19:24pm

Peter_Daly

Updated 28-Aug-14 19:25pm

v2

Add a Solution

Comments

Jameel VM 29-Aug-14 1:38am

wherever you want to pass the connection string in your application,you should specify it.right?

Peter_Daly 29-Aug-14 2:28am

Yes but for example
i have a pc1 and i made the connection string to pc1 from pc2 pc3 and so on
and at a point pc1 had crash and i need to still run the software.
since all the software in pc2,pc3 are all having a connection string to pc1 and now that pc1 has crash so i would definitely get error and my software wont run.
But if i have a dll as a connection string even if pc1 has crash all i need to do is edit the connection string in the dll.
Hope u get my point.

2 solutions

Solution 2

Make new library project with static class Utils.cs

C#

namespace MyProject.Utils
{
   public static class Utils
   {
        public const string ConnectionString = @"Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";
   }
}

then bind this assembly to you project

C#

using MyProject.Utils;

//some code
{
    //some code
    string connString = Utils.ConnectionString;
    //some code
}

hope it's help you

Posted 28-Aug-14 21:43pm

jekin77

Updated 28-Aug-14 22:49pm

v5

Comments

Peter_Daly 30-Aug-14 6:41am

Thanks @john1977 Ur da Man But let me try hope it works :D as i wanted coz by looking to the codes looks like its just wat i need
but a practical test is need :D and i'll let u guys know on the out come of it :D

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mayank Vashishtha · Accepted Answer · 2014-08-28T19:47:00

Solution 1

You have app.Config file available. So instead of using dll (just to get a connection string). Use something like this

How to get Connection String from App.Config in C#[^]

Kindly rate it if it helps.

Posted 28-Aug-14 19:47pm

Mayank Vashishtha

Comments

Peter_Daly 29-Aug-14 2:22am

But after i release my project i wont be able to see app.config
So if i make a dll connection string and my server is change i wont have to go again to the project and edit on the connection string
but what ill need to do is just remake a new dll(which contain a connection string) and enter the new server name and so on.
Hope u get my point

Jameel VM 29-Aug-14 2:31am

Then how you update the connection string when server change? you should update the dll.right?

Peter_Daly 29-Aug-14 2:32am

yes u got my point :) Finally
So is there any way we can do that

Mayank Vashishtha 29-Aug-14 3:30am

Peter, Can you replace the new dll's on server?

Peter_Daly 30-Aug-14 6:40am

Duh.... ill just compile a new dll and replace it lol and wala its easy :D

Mayank Vashishtha 30-Aug-14 7:26am

Then why you can't change the config file, if it's so easy?

Member 13886102 3-Jan-20 13:03pm

Hi i updated sql server from 2005 to 2008 R2. while updating i uninstalled 2005 and reinstalled 2008 R2 so my application is not working. where i have to change connection string and important thing is i dont have app.config file