Possible bug with MySqlDataset.Tables["blah"].ChildRelations.Clear()

[ashlar64]

Hello,

I am wondering if I have stumbled upon a bug?

Here is the code snippet...please note that there is one child relation when a exception is thrown (if there isn't this code does work). The .ChildRelations.Count does go down to 0.



dataset_nds_sites.Tables["Site_ID"].ChildRelations.Clear();
dataset_nds_sites.Tables["Site_ID"].Clear(); // this is where the exception is thrown
adapter_Site_ID.Fill(dataset_nds_sites.Tables["Site_ID"]);


Here is the exception:

System.Data.InvalidConstraintException was unhandled
Message="Cannot clear table Site_ID because ForeignKeyConstraint Scheduler2_To_Site_ID enforces constraints and there are child rows in Scheduler2."
Source="System.Data"
StackTrace:
at System.Data.ForeignKeyConstraint.CheckCanClearParentTable(DataTable table)
at System.Data.DataTable.Clear(Boolean clearAll)
at System.Data.DataTable.Clear()
at iGlimpse2.Window1.Button_Refresh_Site_ID_Click(Object sender, RoutedEventArgs e) in C:\expression\projects\iGlimpse2\Window1.xaml.cs:line 2287
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e)
at System.Windows.Controls.Button.OnClick()
at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.ReRaiseEventAs(RoutedEventArgs args, RoutedEvent newEvent)
at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Boolean isSingleParameter)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Boolean isSingleParameter, Delegate catchHandler)
at System.Windows.Threading.Dispatcher.InvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Boolean isSingleParameter)
at System.Windows.Threading.Dispatcher.Invoke(DispatcherPriority priority, Delegate method, Object arg)
at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
at System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
at System.Windows.Threading.Dispatcher.Run()
at System.Windows.Application.RunInternal(Window window)
at System.Windows.Application.Run(Window window)
at System.Windows.Application.Run()
at iGlimpse2.App.Main() in C:\expression\projects\iGlimpse2\obj\Debug\App.g.cs:line 0
InnerException:

[Alexey.mdr]

Hello,

Please send me (alexeyman*crlab*com) a small test project to
reproduce the problem.
It is desirable to use 'test' schema objects, otherwise
include the definition of your own database objects.
If it is impossible for you to create the test project, send
us a piece of your code where the error occurs or describe steps to
reproduce the problem.
What is the version/edition of the product you use?

Regards,
Alexey.

[ashlar64]

Hello,

I got the latest 4.70.20.0 and I am still getting a exception....I made a test program which I am about to send you but am getting a different exception now.

[Alexey.mdr]

Hello again,

You can send the project directly to my email.
I will reply you as soon as possible.

Regards,
Alexey.

[ashlar64]

Hello Alexey,

I sent a sample project a few days ago....just wanted to make sure you got it?

[Alexey.mdr]

Hello,

Unfortunately we didn't receive the email.
Could you please resend it on alexeyman*devart*com and to mysqlnet*devart*com?

Regards,
Alexey.

[ashlar64]

Hello Alexey,

I sent a sample project awhile back. I am just wondering about the status of it.

---Dave

[anton.connect]

Hello

Unfortunately we didn't receive the email again.
Could you please resend it on antonc*devart*com from another address?

Regards,
Anton.