>>From a contrarian POV, on top of the benefits of only having to chuck a coiuple of DLLs into the deployment:
>>
>>You can use the Compact edition with the ADO.NET support for EF and Linq (native providers not OLDEB)
>>You can use SSMS to create/manage CE databases.
>>IIRC replicating to a main SQL server is supported?
>>
>>Admitted downsides:
>>4GB database limit
>>No Stored Procs.
>>No nested transactions ?
>>
>>But unlikely that any of the latter would be a show-stopper for Mark ?
>>
>I found last night this reference that may be very helpful
>http://msdn.microsoft.com/en-us/library/bb896140.aspx
>
>It shows what is supported / not supported in SQL Server CE vs. regular SQL Server


This is more recent http://msdn.microsoft.com/en-us/library/bb896140(v=SQL.110).aspx

Changed - minor difference at first sight

- Aliasing of database object names with 'AS'.