Request references links

  • Thread starter Thread starter scsfdev
  • Start date Start date
S

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
 
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/
 
Back
Top