Does SQL Server Compact Edition (SqlCe) have a SNAPSHOT table like Oracle Lite?

Posted by MusiGenesis on Stack Overflow See other posts from Stack Overflow or by MusiGenesis
Published on 2010-05-14T04:13:14Z Indexed on 2010/05/14 4:24 UTC
Read the original article Hit count: 348

Filed under:

sqlce

In Oracle Lite, you can create a SNAPSHOT table which is like a normal table except that it tracks changes to itself. The syntax is

CREATE SNAPSHOT TABLE tblWhatever ...

and you can perform CRUD operations on it like a normal table. To get the change information, you query the table like this:

SELECT * FROM tblWhatever + WHERE ...

which returns all the rows in the table (including deleted ones) meeting the WHERE clause, and you can access each row's row_state column as a normal field (which is invisible to a normal SELECT * FROM tblWhatever WHERE ... query).

Is there some way to do the same thing with Sql Compact Edition (3.5) - i.e. create a table that tracks changes without using RDA?

Related posts about sqlce

Importing Excel to SQLCE

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table in excel format (2007 but I can save as anything below that, naturally), and I have an SQL Compact Edition 3.5 SP1 Database table with corresponding columns. I simply want to populate the SQLCE table with the data from the excel file. The data consists of strings and integers only. I… >>> More
Creating and Indexing Email Database using SqlCe

as seen on Stack Overflow - Search for 'Stack Overflow'
I am creating a simple email client program. I am using MS SqlCe as a storage of emails. The database schema for storing the message is as follows: StorageId int IDENTITY NOT NULL PRIMARY KEY, FolderName nvarchar(255) NOT NULL, MessageId nvarchar(3999) NOT NULL, MessageDate datetime NOT NULL, StorageData… >>> More
sdf file (sqlce) not copying to emulator

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with copying sdf file to WM emulator. My solution structure MyApp.DataLayer - there is sdf file MyApp.WMUI - this is windows mobile winform app sdf file has set build action: content copy to output directory: copy always But if I deploy app to emulator, that sdf file doesn't… >>> More
SqlCe Connection count

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to determine the number of connections say a windows application has open with SqlCe? >>> More
How to check if sqlCE is installed on Windows CE

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I check if sqlCE is installed on Windows CE (in C#)? >>> More

Developer IT