Choose between one-to-one and component in NHibernate -


i trying map classes user , profile, following:

public class user {     public long id { get; set; }     public string loginname { get; set; }     public profile profile { get; set; } }  public class profile {     //the id same user's id      public long id { get; protected set; }     public string nickname { get; set; }     public gender gender { get; set; } }

so, can mapped both one-to-one , componenet relationship. , find people appraise component , think one-to-one bad practise, why? performance reason? designed 2 separate tables in many scenarios(asp.net2.0 membership, example).

how should choose? aspects should consider? know component means "value object" not enitity, mean further things?

ps: , confused me more opinion many-to-one should used it's one-to-one relationship in real world!

you should use neither.

one-to-one

you have user , profile in different database tables both share mutually exclusive pk: see http://jagregory.com/writings/i-think-you-mean-a-many-to-one-sir/

pretty bad design practice relational databases, it's messy , not enforce constraints relationship.

component

you can use component clean object-model messy relational database, profile , user data both stored in same database table should separated in object model (like want it, judging code). lazy loading isn't supported, cause high database traffic.

reference

imho, should use reference. it's conceptual kinda one-to-one user references profile. profiles can stored in own table, can loaded lazily (performance) , not dependent on user.

regarding confusion: read link supplied. technically, need many 1 designed database-scheme, technically possible , mapped. know it's confusing. if need map one-side, think of reference instead of one-to-one.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc...
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use...
Read more