We've recently decided to use the Sterling database in our project. It works pretty great and we're pretty happy with the results. However there is one problem that we can't seem to figure out. Our architecture requires us to Delete a record from the database
and then later check if the record still exists. However when I try and read a record with the Load command, so for example:
I get a weird exception back if the record doesn't exist:
"There was an issue accessing isolated storage: Operation not permitted on IsolatedStorageFileStream.. Check the inner exception for details."
Inner exception: "Operation not permitted on IsolatedStorageFileStream."
When the record does exist it works fine. So I don't think we made any mistakes implementing Sterling. Is there any way to check if the record exists? Like a specialised method? Or a way to make the Load return a null value if it doesnt exist? Catching the
exception would be really ugly and we'd rather solve it properly.
Thanks for your time,