SqlCE Compact Edition version

[dev100]

We are developing a .NET 2.0 cf product with VS2008 targeting WM6 devices.
We will be using sql server compact edition. If we wish to use sqlserver ce
3.5 with CF2.0
i take it we need to install sqlserver 3.5 with the app.

If this is the case we will probably go with sqlserver 3.1 (well the
previous
version) as i think this comes in the ROM of a WM6 device.

How do i go about using the 3.1 version of sqlserver CE with VS2008.Can i
use
all the same tools, dataset designer etc or are there some limitations
All the tutorials for VS2008 discuss sql ce3.5 so its a bit confusing.

Any advice appreciated.

 

[Ginny Caughey MVP]

I'd suggest just using SqlCe 3.5 sp1. Each version of SqlCe fixes more bugs,
and 3.5 sp1 is the most solid version out there. The approximately 1.5 Mb
additional size of your app plus DLLs is usually not a big issue, and
"installing" SqlCe can be as simple as just privately deploying the 3.5 sp1
DLLs your app needs along with the rest of your app.

 

[Ginny Caughey MVP]

I'd suggest just using SqlCe 3.5 sp1. Each version of SqlCe fixes more bugs,
and 3.5 sp1 is the most solid version out there. The approximately 1.5 Mb
additional size of your app plus DLLs is usually not a big issue, and
"installing" SqlCe can be as simple as just privately deploying the 3.5 sp1
DLLs your app needs along with the rest of your app.

 

[Simon Hart [MVP]]

As Ginny suggested it is better to use 3.5. There are some enhancements over
the previous version 3.1, some of the main ones are :

- Timestamp datatype (rowversion)
- Nested from clause support
- SET IDENTITY INSERT support

 

[Simon Hart [MVP]]

As Ginny suggested it is better to use 3.5. There are some enhancements over
the previous version 3.1, some of the main ones are :

- Timestamp datatype (rowversion)
- Nested from clause support
- SET IDENTITY INSERT support