I can force the designer to split it into 2 by adding a dummy field on Composite...not ideal.....
I expect I can hand code it, but I think that's beyond me, and despite not being a fan of wizards, I actually think (from experience with datasets) that one of the biggest selling points is the rapid creation/recreation of typesafe schemas. (For the moment I'll add a dummy field). > -----Original Message----- > From: Discussion of advanced .NET topics. [mailto:ADVANCED- > [EMAIL PROTECTED] On Behalf Of Nicholls, Mark > Sent: 28 August 2008 10:48 > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: [ADVANCED-DOTNET] Entity framework designer too clever for it's > own good... > > Hello, > > not sure this is a sensible place to post this, but I'll give it a do. > > I've got a problem implementing something similar to the composite > pattern in the entity framework using single class = single table > inheritance. > The composite can only have 1 child. > > We've got a table > > Component > ComponentID int (primary key, auto increment) (identity) > > Composite > ComponentID int (PK and FK into ComponentID) (identity) > PartID int (FK into ComponentID) > > > Now put it through the import 'wizard' and it's too clever by half...i.e. > it doesn't do what I want it to... > > It basically creates a single entity called Component, and then makes the > partID a self reference, there is no Composite Entity... > > While this makes logical sense, Composites are just Components with a > reference and Non Composites are ones with none...it's not what I want. > > Any ideas? > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com CONFIDENTIALITY NOTICE This e-mail (and any attached files) is confidential and protected by copyright (and other intellectual property rights). If you are not the intended recipient please e-mail the sender and then delete the email and any attached files immediately. Any further use or dissemination is prohibited. While MTV Networks Europe has taken steps to ensure that this email and any attachments are virus free, it is your responsibility to ensure that this message and any attachments are virus free and do not affect your systems / data. Communicating by email is not 100% secure and carries risks such as delay, data corruption, non-delivery, wrongful interception and unauthorised amendment. If you communicate with us by e-mail, you acknowledge and assume these risks, and you agree to take appropriate measures to minimise these risks when e-mailing us. MTV Networks International, MTV Networks UK & Ireland, Greenhouse, Nickelodeon Viacom Consumer Products, VBSi, Viacom Brand Solutions International and Comedy Central are all trading names of MTV Networks Europe. MTV Networks Europe is a partnership between MTV Networks Europe Inc. and Viacom Networks Europe Inc. Address for service in Great Britain is UK House, 180 Oxford Street, London W1D 1DS, UK. =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
