I was just reviewing the LGP support for MsSQL CE on this page: http://www.llblgen.com/documentation/2.6/compactframeworksupport.htm

I have two questions about this:

• The list of the things LGP can't do is quite long, but the things seem to be mostly stuff that are not used on "daily basis". From an experienced and honest point of view: What are the real "sell killers" when it comes to CE?
• Which of the things on that list will be eliminated in LGP 3.0? We will most likely not start this branch of development before the fall anyway. Another small thing: Isn't the "DELETE FROM FROM" a typo?

magic wrote:

I was just reviewing the LGP support for MsSQL CE on this page: http://www.llblgen.com/documentation/2.6/compactframeworksupport.htm

I have two questions about this:

• The list of the things LGP can't do is quite long, but the things seem to be mostly stuff that are not used on "daily basis". From an experienced and honest point of view: What are the real "sell killers" when it comes to CE?
• Which of the things on that list will be eliminated in LGP 3.0? We will most likely not start this branch of development before the fall anyway. Another small thing: Isn't the "DELETE FROM FROM" a typo?

The stuff that's not possible is related to the compact framework's crippled set of features. Don't confuse CE Desktop with CE for windows mobile!

So are you asking about CE Desktop or sqlserver on windows mobile?

Otis wrote:

The stuff that's not possible is related to the compact framework's crippled set of features. Don't confuse CE Desktop with CE for windows mobile!

So are you asking about CE Desktop or sqlserver on windows mobile?

We have an application for CE Desktop that we would like to migrate to LGP (we are doing server development with LGP).

In the future we might also think about developing an application based on windows mobile. This might not be before 2030 though.

So, feedback on the desktop version is critical, on mobile is interesting, but may not affect the decision.

magic wrote:

Otis wrote:

The stuff that's not possible is related to the compact framework's crippled set of features. Don't confuse CE Desktop with CE for windows mobile!

So are you asking about CE Desktop or sqlserver on windows mobile?

We have an application for CE Desktop that we would like to migrate to LGP (we are doing server development with LGP).

In the future we might also think about developing an application based on windows mobile. This might not be before 2030 though.

So, feedback on the desktop version is critical, on mobile is interesting, but may not affect the decision.

Oh, if that's the case, then it's easy. Just create the project on a normal sqlserver catalog, migrate it to a CE Desktop database (so create the schema there too), then generate the code from the normal sqlserver project, and you can use that code on the CE Desktop database as well, with a simple compatibility switch in the config file (and of course a different connection string). See: http://www.llblgen.com/documentation/2.6/hh_goto.htm#Using%20the%20generated%20code/gencode_dbspecificfeatures.htm%23CEDesktop