I have been talking to you on codproject about the query syntax but i am finding codeproject a bit of a pain for discussions so i thought i would try here.
One other thing i am considering using this database for is cache. A file cache for one of my http libs in my app to be exact. That then raises 2 questions.
1. Can you explain deleting and why it is the way it is? The codeproject article makes it sound like deleting and entity does not delete it which is worrying for a cache as it would forever grow and i could not get rid of data i don't want any more.
2. What would be the recommend way to store binary data plus a little meta data such as name etc that would be used to extract the binary data. My files should not be bigger than 5MB but i want to understand how this part works and best practice
so i don't start with a bad design. Most of my files will be under 100KB but i will have many of them and don't really want a file on disk for each of them if possible.
There are other solutions i can consider it is just that since i am already using your database it seemed a good idea to use it for the cache as well if it will support it.