Hi David

>
>During several of the Orcas presentations last week, SSCE was being used as a "caching" layer, very much like we might use an updatable view or cursor, with LINQ talking to that layer and processing updates against it. There was a Synchronization mechanism that was called in the samples to send the updates on to the permanent backend, although the SSCE *can* be used as a standalone database.

Not to mention that loading data in SSCE database table is VERY fast. Twice as fast as using VFP OLEDB provider. Almost a magnitude faster compared with ADO.NET DataSet. And then you can execute familiar SQL commands to process cached data.

>
>It was interesting to see a reference in the article to the SqlCeCommand CommandType.TableDirect property, which can let you use the high-speed SqlCeDataReader's Seek method on indexed columns to position the record pointer. Sound familiar? However, the article writer couldn't figure out how to use the Seek because there was little documentation for it yet in Books Online. I'm guessing that it might not be so hard to figure out. :-)

Yes, here are the some details, I see something equivalent to VFP Seek, SET KEY TO...
http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlcedatareader.seek.aspx