Greetings, We are evaluating which OR mapping tool to use for one of our projects.

Our requirements go as follows:

1. We need to structure the solution into multiple layers including data access layer, business logic layer, services layer and user interface.

2. Our business entities should be custom objects that map to an object tree but where levels of loading are specified by the DAO calls (i.e. GetCompanyById(1, FetchLevel.None)) since we want to completely separate UI from backend (i.e. no lazy loading)

3. Our delete methods should not delete the rows in the database but mark the row as deleted with a user id, timestamp, etc. (the user id is based on a custom authentication module with the authenticated username available throghout the system)

It would be great if someone can tell me whether llblgen pro does accomodate those needs and whether there is some sort of n-tier reference application out there.

Thanks M

You can do all of this with LLBLGen. I would take use the demo and the adapter pattern to give it a try. Frans made an example using the Petshop App from microsoft, but he did not like how that had been implemented by Microsoft. I would pull down the demo and give it a try. Also check out this section with examples http://www.llblgen.com/pages/examples.aspx and these are posts in the forum that have a little background on the Petshop example. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=2898&HighLight=1 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=2467&HighLight=1