Please do suggest an embedded database with row locking feature for c# ?
+1
A:
Isn't that a self-defeating request? If you are embedding the database then it's just accessing a file from your executable. The file wouldn't support row locking and any row locking by the embedded database would be limited to the scope of your application. Are you building a multi-threaded application?
EDIT
Before you down vote... read the comments too!
Lazarus
2009-08-12 12:51:19
Yep. Heavy multithreading.
2009-08-12 12:53:38
In that case I withdraw my statement ;) I know of Nexus which I know is used in a heavily multithreaded application, it's also seriously fast. I don't know specifically if it's used with row locking.
Lazarus
2009-08-12 12:54:41
URL for above: http://www.nexusdb.com/support/index.php?q=node/509
Lazarus
2009-08-12 12:57:13
Hi Lazarus, thanks for your help. I was googling to know more about Nexus.
2009-08-12 13:07:14
+2
A:
Firebird might be an option if you are looking for a free one.
Robert Harvey
2009-08-12 15:24:46
+1
A:
ESENT is an embedded database which is part of Windows (the Active Directory uses it). It has row locking but no query engine. The managed interface is here:
hfcs101
2009-08-18 22:54:47
A:
I dont quite understand why you would need row locking with an embedded database? Are you using multiple threads for access across multiple connections or transactions? or are you assuming that other processes can access the datafile?
Assuming that the row locking is a mistake, Microsoft offers a good choice with SQL Server Compact edition (http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx). This is fully embeddable, and is reasonably compatible with the full SQL Server stack.
David B
2010-07-28 23:21:33