Filter
Top Products
204 Microsoft Visual Studio 2010: A Beginner’s Guide
Console.ReadKey();
}
}
}
VB:
Module Module1
Sub Main()
Dim myShop As New MyShopDataContext
Dim customers =
From cust In myShop.Customers
Where cust.Name IsNot "Joe"
Select cust
For Each cust In customers
Console.WriteLine("Name: " & cust.Name)
Next
Console.ReadKey()
End Sub
End Module
And here’s the output using my data:
Name: Meg
Name: May
Other than the obvious fact that we’re now getting our data from a real database, the
difference between Listing 7-3 and the LINQ to Objects examples you saw earlier are that
you have to use the System.Linq namespace (C# only), declare the MyShopDataContext
data context, and query Customers from the data context. In C#, the using directive for
the System.Linq namespace is required. If you left it out, the compiler will give you the
following error message:
“Could not find an implementation of the query pattern for source type ‘System.
Data.Linq.Table<LinqToSqlDemoCS.Customer>’. ‘Where’ not found. Are you missing
a reference to 'System.Core.dll’ or a using directive for ‘System.Linq’?”
Remember this message because any time you add a new file to a C# project where
you are coding LINQ queries, this will be an indication you need to add a using directive
for the System.Linq namespace.