sql - Nhibernate join filtering -


i have question joins in nhibernate. had issue our sql query generated nhibernate. our db developer optimized raw sql works need, need change nhibernate code make generated sql optimized.

the part of original part of query is:

from   person_visit this_                      inner join person_basic per2_                        on this_.person_id = per2_.person_id                      left outer join personc_questions perint10_                        on per2_.person_id = perint10_.person_id                      left outer join telephone_questions intaudit13_                        on perint10_.pp_questions_id = intaudit13_.pp_questions_id                      inner join c_questions intdef14_                        on perint10_.question_id = intdef14_.question_id                           , perint10_.questions_code = intdef14_.questions_code                           , perint10_.question_id = intdef14_.question_id

the optimized 1 :

from   person_visit this_                      inner join person_basic per2_                        on this_.person_id = per2_.person_id                      left outer join personc_questions perint10_                        on per2_.person_id = perint10_.person_id                      left outer join telephone_questions intaudit13_                        on perint10_.pp_questions_id = intaudit13_.pp_questions_id                      left outer join c_questions intdef14_                        on perint10_.question_id = intdef14_.question_id                           , perint10_.questions_code = intdef14_.questions_code                           , perint10_.question_id = intdef14_.question_id                           , intdef14_.discipline_code = this_.discipline_code

to change query inner join left outer join easy, changed 1 line of code:

        .createalias("personint.questionentity", "intdef", jointype.leftouterjoin)

but how can add 

                          , intdef14_.discipline_code = this_.discipline_code

using nhibernate code?

there option add reference person_visit definition c_questions, problem person_visit used everywhere , don't want change possibly break other queries, wnat add 1 line of code add, how can that? there way have access raw join change it? or other way add 

                          , intdef14_.discipline_code = this_.discipline_code

to query? know can add restriction query through criteria.add, not option cause db developer optimized our query taking restriction clause join.

how can without changing models definitions? changing 1 query without changing whole model?

it possible using hql , criteria api's.

this question gives answer: adding conditionals outer joins nhibernate

something may solve issue.

.createalias("personint.questionentity", "intdef", jointype.leftouterjoin,        restrictions.eqproperty("discipline_code", "intdef.discipline_code"))

Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more