SQL Server Compact

Topics: General
Jun 2, 2011 at 12:48 AM

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 9: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 :)

Jun 2, 2011 at 1: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 1: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 2: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?

Jun 3, 2011 at 12:16 PM

>>  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 

Jun 3, 2011 at 12:46 PM

@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.