tags:

views:

339

answers:

1
+1  Q: 

Using Linq to query linked server in Visual Studio

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?

+3  A: 

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.

Jeff Siver  2009-08-21 17:57:10
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.
Clint Davis  2010-03-22 17:34:48

related questions

How to find an implementation of a C# interface in the current assembly with a specific name?
Learning about LINQ
LINQ to SQL Mapping From Money to Double
SQL Server 2008 vs 2005 Linq integration
Aging Data Structure in C#
LINQ-to-SQL vs stored procedures?
LINQ, entity that implements Interface and exception in mapping
How can I remove nodes from a SiteMapNodeCollection?
Conditional Linq Queries
LINQ query on a DataTable
Expression.Invoke in Entity Framework?
How to return a page of results from SQL?
Import Namespace System.Query
Has anyone run performance benchmarks comparing LINQ
Beginners Guide to LINQ
Querying like Linq when you don't have Linq.
Linq to objects - select first object
C# 3.0 Where extension method with lambda vs LINQtoObjects to filter in memory collections.
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
LINQ on the .NET 2.0 Runtime
How do I most elegantly express left join with aggregate SQL as LINQ query
How do you page a collection with LINQ?
How do I get a distinct, ordered list of names from a DataTable using Linq
How do I fill a DataSet or a DataTable from a LINQ query resultset ?