473,473 Members | 2,136 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Typed Data Set and relations

I've a fairly complex schema which I'm trying to create a typed data set
for.

I've had a number of issues to date but it is sort of working (e.g. elements
are not considered nullable unless minOccurs="0" is present. If not the
codegen:nullValue attribute is ignored).

What I'm seeing at the moment is that if I do NOT add in key and key ref
relations, the cs generated puts in sensibly named relations with
appropriate accessors. But they don't work.

If I put in explicit key refs I get pairs of relations defined for each
'real' relation. The ones added corresponding to the explicit relation
work. How can I get rid of the others (the default ones)?

Oh and I am totally unable to get the typedName and typedPlural to do
anything useful.

Can anyone help?

iain
Nov 12 '05 #1
1 1553
The thing I was doing wrong was that I had the child tables defined as
elements of the master tables.

So xsd inferred a relation from that, but also added in a relation from the
explicitly defined ones.

When I moved the child tables definitions into separate elements it all
started to work! (I also seem to have missed a key column out at some point
in my meanderings which is why one of the data relations wasn;t finding any
children).

Iain
"Iain" <id********@dircon.co.uk> wrote in message
news:#c**************@TK2MSFTNGP11.phx.gbl...
I've a fairly complex schema which I'm trying to create a typed data set
for.

I've had a number of issues to date but it is sort of working (e.g. elements are not considered nullable unless minOccurs="0" is present. If not the
codegen:nullValue attribute is ignored).

What I'm seeing at the moment is that if I do NOT add in key and key ref
relations, the cs generated puts in sensibly named relations with
appropriate accessors. But they don't work.

If I put in explicit key refs I get pairs of relations defined for each
'real' relation. The ones added corresponding to the explicit relation
work. How can I get rid of the others (the default ones)?

Oh and I am totally unable to get the typedName and typedPlural to do
anything useful.

Can anyone help?

iain

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jordan O'Hare | last post by:
Hello Everyone, I am after some help with the following: I have a windows application that contains a list box and two data grids. All three controls are binded to a dataset that contains...
1
by: Iain | last post by:
I'm struggling to create a typed data set (with xsd.exe) with 4 tables and 3 layers orders -> Items Items->ItemAtts1 Items->ItemAtts2 if you follow me. it's kind of working, but I don't...
3
by: Duncan Welch | last post by:
I have a strongly typed dataset that returns two tables - "items" and "itemdetails". In the strongly-typed dataset designer, I've created a link (relationship) between the two tables based on a...
0
by: Joe Van Meer | last post by:
Hi all, I have a question regarding data relations within a data set. Say I have 3 tables named CLIENT, BOOKING and EMPLOYEE and I wanted to relate the first two tables (CLIENT AND BOOKING)...
1
by: Mat | last post by:
i have create ,using vs.net, typed dataset with relations. I would like to ask if it exists a tool,which can take the xml schema of typed dataset and generate equivalent SQL queries with...
0
by: Liming | last post by:
Hi, I designed a few DataSet Tables in the typed dataset dsigner. Recently, I encountered an error saying Failed to enable constraints. One or more rows contain values violating non-null,...
2
by: Scotty | last post by:
I get stuck to write an update, insert and delete command, i am looking for some help to start Whats the best way to update 2 tables toe the database (Access) below my code used to load my...
3
by: =?Utf-8?B?SXbDoW4gUMOpcmV6?= | last post by:
Hi there, I have a question that has been raised on how an application should handle the data that is travelling through a three-layered application. Our data is going to be handled by Dataset...
4
by: Rachana | last post by:
Hi, I have understood Data Sets but what is meant by typed/untyped/ strongly typed datasets. Can any one explain me or suggest any site/ article, to get these concepts (and their ...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.