DB2 Fluent NHibernate mapping duplicate records in HasMany mapping -

-

i accessing pre-existing database (actually db2 on ibm i), , have issue mappings following (simple) structure in fluent nhibernate. have had construct artificial example, forgive ommissions.

job ...

public class job {     public virtual string jobcode { get; set; }      public virtual string owner{ get; set; }      public virtual ilist<deliverable> deliverables { get; set; }      public job()     {         deliverables = new list<deliverable>();     } }

deliverable ..

public class deliverable {     public virtual string jobcode { get; set; }      public virtual int package { get; set; }      public virtual string owner { get; set; }      public virtual string reference { get; set; }      public virtual job job { get; set; } }

i trying map 'hasmany' relationship between job , deliverable, follows ..

public class jobmap : classmap<job> {     public jobmap()     {         table("job");          id(x => x.jobcode).column("code");          map(x => x.owner).column("whodo");          hasmany(x => x.deliverables)             .keycolumn("code");     } }  public class deliverablemap : classmap<deliverable> {     public deliverablemap()     {         table("deliverable");          id(x => x.jobcode).column("code");          map(x => x.reference).column("unqref");          map(x => x.owner).column("whodo");          references( x => x.job)              .column("code") ;     } }

this seems work, , if take sql produced, , run directly, correct results returned (in case 11 records, unique). when following, list of deliverables has 11 entries identical.

ilist results = session .createcriteria(typeof(job)) .add(expression.eq("code", "206171")) .list();

foreach (var job in results) {    console.writeline("job.jobcode" + job.jobcode);    console.writeline("job.owner" + job.owner);     foreach (var deliverable in job.deliverables)    {       **// these identical!**       console.writeline(deliverable.reference);      console.writeline("deliverable.owner" + deliverable.owner);      console.writeline(deliverable.jobnumber);      console.writeline(deliverable.deliverabletyoe);      console.writeline(deliverable.description);    } }

so, mappings incorrect, or there way using them?

many in advance, have been staring @ day.

i seem have fixed it. added compositeid deliverables mapping

 compositeid()      .keyproperty(x => x.jobcode, "code")      .keyproperty(x => x.reference, "unqref");

this meant had override following in deliverable class

public override bool equals(object obj) {   if (obj == null)     return false;    var t = obj deliverable;   if (t == null)     return false;    if (jobcode == t.jobcode && reference == t.reference)     return true;    return false;  }    public override int gethashcode()   {     return (jobcode + "|" + reference).gethashcode();   }

and changed job mapping below

 hasmany(x => x.deliverables)    .keycolumn("codex")    .inverse()    .cascade.all();

i not sure of these has corrected situation (i suspect .inverse() in job mapping.

i not sure generated sql looks like, answers correct.


Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more