Hey, I'd like to ask if there is a possibility in LLBLGen to provide own native SQL query instead of the one that was generated by LLBLGen itself.

I'm asking because I want to be prepared for sudden performance issues with SQL queries generated by LLBLGen. I'm working with SQL Compact Edition and query performance is one of key success factors.

This is not supported at the moment. In general LLBLGen's queries are pretty efficient and we have very few problems with query execution speed, as long as developers use the normal, sensible principles that you would when querying any database - ensuring indexes are in place, filtering queries to only request needed rows etc.

Do you actually have any examples of this causing you a problem? As ever, beware premature optimization

Matt