Important question about .NET 2.0 datasets...

Dave

We've created a robust client server application over the past 3 years
on the .NET framework version 1.1 using c#. We layed all of our
marbles in creating strongly typed datasets and for the most part we
are extremely happy we did that.

However, there's an incredibly huge bug (in my opinion) that has cost
us probably on the order of at least 40 hours of development time in
tracking down this bug and doing several small scale re-writes. I
don't even know the name of the bug, but it shows itself if you meet
the following requirements:
- Use Datasets
- Use DataRelations
- Use Expression columns
The bug occurs when you perform database Inserts and Updates on tables
that use expression columns and have datarelations. There is an
exception that get's thrown from within the .NET framework... there
have been many posts about it, but unless you meet all the requirements

above, you may not even know this bug exists. It's been a while, so i
don't remember what the specific Exception was...
Here's some people who have the same problem...
http://groups.google.com/group/micro...framework.adon...

http://groups.google.com/group/micro...framework.adon...

Microsoft has acknowledged this as a bug.
We waited and waited 2+ years for a fix for this and I'm absolutely
amazed that it was never addressed. My only guess is that it was too
big of a re-write and they decided to wait until 2.0 to fix it (I
hope). I'm amazed because of how much Microsoft want's everyone in the
world to switch to .NET and Datasets lie at the heart of the .NET
codebase.
Anyway my question is, does anybody know if this is fixed in .NET 2.0?
Thanks,
Dave

May 26 '06 #1

Subscribe Reply

1249

Lebesgue

How about trying your code that was broken in .NET 1.1 and telling us if
it's working in 2.0?

"Dave" <ch********@yah oo.com> wrote in message
news:11******** *************@j 73g2000cwa.goog legroups.com...

We've created a robust client server application over the past 3 years
on the .NET framework version 1.1 using c#. We layed all of our
marbles in creating strongly typed datasets and for the most part we
are extremely happy we did that.

However, there's an incredibly huge bug (in my opinion) that has cost
us probably on the order of at least 40 hours of development time in
tracking down this bug and doing several small scale re-writes. I
don't even know the name of the bug, but it shows itself if you meet
the following requirements:
- Use Datasets
- Use DataRelations
- Use Expression columns
The bug occurs when you perform database Inserts and Updates on tables
that use expression columns and have datarelations. There is an
exception that get's thrown from within the .NET framework... there
have been many posts about it, but unless you meet all the requirements

above, you may not even know this bug exists. It's been a while, so i
don't remember what the specific Exception was...
Here's some people who have the same problem...
http://groups.google.com/group/micro...framework.adon...

http://groups.google.com/group/micro...framework.adon...

Microsoft has acknowledged this as a bug.
We waited and waited 2+ years for a fix for this and I'm absolutely
amazed that it was never addressed. My only guess is that it was too
big of a re-write and they decided to wait until 2.0 to fix it (I
hope). I'm amazed because of how much Microsoft want's everyone in the
world to switch to .NET and Datasets lie at the heart of the .NET
codebase.
Anyway my question is, does anybody know if this is fixed in .NET 2.0?
Thanks,
Dave

May 28 '06 #2

