Hi!

I'm quite new to LLBLGEN but it's a great product. My scenario is like this, we are about to develop a traditional application with three layers, DAL, BL and PL.

My friend developed an OR mapper a couple of years ago and for him the words, datatable, dataview and especially datasets are words of satan because he doesn't think database schemas is needed in the PL :-) His solution is more like hibernate, he uses reflection and at the end he returns arrays of objects. I downloaded the HnD application and noticed that they had a function converting EntityCollections to datatables which they returned to PL. My question is, is there a simple way of converting EntityCollections and Entites to arrays of object? How do you all communicate to the PL?

/Magnus

If you need Read_Only object in the PL use TypedLists & DynamicLists (which are subTypes of DataTable), you can also project an EntityView of an EntityCollection to a DataTable.

If you need a Read/Write objects, use EntityCollections (that's my recommendation). If you use the Adapter model, the Database schema will be hidden, they are available only in the DatabaseSpecific project which can be referenced in your BL or DAL only.

Hi!

Thanks for your answer. So you mean by returning a TypedList to the PL I can cast it into a datatable?

TypedList is a DataTable

Sorry was a little bit tired yesterday

Hi again!

So you mean if I want to receive a single Customer for example CustomerEntity and pass it out to PL I should use TypedList or??

It's up to you.

You can use a TypedList (dataTable of one row), an entity or even pass the data as parameters or in a struct or any other DTO (Data Transfer Object).