How do I Programmatically change Connection String un LINQ C# Winforms

Question

This question may be redundant, but i could not totally understand how to do this. I need to be able to, when the users Run my Winforms app, can search for the instance of SQL if the previous one are not available. I already have the check for the DB existence, and also made a dialog wich search for all the available instance, and bulding the connection string isn't a problem. The point here is that, I need to be able to everytime the users open the app it loads the CN from a external file, and if the external file doesn't exist or the instance isn't available, i can use the app in another instance (asuming, offcourse, that the required DB is in that Instance). The point is that, i don't know how to Programmatically change Connection String, using LINQ in winforms. Thanks in advance

ichiban · Accepted Answer · 2009-11-05 20:08:14Z

5

You should be to pass the connection string to the DataContext constructor.

var db = new MyDataContext(myconnectionstring);

answered Nov 5, 2009 at 20:08

ichiban

6,2103 gold badges30 silver badges34 bronze badges

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

1 Comment

josecortesp Over a year ago

Thanks... didn't know, but now i DO! First one get the answer check

user6212 · Accepted Answer · 2009-11-05 20:10:02Z

1

var someConnectionString = "This is my connection String";

using (var db = new SomeConcreteDataContext(someConnectionString)){
    //...Do whatever...
}

answered Nov 5, 2009 at 20:10

user6212

Comments

David · Accepted Answer · 2009-11-05 20:10:55Z

0

A DataContext is created per 'unit of work'.

As ichiban says pass the required connection string into the constructor when creating the DC

answered Nov 5, 2009 at 20:10

David

8,7307 gold badges52 silver badges71 bronze badges

Collectives™ on Stack Overflow

How do I Programmatically change Connection String un LINQ C# Winforms

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related