- Home
- LLBLGen Pro
- Bugs & Issues
3.0 debugger visualizer error with visual studio 2008 [Method not found ToQueryText(Int32 ByRef)]
Joined: 02-Oct-2008
I am getting a method not found ToQueryText when trying to use the 3.0 debugger visualizers with vs2008 on Win7.
I copied the SqlServer / Orm / Debugger visualizer dlls to the MyDoc/Visual Studio 2008 /Visualizers directory. No other dlls are there.
I've restarted vs2008 after placing the dll files.
I have confirmed that there are no LLBLGen dlls in the GAC.
I get the same error when trying to view any type of LLBLGen object.
It used to work for me with 2.5 / 2.6...
Thanks, Timothy
This is the stack trace of the error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.MissingMethodException: Method not found: 'System.String SD.LLBLGen.Pro.ORMSupportClasses.IPredicate.ToQueryText(Int32 ByRef)'.
at SD.LLBLGen.Pro.DebugVisualizers.StringParametersVisualizerControl.VisualizePredicate(IPredicate toVisualize, String description)
at SD.LLBLGen.Pro.DebugVisualizers.PredicateVisualizerForm..ctor(IPredicate toVisualize)
at SD.LLBLGen.Pro.DebugVisualizers.PredicateVisualizer.Show(IDialogVisualizerService windowService, IVisualizerObjectProvider objectProvider)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ManagedShim.DelegatedHost.CreateViewer(IntPtr hwnd, HostServicesHelper hsh, SafeProxyWrapper proxy)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.VisualStudio.CommonIDE
Assembly Version: 9.0.0.0
Win32 Version: 9.0.30729.4450
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.CommonIDE/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommonIDE.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.VisualStudio.DebuggerVisualizers
Assembly Version: 9.0.0.0
Win32 Version: 9.0.21022.8
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.DebuggerVisualizers/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.DebuggerVisualizers.dll
----------------------------------------
SD.LLBLGen.Pro.DebugVisualizers
Assembly Version: 3.0.0.0
Win32 Version: 3.0.09.1208
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.DebugVisualizers.dll
----------------------------------------
SD.LLBLGen.Pro.ORMSupportClasses.NET20
Assembly Version: 3.0.0.0
Win32 Version: 3.0.10.0711
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.ORMSupportClasses.NET20.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Joined: 17-Aug-2003
I think you're working with an outdated debugger visualizer dll:
SD.LLBLGen.Pro.DebugVisualizers
Assembly Version: 3.0.0.0
Win32 Version: 3.0.09.1208
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.DebugVisualizers.dll
The version in the sourcecode is [assembly: AssemblyFileVersion("3.0.10.0426")]
We'll look into this, it might be the scripts building the installer don't copy the newer built file into the package.
(edit) hmm... the 2005 and 2010 version are the new build with new code, the 2008 one is old! . Will attach a new build for you a.s.a.p. and fix the buildsystem. Sorry for this inconvenience.
Joined: 17-Aug-2003
Please use the attached debugger visualizer dll for 2008. We found the issue with the build system, so next build's installer will have the proper visualizer as well.
The versions for vs.net 2005 and vs.net 2010 are the latest ones.
Joined: 02-Oct-2008
Otis wrote:
Please use the attached debugger visualizer dll for 2008. We found the issue with the build system, so next build's installer will have the proper visualizer as well.
The versions for vs.net 2005 and vs.net 2010 are the latest ones.
Tres bien, Frans -- that worked.
At first try, the sorter and relations visualizer worked correctly for me but the filter visualizer threw an error, which I've attached.
I am sure it is because my filter is incorrect (since I tried the predicate visualizer on some other queries and it worked just fine)...but I thought I would throw it up here anyway if it might provide you any information.
@Daelmo has been helping me with my original issue: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=18328
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at SD.LLBLGen.Pro.ORMSupportClasses.DbSpecificCreatorBase.CreateSubQuery(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldPersistenceInfos, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, IGroupByCollection groupByClause, Boolean allowDuplicates)
at SD.LLBLGen.Pro.ORMSupportClasses.DbSpecificCreatorBase.CreateSubQuery(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldPersistenceInfos, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, IGroupByCollection groupByClause)
at SD.LLBLGen.Pro.ORMSupportClasses.FieldCompareSetPredicate.ToQueryText(Boolean inHavingClause)
at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText(Boolean inHavingClause)
at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText(Boolean inHavingClause)
at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText()
at SD.LLBLGen.Pro.DebugVisualizers.StringParametersVisualizerControl.VisualizePredicate(IPredicate toVisualize, String description)
at SD.LLBLGen.Pro.DebugVisualizers.PredicateVisualizerForm..ctor(IPredicate toVisualize)
at SD.LLBLGen.Pro.DebugVisualizers.PredicateVisualizer.Show(IDialogVisualizerService windowService, IVisualizerObjectProvider objectProvider)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ManagedShim.DelegatedHost.CreateViewer(IntPtr hwnd, HostServicesHelper hsh, SafeProxyWrapper proxy)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.VisualStudio.CommonIDE
Assembly Version: 9.0.0.0
Win32 Version: 9.0.30729.4450
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.CommonIDE/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommonIDE.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.VisualStudio.DebuggerVisualizers
Assembly Version: 9.0.0.0
Win32 Version: 9.0.21022.8
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.DebuggerVisualizers/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.DebuggerVisualizers.dll
----------------------------------------
SD.LLBLGen.Pro.DebugVisualizers
Assembly Version: 3.0.0.0
Win32 Version: 3.0.10.0426
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.DebugVisualizers.dll
----------------------------------------
SD.LLBLGen.Pro.ORMSupportClasses.NET20
Assembly Version: 3.0.0.0
Win32 Version: 3.0.10.0711
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.ORMSupportClasses.NET20.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
This is the code that causes the visualizer to throw an error - I'm pretty sure it's because I've setup the FieldCompareSetPredicate incorrectly:
DateTime batchDateFrom = RadDatePickerBatchDateFrom.SelectedDate.Value;
DateTime batchDateTo = RadDatePickerBatchDateTo.SelectedDate.Value;
TblCustomerCollection customers = new TblCustomerCollection();
IPredicateExpression filter = new PredicateExpression();
RelationCollection relations = new RelationCollection();
SortExpression sorter = new SortExpression();
relations.Add(TblCustomerEntity.Relations.TblCodeTypeCustomerGroupsLinkEntityUsingCustId);
relations.Add(TblCodeTypeCustomerGroupsEntity.Relations.TblCodeTypeCustomerGroupsLinkEntityUsingGroupId);
if (DropDownListGroup.SelectedValue != "All Groups")
{
filter.Add(TblCodeTypeCustomerGroupsFields.GroupId == DropDownListGroup.SelectedValue);
}
relations.Add(TblCustomerEntity.Relations.TblInvoiceEntityUsingCustId);
IPredicateExpression subFilter = new PredicateExpression();
FieldCompareSetPredicate filteredByInvoiceCount = new FieldCompareSetPredicate(
TblCustomerFields.CustId, TblInvoiceFields.CustId,
SetOperator.In, null, true);
subFilter.Add(filteredByInvoiceCount);
subFilter.Add(new FieldBetweenPredicate(TblInvoiceFields.BatchDate, batchDateFrom, batchDateTo));
filter.Add(subFilter);
sorter.Add(TblCustomerFields.LastName | SortOperator.Ascending);
customers.GetMulti(filter, 0, sorter, relations);
Joined: 02-Oct-2008
Just thought I would give you this update:
I have the code working now and returning the correct results. When I try to visualize the predicate though, I still get an exception in the visualizer.
DateTime batchDateFrom = RadDatePickerBatchDateFrom.SelectedDate.Value;
DateTime batchDateTo = RadDatePickerBatchDateTo.SelectedDate.Value;
TblCustomerCollection customers = new TblCustomerCollection();
IPredicateExpression filter = new PredicateExpression();
RelationCollection relations = new RelationCollection();
SortExpression sorter = new SortExpression();
relations.Add(TblCustomerEntity.Relations.TblCodeTypeCustomerGroupsLinkEntityUsingCustId);
relations.Add(TblCodeTypeCustomerGroupsEntity.Relations.TblCodeTypeCustomerGroupsLinkEntityUsingGroupId);
if (DropDownListGroup.SelectedValue != "All Groups")
{
filter.Add(TblCodeTypeCustomerGroupsFields.GroupId == DropDownListGroup.SelectedValue);
}
if (DropDownListInvoiceOptions.SelectedValue == "CustomersWithInvoices")
{
relations.Add(TblCustomerEntity.Relations.TblInvoiceEntityUsingCustId);
IPredicateExpression subFilter = new PredicateExpression();
FieldCompareSetPredicate filteredByInvoiceCount = new FieldCompareSetPredicate(
TblCustomerFields.CustId, TblInvoiceFields.CustId,
SetOperator.In, new FieldBetweenPredicate(TblInvoiceFields.BatchDate, batchDateFrom, batchDateTo));
subFilter.Add(filteredByInvoiceCount);
filter.Add(subFilter);
}
if (DropDownListInvoiceOptions.SelectedValue == "CustomersWithoutInvoices")
{
relations.Add(TblCustomerEntity.Relations.TblInvoiceEntityUsingCustId);
IPredicateExpression subFilter = new PredicateExpression();
FieldCompareSetPredicate filteredByInvoiceCount = new FieldCompareSetPredicate(
TblCustomerFields.CustId, TblInvoiceFields.CustId,
SetOperator.In, new FieldBetweenPredicate(TblInvoiceFields.BatchDate, batchDateFrom, batchDateTo), true);
subFilter.Add(filteredByInvoiceCount);
filter.Add(subFilter);
}
sorter.Add(TblCustomerFields.LastName | SortOperator.Ascending);
customers.GetMulti(filter, 0, sorter, relations);
When I try to visualize "filter", I get this exception in vs2008:
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at SD.LLBLGen.Pro.ORMSupportClasses.DbSpecificCreatorBase.CreateSubQuery(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldPersistenceInfos, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, IGroupByCollection groupByClause, Boolean allowDuplicates)
at SD.LLBLGen.Pro.ORMSupportClasses.DbSpecificCreatorBase.CreateSubQuery(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldPersistenceInfos, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, IGroupByCollection groupByClause)
at SD.LLBLGen.Pro.ORMSupportClasses.FieldCompareSetPredicate.ToQueryText(Boolean inHavingClause)
at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText(Boolean inHavingClause)
at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText(Boolean inHavingClause)
at SD.LLBLGen.Pro.ORMSupportClasses.PredicateExpression.ToQueryText()
at SD.LLBLGen.Pro.DebugVisualizers.StringParametersVisualizerControl.VisualizePredicate(IPredicate toVisualize, String description)
at SD.LLBLGen.Pro.DebugVisualizers.PredicateVisualizerForm..ctor(IPredicate toVisualize)
at SD.LLBLGen.Pro.DebugVisualizers.PredicateVisualizer.Show(IDialogVisualizerService windowService, IVisualizerObjectProvider objectProvider)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ManagedShim.DelegatedHost.CreateViewer(IntPtr hwnd, HostServicesHelper hsh, SafeProxyWrapper proxy)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.VisualStudio.CommonIDE
Assembly Version: 9.0.0.0
Win32 Version: 9.0.30729.4450
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.CommonIDE/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommonIDE.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.VisualStudio.DebuggerVisualizers
Assembly Version: 9.0.0.0
Win32 Version: 9.0.21022.8
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.DebuggerVisualizers/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.DebuggerVisualizers.dll
----------------------------------------
SD.LLBLGen.Pro.DebugVisualizers
Assembly Version: 3.0.0.0
Win32 Version: 3.0.10.0426
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.DebugVisualizers.dll
----------------------------------------
SD.LLBLGen.Pro.ORMSupportClasses.NET20
Assembly Version: 3.0.0.0
Win32 Version: 3.0.10.0711
CodeBase: file:///C:/Users/Timothy/Documents/Visual%20Studio%202008/Visualizers/SD.LLBLGen.Pro.ORMSupportClasses.NET20.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
Joined: 21-Aug-2005
Would you please narrow down the predicate code.
i.e. remove if conditions that is not used, or better can you create a simple repro either using your database/generated code or by using another project based on Northwind.
Joined: 02-Oct-2008
Walaa wrote:
Would you please narrow down the predicate code.
i.e. remove if conditions that is not used, or better can you create a simple repro either using your database/generated code or by using another project based on Northwind.
I will try to do that when I get a chance -- for now, I'm up and running...
Thanks for all your help!
Timothy