Connect to different databases using LINQ

Question

I need write simple util, which will connect to different databases. It'll be good to use LINQ. How can I create custom connection using LINQ? For example, there'll be form with 4 textboxes: server, database name, login and password. And I need create connection string with this params.

I know how can I do it via ADO, but I need use LINQ.

P.S. LINQ to SQL.

LinqToAnythingInparticular? LinqToSQL or LinqToEntities comes to mind. — Joachim Isaksson, Sep 07 '12 at 16:58
I'm not quite sure what you're asking, but this may be related to what you want; http://stackoverflow.com/questions/5068944/linq-to-sql-connectionstring — Joachim Isaksson, Sep 07 '12 at 17:03

score 0 · Answer 1 · answered Sep 07 '12 at 17:59

0

You can use the SqlConnectionStringBuilder to build a connection string from your inputs and then pass that to the constructor of your DataContext.

answered Sep 07 '12 at 17:59

Jim Wooley

10,169
1
25
43

score 0 · Answer 2 · answered Sep 07 '12 at 19:59

The SqlConnectionStringBuilder performs checks for valid key/value pairs. Therefore, you cannot use this class to create invalid connection strings; trying to add invalid pairs will throw an exception. The class maintains a fixed collection of synonyms and can translate from a synonym to the corresponding well-known key name.

Connect to different databases using LINQ

2 Answers2