Request references links

[scsfdev]

Hi all,

Can anybody share me some links about SqlCeDataReader and
SqlCeResultSet?
Currently I'm developing application for copying SQL Express
Database's table to WinCE SDF database's table.

So, I want to learn these 2 (Reader and ResultSet) things and I kindof
new to this two too.

Thanks

 

[Ginny Caughey MVP]

SqlCeDataReader works just like SqlDataReader, so there's nothing really new
to learn there. The both inherit DbDataReader and implement IDataReader, so
the interfaces should already be familiar to you.

SqlCeResultSet inherits from SqlCeDataReader adding the ability to scroll
backwards and forward through the data as well as updating the data in
place. Here's a link to the docs:
http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceresultset.aspx

Here's an article about insert performance and SqlCeResultSet with some
sample code:
http://www.pocketpcdn.com/forum/viewtopic.php?t=11003&start=0&postdays=0&postorder=asc&highlight=

The skinny is that SqlCeResultSet is much faster at inserts than using T-SQL
insert commands since it avoids extra buffering and the query processor.
Fastest of all however is using native code, which is the basis for the
products here: http://www.primeworks-mobile.com/