Nicholas Paldino [.NET/C# MVP]

This isn't the first time that you have posted this. You should compile
the code in .NET 2.0 and just see if it has been fixed.

If not, then file the bug at the Product Feedback Center so that they
know it exists (unless it is filed there already). If it is not there, then
it is not in their bug tracking system.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Dave" <ch********@yah oo.com> wrote in message
news:11******** *************@j 73g2000cwa.goog legroups.com...

We've created a robust client server application over the past 3 years
on the .NET framework version 1.1 using c#. We layed all of our
marbles in creating strongly typed datasets and for the most part we
are extremely happy we did that.

However, there's an incredibly huge bug (in my opinion) that has cost
us probably on the order of at least 40 hours of development time in
tracking down this bug and doing several small scale re-writes. I
don't even know the name of the bug, but it shows itself if you meet
the following requirements:
- Use Datasets
- Use DataRelations
- Use Expression columns
The bug occurs when you perform database Inserts and Updates on tables
that use expression columns and have datarelations. There is an
exception that get's thrown from within the .NET framework... there
have been many posts about it, but unless you meet all the requirements

above, you may not even know this bug exists. It's been a while, so i
don't remember what the specific Exception was...
Here's some people who have the same problem...
http://groups.google.com/group/micro...framework.adon...

http://groups.google.com/group/micro...framework.adon...

Microsoft has acknowledged this as a bug.
We waited and waited 2+ years for a fix for this and I'm absolutely
amazed that it was never addressed. My only guess is that it was too
big of a re-write and they decided to wait until 2.0 to fix it (I
hope). I'm amazed because of how much Microsoft want's everyone in the
world to switch to .NET and Datasets lie at the heart of the .NET
codebase.
Anyway my question is, does anybody know if this is fixed in .NET 2.0?
Thanks,
Dave

May 28 '06 #3

Dave

Hey Nicholas,

Yes, this is my 2nd post... Our product is in a state where there are
many hacks in place to prevent these bugs from happening. For example,
removing and re-adding DataSet relations before and after Inserts and
Updates seems to fix many of the problems (among other hacks)... It
would take a significant amount of work in order for us to eventually
find out if this was fixed or not. I'm simply trying to see if other
developers have come across this or not, as some initial "due
dillegence".

This bug is already in thier bug tracking system for 1.1.

Tx,
Dave

Nicholas Paldino [.NET/C# MVP] wrote:

This isn't the first time that you have posted this. You should compile
the code in .NET 2.0 and just see if it has been fixed.

If not, then file the bug at the Product Feedback Center so that they
know it exists (unless it is filed there already). If it is not there, then
it is not in their bug tracking system.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Dave" <ch********@yah oo.com> wrote in message
news:11******** *************@j 73g2000cwa.goog legroups.com...
We've created a robust client server application over the past 3 years
on the .NET framework version 1.1 using c#. We layed all of our
marbles in creating strongly typed datasets and for the most part we
are extremely happy we did that.

However, there's an incredibly huge bug (in my opinion) that has cost
us probably on the order of at least 40 hours of development time in
tracking down this bug and doing several small scale re-writes. I
don't even know the name of the bug, but it shows itself if you meet
the following requirements:
- Use Datasets
- Use DataRelations
- Use Expression columns
The bug occurs when you perform database Inserts and Updates on tables
that use expression columns and have datarelations. There is an
exception that get's thrown from within the .NET framework... there
have been many posts about it, but unless you meet all the requirements

above, you may not even know this bug exists. It's been a while, so i
don't remember what the specific Exception was...
Here's some people who have the same problem...
http://groups.google.com/group/micro...framework.adon...

http://groups.google.com/group/micro...framework.adon...

Microsoft has acknowledged this as a bug.
We waited and waited 2+ years for a fix for this and I'm absolutely
amazed that it was never addressed. My only guess is that it was too
big of a re-write and they decided to wait until 2.0 to fix it (I
hope). I'm amazed because of how much Microsoft want's everyone in the
world to switch to .NET and Datasets lie at the heart of the .NET
codebase.
Anyway my question is, does anybody know if this is fixed in .NET 2.0?
Thanks,
Dave

May 31 '06 #4

Similar topics

1738

Only some datasets shows in the Solution Explorer of VS.net 2003?

by: Alpha | last post by:

I have a small Window application and through out the different forms I create a different dataset. At the begining I used the Tools to drag and drop the SqlDataAdapter, connection and dataset objects to the frist few forms but then later I removed those and created these objects in my code. I now see 3 datasets in the Solution Explorer panel part but not all the datasets that I have in my codes. Are these 3 datasets leftover from the...

C# / C Sharp

1728

*very* basic question about design of ado.net

by: Steve | last post by:

Sorry in advance for my ignorance. Any help would sure be appreciated. I'm writing a fairly simple application with VB.Net and am obviously a bit of a newbie. This application will be used by 1, 2 or at most 3 people concurrently and I'm using Access 2003 for my data source. We are not dealing with a large amount of data (5 or 6 tables, for a total of maybe 3,000 records - one table having the majority of that). This application is...

Visual Basic .NET

2918

2.0 DataSources vs. TableAdapter/Datasets

by: GaryDean | last post by:

We have been noticing that questions on vs.2005/2.0 don't appear to get much in answers so I'm reposting some questions posted by some of the programmers here in our organization that never got answered... There are articles on the new TableAdapters where it says that a key new advantage is that a single TableAdapter, which can have multiple queries, can be used on multiple forms. Now that was in an article on using TableAdapters with...

ASP.NET

1340

Important question about .NET 2.0 DataSets

by: Dave | last post by:

C# / C Sharp

1288

Question about Datasets and ASP.NET

by: Ryan | last post by:

I'm in the process of learning more about building my ASP.NET website to use my SQL datastore and am a bit confused about how ADO.NET works with ASP.NET. This Microsoft article implies that using ADO.NET with ASP.NET applications is the way of the past because newer controls allow you to do all your data binding declaratively. http://msdn2.microsoft.com/en-us/library/ms178359(d=ide).aspx However, I haven't been able to get my application...

Visual Basic .NET

9923

Typed vs untyped datasets

by: Ronald S. Cook | last post by:

I've always used untyped datasets. In a Microsoft course, it walks through creating typed datasets and harps on the benefits. It has you drag all these things around ..wizard, wizard, wizard... code gen, code gen, code gen. What's at the end looks slick, but then there's a ton of generated code that I'm going to have to maintain now. I.e. I like typing things myself (don't like wizards) so I can know exactly what I've done.

C# / C Sharp

1369

Please help, about primary key and dataset

by: Warex | last post by:

I am using the example from the microscuzz site on making a key but It keeps giving me an error: With DataSets.Tables("Numbers") .PrimaryKey = New DataColumn() {.Columns("Number")} End With Error: Object reference not set to an instance of an object.

Visual Basic .NET

1274

Who can reply this question about Memory limit reached,Aspnet_wp recycled?

by: xievvv | last post by:

We are experiencing a memory leak in one of our applications. It is a web-based reporting system that produces large (> 500mb) PDF reports. It takes approx 4 hours to run the largest of these reports and during this process we have been experiencing issues with the aspnet worker process being recycled as the application's memory keeps growing to around 600mb. From my investigation, it appears that the memory is becoming bloated with character...

.NET Framework

1372

StronglyTyped DataSets in ASP.NET 2.0

by: S.Tedeschi | last post by:

Hi all gurus. I'm trying to switch to VS 2005, from VS 2003. I've an ASP.NET 1.1 app heavily relying on StronglyTyped DataSets, with lots of FindByKey..., dataSet.Tablename, and similar methods. Converting to ASP.NET 2.0 leaves dataSets' classes unconverted, as stated by M$; what's worse, I'm not able to use converted dataSets, nor new ones, but just non- typed dataSets declared directly in pages (or code-behind), and so I'm not allowed...

ASP.NET

9553

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10509

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10281

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10256

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10039

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7584

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5477

Trying to create a lan-to-lan vpn between two differents networks

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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4152

transfer the data from one system to another through ip address

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 we have to send another system

C# / C Sharp

2953

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General