Re: Best practise: dataset and many to many relations

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Peter van der Goes (p_vandergoes_at_toadstool.u)
Date: 07/28/04 

Date: Tue, 27 Jul 2004 23:09:54 -0500

"Daniele" <danielexyz@hotmail.com> wrote in message
news:d6ffc88a.0407270651.52e36732@posting.google.com...
> Hi all,
> I'm new to dotnet and I'm trying to understand the best practise to
> solve this frequent situation:
>
> 1. web forms for data insertion and editing
> 2. one master table with 2-3 detailed tables with a "many to many
> relationship"
> These 'detailed' tables are linked to the master one with a many to
> many table
> 3. users want to add, edit and delete records.
>
> What is the best approach to implement the application with dotnet?
> I'm aware that I can specify these relationships in dotnet.
> May you help to better understand?
> Kind regards,
>
> Daniele

Hello, Daniele.
I believe we'll need some details pertaining to the tables and datasets in
question. Your reference to "many to many" relationships is a concern. as
this type of relationship is not supported in the relational model. Many to
many relationships are normally resolved using intersection entities to
produce one to many relationships, which are supported. 

-- 
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Relevant Pages

  • Re: Ideas for projects
    ... A bit offtop - what's the reason for this? ... Need some area to master your knowledge and have no idea or what? ... I thought I saw a website where people submitted ideas ... e> purpose is for novice dotNET developers to get to know dotNET. ...
    (microsoft.public.dotnet.general)
  • Best practise: dataset and many to many relations
    ... I'm new to dotnet and I'm trying to understand the best practise to ... web forms for data insertion and editing ... These 'detailed' tables are linked to the master one with a many to ...
    (microsoft.public.dotnet.academic)
  • Re: God I Love Delphi7
    ... > The problem with dotNET is simple: ... But you don't have to master everything, ... Jim Cooper ... Falafel Software http://www.falafelsoft.com ...
    (borland.public.delphi.non-technical)