business-logic-toolkit

Optimize solution for categories tree search.

Hello, I'm creating some kind of auction application, and I have to decide what is the most optimize way for this problem. I'm using BL Toolkit as my OR Mapper (It have nice Linq support) and ASP.NET MVC 2. Background I've got multiple Category objects that are created dynamically and that are saved in my database as a representatio...

Efficient way to retrieve multiple objects from database.

Hello, quick qestion today... what is more efficient and is there a big diffrence in performance between those to SQL Server operations. select four objects from database in four separate select queries (just fetching them by id) in one single transaction, or select it in a single query (ofcourse more complicated, with joins). I'll ...