Dataset generation and relation rules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In VS.NET 2003 if you use sqldataadapters at design time to create your dataset there is problem : after you regenrate a dataset the relation rules are set all to default. Any quick hint to avoid this?
 
Hi Alex,

Can you be a more specific?
How do you regenerate the dataset?
What exactly is set to default?

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Alex Pop said:
In VS.NET 2003 if you use sqldataadapters at design time to create your
dataset there is problem : after you regenrate a dataset the relation rules
are set all to default. Any quick hint to avoid this?
 
Hi Alex,

Ah, I see.
I guess that is a feature of the wizard.
You might try my template for generating strong typed datasets instead - it
generates xsd schema for given tables.
See:
http://www.rthand.com/default.aspx?Page=2&SubPage=1#5

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Alex Pop said:
----- Miha Markic wrote: -----

Hi Alex,

Can you be a more specific?
How do you regenerate the dataset?
What exactly is set to default?

It's about a typical dataset generation at design time, based on the
dataadapters that are mapped each on a database table. Let's say that I
generated my dataset in this way ,then I create the relations, i set to each
relation its rules( e.g. UpdateRule for a relation "TABLE1_TO_TABLE2" is set
to Cascade ). Then if I modify something in my database then I update my
dataadapters and regenerate the dataset to refelct changes I got all my
rules of relations set to "Default"
 
Yes , I guess also that is a bug or an issue in dataset design time generation tool. I bookmarked your page anyway for future use if I don't find a quick solution for this.
10x
 
Back
Top