Conversation handle 00000000-00000 etc. not found

[OriginalDREiD]

I have been using SQLDepency for my application for a while and came across yours which looks great for my requirements.

I got the code up and running but one I've started the tabledependency, edits to the table results in the conversation handle 00000000-0000-0000-0000-000000000000 is not found.

If I stop the tabledependency, edits work fine.

Thanks.

[elclon]

Hi, I have the same problem! How did you solve it?

[OriginalDREiD]

@elclon unable to solve. Hoping @christiandelbianco can help me out.

[igitur]

This is a regression introduced by 51847dc .

@christiandelbianco It seems like you very deliberately moved the this.ConversationHandle = this.BeginConversation(sqlCommand); to after the preparation statements, but some of those preparation statements depend on the conversation GUID.

[OriginalDREiD]

Thank you @igitur, moving the block back to the original position resolved the issue for me.

[igitur]

I don't think this issue should be closed until @christiandelbianco comments on it.

[christiandelbianco]

@igitur 👍

[christiandelbianco]

I immediately move this.ConversationHandle = this.BeginConversation(sqlCommand); where it was before

[igitur]

Great, thanks @christiandelbianco . PS: I discovered this project only last week. Great work!

[christiandelbianco]

@igitur As you found the resolution , i will put in Contributors page, if you do not mind

[igitur]

As you found the resolution , i will put in Contributors page, if you do not mind

No problem. I'm planning to submit a PR soon anyway.

[christiandelbianco]

Fix in version 7.5.0

[christiandelbianco]

@igitur : https://github.com/christiandelbianco/monitor-table-change-with-sqltabledependency/wiki/Contributors

[OriginalDREiD]

Thank you, gentlemen.