Object Databases and C#

Question

I have an application where my domain model just works. It's all very clear, clean and maps to objects very well. My problem is that it does not map to a relational database very well. With that in mind, I'm looking for object databases that play with .Net/C# reasonably well.

Is there a defacto best in class object database for the Microsoft .Net world?

Answer 1

Try http://www.db4o.com/

Here's a list of oo databases and also a comparison chart.

Answer 2

I've played with both db4o and Perst for Java. I had issues with Perst's method of handling object updates, so I've gone with db4o for now; I'm still in early phases though.

I've heard that Cache is a good OO database, but it isn't free. It provides a lot of the features that RDBMSs have that many of the open source OODBMSs don't have. I haven't used it because of the cost, however.

You're biggest challenge with an OODBMS will come with finding good documentation, good ACID capabilities, and dealing with scale and disaster recovery scenarios. Ad hoc queries and reporting are also challenging, so it's a definite plus to make sure that those types of queries or any reporting will not be needed.