Windows Vista Forums
Vista Forums Home Join Vista Forums Donate Vista Tutorials Tags

Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Microsoft Technical Newsgroups > WinFS

Schema Design Question

Update your Vista Drivers Update Your Drivers Now!!
 
 
Thread Tools Display Modes
Old 03-04-2006   #1 (permalink)
mabster
Guest


 

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
Display Modes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting schema.. mr t .NET General 1 04-17-2008 08:32 PM
Question on design involving some Generics Chris .NET General 0 04-06-2008 11:45 PM
RTF Question: Is this a bug or by design? Leo V Vista General 0 12-10-2007 01:02 PM
Basic design question for designing multi-screen guis rain73@gmail.com Avalon 1 04-20-2007 08:31 AM


Update your Vista Drivers Update Your Drivers Now!!

Vistax64.com 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 2005-2008