The MSSQL backend was missing support for suspend/resume. It also made some bad assumptions about how it would eventually behave when introduced, so some existing logic needed to be removed.
I also bundled a couple additional minor fixes into this PR:
Fixed inconsistent exception throwing in SqlOrchestrationService.WaitForOrchestrationAsync (realized this was a problem while writing my suspend/resume test)
Fixed minor issue with default DateTime handling (force it to always be UTC) - this is an issue with certain kinds of serializers, like protobuf, which reject DateTime values that aren't explicitly UTC (found this doing some unrelated exploratory prototyping).
Fixes https://github.com/microsoft/durabletask-mssql/issues/181
The MSSQL backend was missing support for suspend/resume. It also made some bad assumptions about how it would eventually behave when introduced, so some existing logic needed to be removed.
I also bundled a couple additional minor fixes into this PR: