SQL Server CE, Visual Studio 2008/2010 RC, and Linq-to-Sql
- by blu
I added an .sdf to my project, added a table, added a Linq-to-Sql dmbl, and tried to add the table to the dbml.
The result was an error:
"The selected object(s) are an
unsupported data provider"
This happens in both VS 2008 Professional SP1 and 2010 RC Ultimate. I found someone talking about using SQL Metal to generate the file, but I didn't enjoy that 2 years ago, and after a little playing around I recall why.
Does anyone know if this is going to be supported in the release version? Should I abandon SQL Server CE and just use SQLite (with DbLinq)? Thanks for any insight.