Re: ORM

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Many ORMs break down at scale. In general, it is ease of use versus scale. I cannot answer to nHibernate.

One thing I would look at, if I were you, is LLBLGen Pro (http://www.llblgen.com). It is at a good price for scale. Plus the author lurks here, so you could end up getting questions answered by the person responsible. LLBLGen has a much nicer data access than many of the other ORMs out there and this is part of the reason it scales. It is the least expensive (not cheapest) of the bunch. There is a demo version.

Deklarit is another option that scales (http://www.deklarit.com/). I have never played with Deklarit personally, but they do have demos and samples on their site.

Genome is another option that I have played with that is rather nice (www.genom-e.com). I have played with genome, but have not deployed it with a production product yet. I am more in maintenance mode right now, however, so it may be some time before I do.

All three of these can be configured quite easily and each of them has advanced features, if you need to go beyond the "out of the box" solution.

You can use any of them with LINQ, as Andrew has suggested. Genome has it built in now, along with their own query language. I believe it is a plug in with the other two. Frans will certainly correct me if I have misrepresented LLBL Gen.

For the record, LINQ is not an ORM.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

********************************************
| Think outside the box! |
********************************************
"Marc " <RmEaMrOcVE@xxxxxxxxxxx> wrote in message news:%23uTsrtO8IHA.4864@xxxxxxxxxxxxxxxxxxxxxxx
The though of writing tons of Database code for a big project sends me to sleep. I've used Java's EJB 3 and Hibernate about a year ago, for a very small test project.

This time I'm considdering using nHibernate. It is however going to be a very large multi-user system, with a local database cache, clients that connect to this using remoting.
I am planning to make use of a quite complex table structure. I've read that nHibernate doesn't scale well.

Has anyone used it for a large, real world system?

Marc


.