Using CF 2.0 with VS 2003?

[Phillip N Rounds]

Is it possible to develop an app using the Compact Framework 2.0 in VS.NET
2003?

If no, is there any way to directly query a remote SQL Server using CF 1.0?


Thanks

Phil Rounds

 

[Ginny Caughey [MVP]]

Phil,

You can use the SqlClient namespace to query a SQL Server (assuming you have
remote connectivity), but you can't use CF 2.0 with VS 2003.

 

[Phillip N Rounds]

My app has to synchronize with the remote SQL Server when docked, then
function independently when in actual use.

So, I have to write an SmartDevice application, which doesn't have
System.Data.SqlClient ( in CF 1.0).
I guess I could write a MobileWebApp and a SmartDevice App.

Thanks

 

[Chris Tacke [MVP]]

SqlClient exists in CF 1.0

-Chris

My app has to synchronize with the remote SQL Server when docked, then
function independently when in actual use.

So, I have to write an SmartDevice application, which doesn't have
System.Data.SqlClient ( in CF 1.0).
I guess I could write a MobileWebApp and a SmartDevice App.

Thanks

 

[Ginny Caughey [MVP]]

Phillip,

I'm pretty sure that SqlClient is available for CF 1 as well as CF 2, but
you might not choose to use it for a variety of reasons. Alternatives would
include using SqlCe on the device and transferring the data to the desktop
pehaps using a 3rd party product like those at www.primeworks.pt. CF 1 also
supports consuming web services, although it doesn't provide all the
serialization support you get with CF 2 and you might want to write your own
custom serialization routines. If you have SQL Server 2000 or SQL Server
2005, you could use either RDA or merge replication with SqlCe on the
device, both of which are supported with CF 1.

But is there a particular reason you want to stay with VS 2003? VS 2005 is
MUCH better, especially with the data tools for working with SQL Mobile, so
I'd recommend upgrading to the latest and greatest rather than creating
unnecessary work for yourself. I don't think a mobile web app will give you
want you want in terms of usability.