LinqToSql Tutorial SQL Server Compact

Introduction

In LINQ to SQL, you can also access SQL Server Compact databases.

using (SqlCeConnection conn = new SqlCeConnection(@"Data Source=CustomerDB.sdf"))
{
    using (var db = new CustomerDbDataContext(conn))
    {
        var customers = db.Customers.ToList();
    
        foreach (var customer in customers)
        {
            Console.WriteLine(customer.FirstName + ", " + customer.LastName);
        }
    }
}

Limitations

The SQL Server Compact feature set is much simpler than SQL Server and contains the following limitations that affect LINQ to SQL applications.

• Does not support stored procedures or views.
• Supports only a subset of data types and SQL functions.
• Supports only a subset of SQL constructs.
• Provides only a minimal optimizer. It is possible that some queries might time out.
• Does not support partial trust.