>>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
Thx. Pity it didn't compare CE with SQL Express - I'm sure that's what most people would find most useful :-{