Using Entity Framework with an SQL Compact Private Installation

by

I figured out how to do it, thanks to a blog post by Steve Lasker. Basically, here is what you have to do:

(1) Set a reference to System.Data.SqlServerCe.dll in your project. Set the CopyLocal property to True.

(2) In the App.config for your project, add the following XML markup. It tells EntityFramework to look to your private installation of SQL Compact for its data provider:

<system.data>
    <DbProviderFactories>
        <remove invariant="System.Data.SqlServerCe.3.5"/>
        <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
    </DbProviderFactories>
</system.data>

(3) In the Setup project, add the following files to the Application Folder in the File System Editor:

  • sqlcecompact35.dll
  • sqlceme35.dll
  • sqlcese35.dll
  • System.Data.SqlServerCe.Entity.dll

More Related Contents:

  1. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  2. Disable lazy loading by default in Entity Framework 4
  3. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  4. How to include a child object’s child object in Entity Framework 5
  5. Entity Framework 4 / POCO – Where to start? [closed]
  6. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  7. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  8. Unique keys in Entity Framework 4
  9. Entity Framework 4 selective lazy loading properties
  10. Upgrade EF 4 EDMX to EF 6
  11. Querying objects after AddObject before SaveChanges?
  12. EF Migrations: Rollback last applied migration?
  13. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  14. Map two different entities to the same table?
  15. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  16. AutomaticMigrationsEnabled false or true?
  17. Compose queries across Entity Data Models
  18. Changing Inherited Types in Entity Framework
  19. There is already an open DataReader associated with this Command which must be closed first
  20. EF Core Second level ThenInclude missworks
  21. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  22. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  23. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  24. EF 4: Removing child object from collection does not delete it – why?
  25. How to exclude one table from automatic code first migrations in the Entity Framework?
  26. Entity Framework : How do you refresh the model when the db changes?
  27. Entity framework code first creates “discriminator” column
  28. How to update not every fields of an object using Entity Framework and EntityState.Modified
  29. Many to Many Relationships not saving
  30. DbContext AutoDetectChangesEnabled set to false detecting changes

Leave a Comment