In particular I was surprise with the function .SingleOrDefault() on a single call for a Property it was taking 0.2 seconds on a database with ~4,000 records. The database has already been optimized.
I did some reading and found an article from JD in regards to this issue
I decided to implement on the Property class the static for delegates:
public static Func
> _propertyGetQuery =
SubSonic.Linq.Structure.QueryCompiler.Compile((PropertyRentalDB db, int id) =>
from p in db.Properties
where p.PropertyId == id
public static Property GetById(int propertyId)
var db = new PropertyRentalDB();
Property p = _propertyGetQuery(db, propertyId).SingleOrDefault();
Compile and run Ants performance profiler and the load tests and the performance results here HUGE!
Total hits 71. Average from 0.20 to 0.011.
Now I can go and optimized more of the code where I use similar instances.
However, I think on my next project I will just go back and use SubSonic 2 and forget about Linq.