Like Microsoft SQL Server, SQL CE supports transactions, referential integrity constraints, locking as well as multiple connections to the database store. To meet the durability requirement the commit call on the transaction must specify the immediate flag. Therefore, committed transaction changes can be lost. SQL CE databases can support ACID-compliance, but do not meet the durability requirement by default because AutoFlush buffers changes in memory (including enlisted ambient transactions and explicit SQL CE transactions that do not override the Commit() call with an CommitMode.Immediate value).
0 Comments
Leave a Reply. |