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
– Joachim Isaksson, Commented Sep 7, 2012 at 16:58
I'm not quite sure what you're asking, but this may be related to what you want; stackoverflow.com/questions/5068944/… — Joachim Isaksson
– Joachim Isaksson, Commented Sep 7, 2012 at 17:03

Jim Wooley · Accepted Answer · 2012-09-07 17:59:58Z

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 7, 2012 at 17:59

Jim Wooley

10.4k1 gold badge27 silver badges44 bronze badges

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

Comments

Kumar Manish · Accepted Answer · 2012-09-07 19:59:02Z

0

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.

answered Sep 7, 2012 at 19:59

Kumar Manish

3,7923 gold badges40 silver badges43 bronze badges

Collectives™ on Stack Overflow

Connect to different databases using LINQ

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related