Using Linq to query linked server in Visual Studio

Question

I'm trying to use Linq to run queries against a linked server on our SQL Server machine through Visual Studio.

On the SQL Server, I've successfully created the linked server and can run queries on it. In Visual Studio I've added a new data connection (under Server Explorer) to the SQL Server with success but the linked server tables are not available.

How can I get the linked server tables to show up? Or can I even do this?

Jeff S · Accepted Answer · 2009-08-21 17:57:10Z

5

I usually create a view in a local database for each table I access through a linked server. That allows me to change the links as needed without having to change any SQL. And you should be able to use the view in LINQ to SQL without issue.

answered Aug 21, 2009 at 17:57

Jeff S

7,49432 silver badges32 bronze badges

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

1 Comment

Clint Davis Over a year ago

I accepted this because it's a neat idea I didn't think of. Turns out you cannot link to a linked table in SQL Server. You can reference the table in a SQL Query but it doesn't show up as a table.

Collectives™ on Stack Overflow

Using Linq to query linked server in Visual Studio

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