Implementing Search on business objects in NTier Architecture ?

David johnsan · April 22nd, 2009, 09:06 AM

Hi Imar.

I am using NTier Architecture as you mention in your articles.

My NTier Layers are

-- UI Layer
--- BusinessEntity
--- BusinessManager
--- DataAcess

My CustomerEntity class have 120 attribute's.

Users can peform search on only 6 attribute's (like Fname,Lname-----) .

while perfroming search at UI layer my CustomerManager class returns collection of CustomerEntity .

I am binding only 10 attribute's of search result in gridview.

If search result have more then 100 customer records then it takes few second to populate.

To make search process faster, Should I create a CustomerEntitySearchResult Class with only 10 attributes that are required to display in Gridview.

I am not using DataTable ,DataSet at UI layer.

Please suggest any effective and efficient way to accomplish above task.

Imar · April 22nd, 2009, 03:10 PM

Hi David,

Can you please post messages like these in a more general ASP.NET category here at p2p.wrox.com? This category is for my book Beginning ASP.NET 3.5 and off-topic posts makes it more difficult for readers of the book to find what they need.

Anway, I don't think loading indiviual properties is the problem here (unless they contain large pieces of data like blobs). I think the fact you're trying to load so many objects is what's problematic.

If I were you, I'd implement paging E.g. you get the first 10 records and load them in a collection to display on a page. You also get the total number of records which you can then use to present a series of links or buttons to "page" through your data.

Hope this helps,

Imar