Visual Basic® 2010 Unleashed

Writing the Connection String

Different from classic LINQ to SQL, when you work with SQL Compact databases, you need to manually pass the connection string to the database; this is because the class generation could not take advantage of the IDE automation. This means that when you declare an instance of the DataContext class, you need to pass the connection string. For example, instantiating the DataContext for Northwind would be something like this:

Summary

LINQ to SQL is a built-in object relational mapping engine for Microsoft SQL Server databases. The engine maps database information such as tables and columns into .NET objects such as classes ...