Two Bugs
Posted: Fri 13 May 2016 15:12
For my first bug, I cannot open DbForge. There are five of us using the DbForge application, we have purchased 11 licenses.
3 of us cannot even open DbForge unless we uninstall the application and reinstall. Even then we still get the same issue after about a day. All we do is open the application and we are greeted with this exception(pulled from error trace):
Message: Value cannot be null.
Parameter name: implementationType
Source: Autofac
TargetSite: Autofac.Builder.IRegistrationBuilder`3[System.Object,Autofac.Builder.ConcreteReflectionActivatorData,Autofac.Builder.SingleRegistrationStyle] RegisterType(Autofac.ContainerBuilder, System.Type, System.Object[])
HelpLink:
Type: System.ArgumentNullException
Place: 1
The second bug is slightly lesser. Say you have two tables:
tblClient - ClientID(INT), ClientName(VARCHAR(255))
tblDetail - DetailID(INT), DetailName(VARCHAR(255)), ClientID(INT)
And you have a query which looks like so:
SELECT * FROM tblClient as c
LEFT JOIN (
SELECT DetailID, ClientID FROM tblDetail
) d ON c.CLIENTID = d.ClientID
It will throw an exception with the following message:
This error happens because both tables have the column name ClientID. It works if you give the ClientID an alias in the join, still a bug none the less.
=========================
Exception Information
=========================
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.DataEditor
TargetSite: Void I4QjrsactH()
HelpLink:
Type: System.NullReferenceException
Place: 1
Stack:
at Devart.DbForge.DataTableEditorControl.I4QjrsactH()
at Devart.DbForge.DataTableEditorControl.ViewData(DataTable newDataTable)
3 of us cannot even open DbForge unless we uninstall the application and reinstall. Even then we still get the same issue after about a day. All we do is open the application and we are greeted with this exception(pulled from error trace):
Message: Value cannot be null.
Parameter name: implementationType
Source: Autofac
TargetSite: Autofac.Builder.IRegistrationBuilder`3[System.Object,Autofac.Builder.ConcreteReflectionActivatorData,Autofac.Builder.SingleRegistrationStyle] RegisterType(Autofac.ContainerBuilder, System.Type, System.Object[])
HelpLink:
Type: System.ArgumentNullException
Place: 1
The second bug is slightly lesser. Say you have two tables:
tblClient - ClientID(INT), ClientName(VARCHAR(255))
tblDetail - DetailID(INT), DetailName(VARCHAR(255)), ClientID(INT)
And you have a query which looks like so:
SELECT * FROM tblClient as c
LEFT JOIN (
SELECT DetailID, ClientID FROM tblDetail
) d ON c.CLIENTID = d.ClientID
It will throw an exception with the following message:
This error happens because both tables have the column name ClientID. It works if you give the ClientID an alias in the join, still a bug none the less.
=========================
Exception Information
=========================
Message: Object reference not set to an instance of an object.
Source: Devart.DbForge.DataEditor
TargetSite: Void I4QjrsactH()
HelpLink:
Type: System.NullReferenceException
Place: 1
Stack:
at Devart.DbForge.DataTableEditorControl.I4QjrsactH()
at Devart.DbForge.DataTableEditorControl.ViewData(DataTable newDataTable)