Hi, maybe it's a simple question but we really need an expert opionion on this

In entityframework we have ability to write queries in one line like this:

IQueryable<D2C_OrderActivity> orderActivities = model.D2C_OrderActivity.Where(x => x.OrderId == orderId && x.Status == ).OrderBy(x => x.RankNumber).Take(1).Select(x => x);

but with llblgen, as far as I know first we need to prepare predicate filters with multiple lines of code, then run it, and once we fill the collection, we have chance to run queries like above.

Is it an easier way for this? is it possible to simply use queries like above without predicate filters or buckets etc?

Thanks Best regards Gokhan

With LLBLGen Pro, you may write filters, first indeed but you don't have to execute anything first to fill collections and then do the sorting and stuff. The entire query is executed at one shot.

About the syntax, you may use Linq in LLBLGen Framework, and a better option is to use QuerySpec