Hello,
I have few question for scenario where I have wpf/winform client(s)
connecting to windows service (hosting WCF code) which in turn
connects to (single) SQL Server.
Transactions initiated by client, in this sistem will always be distributed?
(Because it is communication between processes and computers)
Transactions should be initiated on client and WCF code should use
that client transaction when doing DB related operations?
If transactions are initiated on service side, is there a
posibility for database operation to be committed/rollbacked but client
disconnects and looses that success/error message?
How big is performance penalty when using distributed transactions?
Thank you.
Greetings,
I have few question for scenario where I have wpf/winform client(s)
connecting to windows service (hosting WCF code) which in turn
connects to (single) SQL Server.
Transactions initiated by client, in this sistem will always be distributed?
(Because it is communication between processes and computers)
Transactions should be initiated on client and WCF code should use
that client transaction when doing DB related operations?
If transactions are initiated on service side, is there a
posibility for database operation to be committed/rollbacked but client
disconnects and looses that success/error message?
How big is performance penalty when using distributed transactions?
Thank you.
Greetings,