nhibernate - Criteria API With clause in many-to-many relationship -


nhibernate 3 introduced clause criteria api. i'm trying use restrict join on many-to-many relationship , nhibernate applying additional join restriction linking table rather correct table.

i have many-to-many relationship between player , address , want return player , mailing address restricting address.ismailingaddress. restricting ismailingaddress in clause not return records not have mailing address (or no address @ all), need restrict in join. code below simplified , can't use hql.

the query:

var target = session.createcriteria<player>()     .setprojection(projections.property("playerid"))     .createalias("addresses", "ad", jointype.leftouterjoin, restrictions.eq("ad.ismailingaddress", true))     .add(restrictions.eq("lastname", "anonymous"))    .list();

generates sql:

select this_.playerid y0_   dbo.vplayerexisting this_        left outer join dbo.linkplayaddr addresses3_          on this_.playerid = addresses3_.playerid             , (ad1_.mailingaddressflag = 1 /* @p0 */)        left outer join dbo.vaddress ad1_          on addresses3_.addressid = ad1_.addressid             , (ad1_.mailingaddressflag = 'anonymous' /* @p1 */)  this_.name_last = @p2

mailingaddressflag (the column that's mapped ismailingaddress) restricted in many-to-many linking table doesn't exist , lastname restriction applied in join address table. query issued of course database server raises exception.

is bug, unsupported or doing wrong?

var target = session.createcriteria<player>()     .createalias("addresses", "ad", jointype.innerjoin)     .add(restrictions.eq("lastname", "anonymous"))     .add(restrictions.eq("ad.ismailingaddress",true))     .list();

just inner join mailing address restriction on ismailingaddress?

should bring players (where lastname "anonymous") mailingaddress have address , address flagged ismailingaddress.


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