How to put string as connection string to app.config?

Question

I want to put my connection string on a USB dongle lock and make my app to read connection string from the lock. But I don't know how to pass the string to ado.net and the connection string placed on app.config.(I'm using ado.net)The following code is my connection string tag:

      <connectionStrings><add name="Db_ReceptionEntities1" connectionString="metadata=res://*/Model.DBReception.csdl|res://*/Model.DBReception.ssdl|res://*/Model.DBReception.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=Db_Reception;user id=sa;password=******;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /></connectionStrings>

Possible duplicate of [Get connection string from App.config](https://stackoverflow.com/questions/6536715/get-connection-string-from-app-config) — ProgrammingLlama, Nov 18 '17 at 07:54
@john I believe they are totally different.I want to pass connection string when a USB is attached.The post you mentioned is about getting connection string!!! — Sina ghasemi zade, Nov 18 '17 at 08:03
That's probably why it says "possible duplicate", don't you think? No need to get angry at people trying to help. — ProgrammingLlama, Nov 18 '17 at 12:05
@john i am not angry at you. I appreciate your attempt to help. — Sina ghasemi zade, Nov 18 '17 at 14:59

score 0 · Answer 1 · answered Nov 18 '17 at 08:06

0

How to put string as connection string to app.config?

You do not need to read from the dongle and put it into app.config. You can just read from the dongle and give the connection string to your context.

Your connection string looks like an EF database first connection string. The DbContext class has a constructor which accepts a connection string name or a full connection string. You can use that and pass the connection string to it.

Create your context like this:

public class StackContext : DbContext
{
    public StackContext(string connection) : base(connection)
    {

    }
}

Then read the connection string from the dongle and pass it to your context like this:

// read from dongle
var connectionString = ...;
var ctx = new StackContext(connectionString);

answered Nov 18 '17 at 08:06

CodingYoshi

25,467
4
62
64

it didn't help.tnx for your answer – Sina ghasemi zade Nov 18 '17 at 09:09
@sinaghasemizade what do you mean it didnt help? – CodingYoshi Nov 18 '17 at 14:40
I 've done it but i dont know how it work. Look at my own answer below. @codingyoshi – Sina ghasemi zade Nov 18 '17 at 14:52
Your answer is doing what the base class will do. You need to pass `x` to the base class like I have shown in my answer but I named it `connection`. It has to work because I have done this many times myself. – CodingYoshi Nov 18 '17 at 14:57

score -1 · Accepted Answer · answered Nov 18 '17 at 09:10

-1

this helped:

   public Db_ReceptionEntities1(string x)
        : base("name=Db_ReceptionEntities1")
    {

        Database.Connection.ConnectionString = x; 
    }

answered Nov 18 '17 at 09:10

Sina ghasemi zade

23
4

How to put string as connection string to app.config?

2 Answers2