tags:

views:

129

answers:

1
Q: 

Can Entity Framework be used to generate SQL Server Compact database

I created a project as described here using Visual Studio 2010 and .NET 4 (Win7/x64). Once I've change the platform target to 'Any CPU' the sample project works. However, if try to generate a model from entity data model (right-click the model and select 'Generate Database from Model'), I get the following error.

Could not find the appropriate DbProviderManifest to generate the SSDL. The supplied provider invariant name 'System.Data.SqlServerCe.3.5' is not valid.

I have a reference to System.Data.SqlServerCe on my project.

A: 

It should work, but there are some extra steps that you need to take. See: http://blogs.msdn.com/b/stevelasker/archive/2008/10/22/privately-deploying-sql-server-compact-with-the-ado-net-entity-provider.aspx

Shiraz Bhaiji  2010-09-09 11:52:36
I downloaded the sample project from the link you provided and upgraded it to VS2010. I had to update the DLL links in the AMD64 and X86 folders. Now I get the following compiler error.
Rubio  2010-09-09 13:06:58
Error 175: The specified store provider cannot be found in the configuration, or is not valid. File: LocalData.edmx
Rubio  2010-09-09 13:11:30
Same error when trying to generate database from model.
Rubio  2010-09-09 13:16:28
try opening up your edmx file add see if there is any error messages. The problem may be related to the structure of your database
Shiraz Bhaiji  2010-09-09 13:24:02
If you mean opening the edmx in VS model designer, then no, I don't get any errors.
Rubio  2010-09-09 15:32:41
No open it in notepad and have a look at the xml
Shiraz Bhaiji  2010-09-09 15:57:06
I'm not quite sure what you mean. The edmx is an XML file. What exactly am looking for? Is it valid XML? Yes! If I open the XML in VS XML editor, it show the same error 175.
Rubio  2010-09-10 06:33:57

related questions

SQL tracing LINQ to Entities
SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?
ADO.NET Entity Framework and identity columns
Is anyone using Entity Framework with an Oracle database?
LINQ to entities - Building where clauses to test collections within a many to many relationship.
Entity Framework: how to return a base type from L2E
Unit Testing in .NET: How to Mock Entity Data Provider
Entity Framework - Can you map the result type of an imported stored procedure to a custom entity type?
Entity Framework and Application Architecture (loose coupling, etc)
Can you use Microsoft Entity Framework with Oracle?
Using MySQL with Entity Framework
How to Implement Database Independence with Entity Framework
What is the best data access paradigm for scalability?
ADO.NET Entity Framework tutorials
How do you create a database from an EDM?
Anyone using the Entity Framework *Well*?
What real-world usages of ADO.NET Entity Framework do you know?
Which ORM framework can best handle an MVCC database design?
Where to start with Entity Framework
How to customize Entity Framework classes?
Linq to Entities vs ESQL
ADO.NET Entity vs NHibernate
Update database schema in Entity Framework
Expression.Invoke in Entity Framework?
Entity Framework vs LINQ to SQL