There is no secret that SQL CE currently is not supported on a Smartphone platform.
It means that the options for data storage on a Smartphone for .NET Compact Framework
developers are generally limited to DataSet XML serialization/deserialization. This
option has known deficiencies: you can read/write data in “all or nothing” way only
and XML by itself bloats the data, all of which is a big downsize in the memory constrained
Smartphone environment. So, what’s the solution? Write your own “a read from the file
stream, save in binary form, fast forward-only reading” storage in CF. And this is
what I’ve been working on for the last few weeks. The quick test I ran yesterday showed
a really good speed/memory benchmarks. DataGrid population with 1000 (5 fields) records
takes about 3 secs! Now, I just need to find some time to clean up the code and write
up a whitepaper on it…