Using LINQ to SQL with SQL Server Compact Edition – Is now available in VS2008

Recently we all started using SQL Server embedded Compact databases ideal for building standalone and occasionally connected for applications for mobile devices, desktops, and Web clients. But there is a problem that Visual Studio 2008 doesn’t support using LINQ to SQL with SQL Server Compact. However, the .NET Framework does and there’s a work around to get it working in VS2008.

Download SQL Server Compact 3.5


Install SQL Server Compact and now ‘LINQ to SQL with SQL Server Compact database’ works perfectly with VS 2008 IDE !


Top Features :

    • Free to use and distribute

    • Supports desktops and mobile devices

    • Small footprint for easy deployment

    • Fully embeddable architecture

    • No administration required

    • Single file, code-free database format

    • Support for ClickOnce, XCopy, MSI, CAB, and non-admin embedded installation options

    • Supports all Microsoft Windows embedded, mobile, desktop, and server operating systems

    • Supports a rich subset of Transact-SQL syntax and SQL Server data types

    • Microsoft Visual Studio 2008 integration

    • Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the ADO.NET Entity Framework

    • Supports multiple concurrent local connections


Powerful :

Develop high-performance, applications using an embedded SQL Server database engine that provides rich functionality in a compact footprint.

Create powerful applications


  • Develop applications that exploit a rich subset of Transact-SQL functionality and manage virtually any kind of data

  • Rich subset of SQL Server data types and Transact-SQL including:

    • JOINS and sub-queries

    • Filters, grouping, aggregates, sorting


    • BLOB/image data types

  • Build full-featured mobile and desktop client applications that support the following features:

    • Full transactional support

    • Full referential integrity including cascading updates and deletes

    • Scrollable and updateable cursors

    • ADO.NET, LINQ to SQL, and LINQ to Entities


Refer more about Compact 3.5  here

– Ananth Ramasamy Meenachi


About msarm

Aspiring Enterprise Architect.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s