SQL Server Compact

Topics: General
Jun 1, 2011 at 11:48 PM

Hi,

Is it possible to use SQL Server Compact / SQL Server CE as the data store for Composite C1?

Thanks,

Larry

Jun 2, 2011 at 8:33 AM

as it is now, no. There has been a few discussions of ie supporting EF, latest this one http://compositec1.codeplex.com/discussions/259679... but so far its only talk :)

Coordinator
Jun 2, 2011 at 12:00 PM

Composite C1 is currently using SQL Server Management Objects to do data schema manipulations - I don't know SQL Server Compact / SQL Server CE work with SMO. You can download SMO as a stand alone install and test it.

Jun 2, 2011 at 12:18 PM

Since SQL Server CE doesn't share the provider with the Full Blown SQL Server it wouldn't work. The SQL Dataprovider in C1 is compiled against System.Data.SqlClient from the System.Data assembly. Talking with SQL Server CE requires the System.Data.SqlServerCe namespace defined in the System.Data.SqlServerCe assembly - http://technet.microsoft.com/en-us/library/system.data.sqlserverce.aspx

Jun 3, 2011 at 1:55 AM

Not sure about the SMO support in SQL Server CE, but from my understanding the T-SQL is almost the same... Would the C1 SQL Dataprovider require alot of changes to use interface methods such as IDBCommand instead of directly using classes in the SqlClient namespace in order to switch between the two SQL Server platforms?

Coordinator
Jun 3, 2011 at 11:16 AM

>>  Not sure about the SMO support in SQL Server CE, but from my understanding the T-SQL is almost the same...

it is almost the same, and yet Microsoft hasn't implemented/released a version of LINQ2SQL that would support it. Proof link 

Coordinator
Jun 3, 2011 at 11:46 AM

@larryroth You are very welcome to add a feature request to the Issue Tracker with a short motivation for adding SQL CE support to Composite C1.