What's your opinion on these? Is there anything else worth looking at? I just need something that will make my work easier and the database more manageable.
LINQ looks nice and more powerful than HQL, but currently my .NET language of choice doesn't support it. And NHibernate is a mess of XML files..
I have heard that db4o has a .NET port. It's a database where you don't bind to a relational database, but store actual objects.
>>2
Thanks, I might look into that for some future projects. But right now it definitely isn't going to help, I already have a 16GB MSSQL database in place.
OK, maybe someone will be able to help with this. Can Hibernate use two different DB servers in one query? Like, you have CustomersTable one Server1 and OrdersTable on Server2 and you want to join them.