SQL CE 3.5 and VS 2005

Posted on 2007-10-03
Medium Priority
Last Modified: 2013-11-18
I am using SQL CE 2.0 and VS 2005. This app will be deployed on device with OS CE 5.0. Now since SQL CE 2.0 does not support SET IDENTITY INSERT, I decided to move to SQL CE 3.5. But a few questions:

1. Can I safely deploy app with SQL CE 3.5 in production which is still in Beta 2?

2. Can I use VS 2005 with SQL CE 3.5?

Question by:vj_mi
LVL 48

Accepted Solution

Mikal613 earned 2000 total points
ID: 20005745
1) I wouldnt recomend it

2) yes but you need SP1 for visual studio and this http://www.microsoft.com/downloads/details.aspx?FamilyId=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en

Author Comment

ID: 20015034
My Device app will be a small part of the actual web. This will just  perform inserts, updates, select and delete. No T_SQL or SP. All SQL will be in the code. No special features of SQL will be used. Even then, SQL CE 3.5 is not safe?



Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Once again I push the limits of my phone.  An introduction to the Android Google Now Launcher.
Learn how to use the free Acronis True Image app to easily transfer data between iPhones and Android phones.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month15 days, 2 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question