c# - Nhibernate and MVC. Null object from query -


so rather new using nhibernate database access , after studying usage elsewhere in application editing, cannot seem work me , not know why. effectively, trying populate object data database can pull pieces in , present them user. issue despite syntax , code looking correct, object remains null after query execution.

the class being used represent table in database:

public class allocatelog {     public virtual string username { get; set; }     public virtual int id { get; set; }     public virtual int ownerid { get; set; }     public virtual int memberid { get; set; }     public virtual int? resid { get; set; }     public virtual string requestcomments { get; set; }     public virtual datetime dateentered { get; set; }     public virtual datetime? dateexited { get; set; }     public virtual string entryaccesspoint { get; set; }     public virtual string exitaccesspoint { get; set; } }

the mapping code:

    public class allocatelogoverride : iautomappingoverride<allocatelog> {     public void override(automapping<allocatelog> map)     { #if local_install         map.schema("dbo"); #else         map.schema("cred"); #endif          map.table("allocate_log");         map.compositeid()                     .keyproperty(x => x.ownerid, "owner_id")                     .keyproperty(x => x.memberid, "member_id")                     .keyproperty(x => x.dateentered, "date_entered");         map.map(x => x.username).column("user_name");         map.map(x => x.resid).column("res_id");         map.map(x => x.requestcomments).column("request_comments");         map.map(x => x.dateexited).column("date_exited");         map.map(x => x.entryaccesspoint).column("entry_access_point");         map.map(x => x.exitaccesspoint).column("exit_access_point");     } }

the query code:

    public class allocatelogsforaccesspoints : iquery<iqueryover<allocatelog>, allocatelog> {     private readonly string accesspoint;      public allocatelogsforaccesspoints(string accesspoint)     {         this.accesspoint = accesspoint;     }     public iqueryover<allocatelog> buildquery(isession session)     {         return session.queryover<allocatelog>()             .where(d => d.entryaccesspoint == accesspoint);     }     public allocatelog execute(iqueryover<allocatelog> query)     {         return query.singleordefault();     } }

and code using test see if query return object:

var asdf = dbqueryexecutor.executequery(new allocatelogsforaccesspoints((string)"north gate"));

there 1 record in database fits query row in database data in entry_access_point , string "north gate". table cred.allocate_log , of columns named correctly in mapping file. furthermore, removal of mapping file or rather commenting out not result in runtime error means me nhibernate never tries use mapping file because if try (meaning commenting out contents of file) other mapping file who's query works, runtime error. entirely stumped why object remains null after executing query runs without error. ideas? update original post if require more information.

you might try downloading application called nhprof hibernating rhinos. traces nhibernate calls , shows sql nhibernate trying run. has been godsend me in trying figure out hell nhibernate trying do.


Comments

Post a Comment

Popular posts from this blog

.htaccess - First slash is removed after domain when entering a webpage in the browser -

sometimes when hit address of webpage in browser, removes first slash after domain. examples: www.mywebsite.com/scripts/script_6.php -> trying load www.mywebsite.comscripts/script_6.php www.mywebsite.com/test.php -> trying load www.mywebsite.comtest.php after entering again, loads page. a .htaccess settings must wrong: rewritebase / errordocument 404 http://www.mywebsite.com/oops.php errordocument 401 /notallowed.php rewriteengine on # turn on rewriting engine #gzip <ifmodule mod_deflate.c> addoutputfilterbytype deflate text/text text/html text/plain text/xml text/css application/x- javascript application/javascript </ifmodule> #end gzip rewritecond %{http_host} ^mywebsite\.com rewriterule ^(.*)$ http://www.mywebsite.com$1 [r=permanent,l] directoryindex index6.php rewriterule ^termsofuse/?$ termsofuse.php [nc,l] # handle requests "adpolicy" rewriterule ^privacy-policy/?$ privacy-policy.php [nc,l] # handle requ...
Read more

Automatically create pages in phpfox -

i have array of information of places , wanna use them create multiple pages in phpfox site. first tried manually insert data in phpfox database (in tables of phpfox_pages , phpfox_pages_text ). the page shown in site when opening it's link, site says: the page looking cannot found. do know other tables should manipulate make work? or know plugin phpfox same? thanks, solved ( @purefan guide): "pages" has user if take @ phpfox_user table, you'll found out how fetch new records on that. there 2 ambiguous fields in table ( password & password_salt ). can use script create values fields: <?php function generaterandomstring() { $length = 164; $characters = '-_0123456789abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz'; $randomstring = ''; ($i = 0; $i < $length; $i++) { $randomstring .= $characters[rand(0, strlen($characters) - 1)]; } return $randomstring; } $ssalt = '';...
Read more

c# - Farseer ContactListener is not working -

i'm using farseer in xna project, have trouble contactlistener. created class contactlistener these 2 error messages , don't know how fix problems. the type or namespace name 'contactlistener' not found (are missing using directive or assembly reference?) the type or namespace name 'contactimpulse' not found (are missing using directive or assembly reference?) what wrong contactlistener class? class mycontactlistener: contactlistener { void begincontact(contact contact) { /* handle begin event */ } void endcontact(contact contact) { /* handle end event */ } void presolve(contact contact, ref manifold oldmanifold) { fixture fixturea = contact.fixturea; fixture fixtureb = contact.fixtureb; if (fixtureb.collisioncategories == category.cat10) { contact.enabled = false; } } void postsolve(contact contact, ref contactimpulse impulse) { /* handle post-solve event */ } }...
Read more