Using a Linq-To-SQL class automagically generates the connection string for me; is there a way to manually set it?

Question

I'm just beginning to use Linq-to-SQL and it's just wonderful to use. The problem is, this software is going to be run on a lot of machines and each machine will have a unique connection string.

Is there a way for me to manually set the connection the Linq-to-SQL (.dbml) uses?

The way I'm doing things now is creating the .dbml file, and in the graphic designer I'm dragging tables from the Server Explorer to the white board of the .dbml.

Justin Niessner · Accepted Answer · 2010-06-17 15:31:06Z

6

Yes. Just pass the connection string you want to use to the DataContext constructor:

MyDbContext _context = MyDbContext(connString);

answered Jun 17, 2010 at 15:31

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

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

2 Comments

Sergio Tapia Over a year ago

This is so great! What would happen is the .dbml recieves a connection string, but a table in the database has 2 more fields than it was expecting. What would occur?

Justin Niessner Over a year ago

@Sergio Tapia - LINQ to SQL would just ignore the extra columns.

Collectives™ on Stack Overflow

Using a Linq-To-SQL class automagically generates the connection string for me; is there a way to manually set it?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related