Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > WinFS

Vista - Schema Design Question

 
 
Old 03-04-2006   #1 (permalink)
mabster


 
 

Schema Design Question

Ok, I'm stumped here.

Suppose I have a schema consisting of publishers and books. Each book is
published by one and only one publisher. So in the classic sense it's a
"one to many" relationship.

My schema looks something like this:

<EntityType Name="Publisher" BaseType="Contacts.Organization">
<Documentation>...</Documentation>
<ChangeUnit Name="Publisher" Id="1" />
</EntityType>

<EntityType Name="Title" BaseType="Storage.Item">
<Documentation>...</Documentation>
<ChangeUnit Name="Title" Id="1" />
<Property Name="Volume" Type="Storage.Int32" Nullable="true"
ChangeUnit="Title" />
<Property Name="Year" Type="Storage.Int16" Nullable="true"
ChangeUnit="Title" />
<Property Name="Details" Type="Storage.String" Size="2000"
Nullable="true" ChangeUnit="Title" />
</EntityType>

How do I associate these two items?

I have tried adding an Association, like this:

<Association Name="PublisherTitles">
<Documentation>...</Documentation>
<End Role="Publisher" PluralRole="Publishers"
Type="Comicster.Publisher" />
<End Role="Title" PluralRole="Titles" Type="Comicster.Title" />
<Reference FromRole="Publisher" Property="Titles" ToRole="Title" />
</Association>

.... but that throws "error AG0066: Invalid Property on AssociationEntity
Reference. Property Titles is not a member of type
MadProps.Comicster.Storage.Publisher."

How do I define the "Publisher.Titles" property that gives me a list of
that publisher's titles? Or conversely, how can I define a
"Title.Publisher" property that refers back to the title's publisher?

I'm just finding it difficult to make the mental leap from classical
database design to WinFS schema design.

Thanks in advance,
Matt

My System SpecsSystem Spec
 

Thread Tools


Similar Threads
Thread Forum
OO design question .NET General
XML with schema .NET General
Question on design involving some Generics .NET General
RTF Question: Is this a bug or by design? Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46