esent

Enumerate indexes on a Extensible Storage Engine (ESENT) table

Background I'm writing an adapter for ESE to .NET and LINQ in a Google Code project called eselinq. One important function I can't seem to figure out is how to get a list of indexes defined for a table. I need to be able to list available indexes so the LINQ part can automatically determine when indexes can be used. This will allow much...

.Net Finalizer Order / Semantics in Esent and Ravendb

Help me understand. I've read that "The time and order of execution of finalizers cannot be predicted or pre-determined" Correct? However looking at RavenDB source code TransactionStorage.cs I see this ~TransactionalStorage() { try { Trace.WriteLine( "Disposing esent resources from finalizer! You should call TransactionalStorage....

How to replace values in multi-valued ESE column?

I have a multi-valued short ASCII text column in one of the tables in my ESE database, that holds the person's phone numbers. I have the new set of values, and I'd like to wipe the old values completely, and only use the new values. The JET_bitSetRevertToDefaultValue bit doesn't seem to work. While the MSDN documentation says "It cause...

ASP.NET + thread-aware unmanaged API

I'm thinking over an ASP.NET application that uses ESENT for persistance. At this point this is just my hobby project, so the requirements are very flexible. However I'd like it to work on Windows 7, Windows 2008, and 2008 R2, with .NET 3.5 and higher, and default IIS settings. In ESENT, most operations require you to open a session o...

ESENT database engine file access denied

I am trying to using the ESENT windows database with the managedesent library but I always get the error Error FileAccessDenied (JET_errFileAccessDenied, Cannot access file, the file is locked or in use) The code to open the database is m_Dictionary = new PersistentDictionary<string, PropertyStruct>("BaseEstateCachedPropertySummary...