This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi Guys,
I am doing a search on two tables, depending upon the criteria passed in determins the search i'm doing. Iam doing a left outter join first and then using LAMBDA to query the query, it says lightspeed does not support this, i find that really hard to believe lightspeped dows not support a where statement, any help?
var query = from m in uow.CollateralMasters join a in uow.Addresses on m.PropertyAddressSequence1 equals a.Id into x from y in x.DefaultIfEmpty() select new { Masters = m, Addresses = y }; query = query.Where(m => (!string.IsNullOrEmpty(criteria.Status)) ? m.Masters.CollateralStatusId == criteria.Status : true); ....more where statements .OrderBy(m => m.Masters.CollateralMaster_Id).Skip(0).Take(200); list = query.ToList().ConvertAll(item => (ICollateralMaster) item.Masters);
|
|