home recent topics recent posts search faq  

Huagati Systems Support Forum



register | lost password   open id sign in with Twitter
Messages in this topic - RSS

Home » Huagati Linq-to-SQL Profiler Support » Crqsh on SQL Trigger

Support for the Huagati Query Profiler, Huagati Linq-to-SQL Profiler, Huagati Entity Framework Profiler, Huagati LLBLGen Profiler
12/2/2011 7:47:42 PM

Jurgen Stillaert
Jurgen Stillaert
Posts: 2
Hello,

Just bought a license key and now run into a major problem.

I have set up my web application to monitor all Linq to Entities database calls in DEBUG mode.

I was now implementing Caching with a SQLCacheDependency. This needs to implement triggers in de SQL database. But everytime an updates happens on the table from the application, it gives the following crash:

The member with identity 'Microsoft SQL Server 2005 XML Showplan' does not exist in the metadata collection.
Parameter name: identity


I have been looking to several options, and finally found out that the problem lies in the Huagati dll. When turning of monitoring, it works like a charm.

Can you help me with this problem? Is there a work around?
0 permalink
12/6/2011 1:22:33 AM

Kristofer Andersson
Kristofer Andersson
Moderator
Posts: 312
Hi Jurgen,

Do you have an example of one of the tables involved and the triggers on it? That will make it easier to reproduce in-house for tracking down the cause of the problem...

Best regards,
Kristofer
0 permalink
12/6/2011 11:04:48 AM

Jurgen Stillaert
Jurgen Stillaert
Posts: 2
Hi,

I've found the solution. When you change the executionplan property to none it works, but you don't have an exection plan link of course. But that is acceptable.

Regards,
Jurgen
0 permalink

Home » Huagati Linq-to-SQL Profiler Support » Crqsh on SQL Trigger





Powered by Jitbit Forum 7.1.0.0 © 2006-2011 Jitbit Software