Data access: SqlCeResultSet or DataSet ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Serge Wautier - 26 Feb 2008 23:16 GMT

Env.: WM6, SqlCE 3.5

Hi All,

I'm a newbie both for mobile apps and SqlCE wondering which technology to
use for access to a SqlCE db.
I just discovered that the compact framework doesn't support Linq to SQL :-(
Which leads me to investigate typed DataSet vs typed SqlCeResultSet,
TableDirect mode vs query engine.

Does it make sense to use a SqlCeResultSet with a query or do I lose all of
the performance vs a Data Set? Is the performance gain really worth it? If I
need to make JOINs, is there a solution with SqlCeResultSets or am I
automatically back to Data sets?

I'm confused. Any lights warmly welcome.

TIA,

Serge.

Reply to this Message

Ginny Caughey [MVP] - 26 Feb 2008 23:41 GMT

Serge,

If you need a join, you need to do it yourself with SqlCeResultSet or
denormalize your data. SqlCeResultSet does provide best performance
generally compared with DataSet. TableDirect provides better performance
than the query processor. But I think you should first determine if
performance is an issue for the volume of data you expect.

Signature

Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management

> Env.: WM6, SqlCE 3.5
>
[quoted text clipped - 17 lines]
>
> Serge.

Reply to this Message

Jin - 27 Feb 2008 02:23 GMT

> Env.: WM6, SqlCE 3.5
>
[quoted text clipped - 16 lines]
>
> Serge.

I suggest that you at least familiarize yourself with both the
SqlCeResultSet and TableDirect so that you can determine for yourself
which situations can better be handled using these methods. The
performance gain can be substantial if done right and I find that most
situations easily be handled by them.

Reply to this Message