Just in the past few weeks, I have been looking at a OODBMS called
Cache from http://www.intersystems.com/cache/ . At first glance ,this
looks like a promising technology since it allows one to design tables
in an object oriented manner and has automatic class generation
technology that will generate classes for .NET, Java, etc. It also
understands ANSI SQL. It seems like the perfect tool to solve the
"impedance mismatch" problem. I just read this article on MSDN
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnvs05/html/nxtgenda.asp
which is an add on layer for ADO.NET to solve the relational to object
mapping dilemma, but it is just one more thing to learn on top of so
many others things we need to learn as developers. Has anyone had any
real experience with an OODBMS? In trying to search for actual usage
experience, I haven't found much. If OODBMSs are that good, why do I
not see a whole lot of material out there on them? Thoughts? Comments?