Hi All

Don't known anyone - possible in LLBLgen execute arbitrary SQL ? Something like

MyObjectCollection myObjectCollection = xxx.Fetch("SELECT * FROM T_XXX, T_YYYY WHERE T_XXX.xxx = T_YYY.xxx AND ROWNUM < 100");

It's possible ? Not with dynamic SQL like .AddWhere or .AddJoin - directly writing SQL. It's critically for me in DB with 100+ million records. StoredProcedure not comfortable in some cases.

P.S. I'm using Oracle. P.P.S. Sorry for my English.

[UPDATE] I'm consult to our DBA - they say STORE_PROC is no problem - we just place our SQL into PROC and call it - on first look it's no problem in LLBLgen. Question is close.