LLBLGen Pro version + buildnr.: 3.5 Final - September 17th, 2012 Runtime library version: 3.5.12.1004 .NET version: 4.0 Database: MS SQL 2008R2

Problem description: In a part of our application we have two panels that communicate with each other via events. In both panels we use the same data retrieved with llblgen from de database. It is not possible to refetch data, because of the amount of data. When something happens in pannel1, remove of entity, we try to update the entity collection on client side. Now, without refetch, panel2 knows about it. In some sircumstances, after save entity, we become an exeption like: "An exception was caught during the execution of an action query: ..." In the database profiler we noticed that a select statement is executed that we did not expect at all. I'm not understandig this and we are try to fix it for several days, but did not succeed.

Question: How can i investicate this problem, to know where it go's wrong? Do you have sugestions for use about use of LLBLGen?

Exception is displayed with following code: SaveChanges(ControlModule) DataStore.FetchControlModules(ControlModule) Dim dataErrorInfo As IDataErrorInfo = TryCast(ControlModule, IDataErrorInfo) If dataErrorInfo IsNot Nothing AndAlso Not String.IsNullOrEmpty(dataErrorInfo.Error) Then MessageBox.Show(dataErrorInfo.Error, Title, MessageBoxButtons.OK, MessageBoxIcon.Error) ControlModule.SetEntityError("")

We take a look in our code, and db triggers first, so we come back on this issue later.

Meindert wrote:

We take a look in our code, and db triggers first, so we come back on this issue later.

Should we interpret that as solved or just stand-by while you look at your db trigger? Anyway, if the problem persists you should provide more info, like what does DataStore.FetchControlModules(ControlModule), the generated SQL, and the part of "under some circumstances" is important so we can see exactly what is going on.