ExamGuru IT/.Net Guru : Best practise: dataset and many to many relations on microsoft.public.dotnet.academic

.NETGURU

Best practise: dataset and many to many relations

Messages

Related Types

This message was discovered on microsoft.public.dotnet.academic.

Daniele

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

Reply to this message...

Peter van der Goes

"Daniele" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

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.

Reply to this message...

Daniele

Peter,
that's what we have!
In details:

1. master table Experts
2. intersecation table tbl_Ezperts_Skill
3. table with available Skills

There is a relation many to many amid Expert and skills.

--> 3 detailed tables with 3 intersaction tables <--

Globally we have:

a. 1 master table
b. 3 intersactions tables
c. 3 detailed tables

As web form we want a UNIQUE form (not a grid!) to edit/add records.
What 's the best approach?
Kind regards,

Daniele

[Original message clipped]

Reply to this message...

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification