SQL Compact 3.5 on a 64 bit Windows

SQL Compact is a great little database and highly recommended. However it was designed for use on small compact, hence its name, devices and that has some drawbacks. One of these is that it doesn’t run as a 64 bits application. And by default if you create a .NET application it is compile as “Any CPU” meaning it will run as a 64 bits application on a 64 bits version of Windows. I, or I should say Ron Jacobs, ran into that using my SqlCeWorkflowPersistenceService because the sample/test application  was set to the default of “Any CPU”. The result is … Continue reading SQL Compact 3.5 on a 64 bit Windows

SQL Server Compact Workflow Persistence Service updated

I have just updated the SQL Server Compact Workflow Persistence Service to better handle deserialization issues when loading a workflow. The service now makes sure the WorkflowRuntime ServicesExceptionNotHandled is raised, something it should have done in the first place. You can download the SQL Server Compact Workflow Persistence Service from here.   Enjoy! www.TheProblemSolver.nlhttp://wiki.WindowsWorkflowFoundation.eu

FaultHandlerActivity and workflow persistence

I was just working on an issue reported against the SQL Server Compact Workflow Persistence Service I released some time ago. It turns  that if you are using workflow persistence your workflow will actually be persisted to the store when an exception is caught. Now in itself not a big problem as your whole workflow needs to be serializable anyway. Except this time where is an additional exception object and when the exception itself cannot be serialized this brings the whole workflow down. In fact it brings more that just the workflow as the whole workflow runtime crashes, not good … Continue reading FaultHandlerActivity and workflow persistence