How Force Linq to Sql classes to use connection string from file

Question

I want to put my connection string in a file like .udl, to change connection string from outside project, because i want to put my db to a server.

I use LINQ to SQL Classes and typed dataset, i want those items use a connection string inside a file near the project(like udl), could i do that?

Kirill Shlenskiy · Accepted Answer · 2013-06-02 09:59:30Z

2

LINQ to SQL DataContext has a constructor which accepts a connection string. That connection string is passed on to the provider (see http://msdn.microsoft.com/en-us/library/bb350721.aspx).

You could read the connection string from an arbitrary file and pass it to said constructor when you need to initialize your DataContext object.

answered Jun 2, 2013 at 9:59

Kirill Shlenskiy

9,60730 silver badges41 bronze badges

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

1 Comment

Marc Gravell Over a year ago

Yep, simple and effective. There is also an overload that takes an open connection, which can be useful for injecting more complex scenarios (for example, using mini-profiler, which exists as an ado.net decorator)

Collectives™ on Stack Overflow

How Force Linq to Sql classes to use connection string from file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related