Simplify your local data storage with SQLite-net
Many apps today need to store data locally on the device they are running on in order to allow the user to continue to perform useful functions while offline or when network connectivity is unreliable. SQLite is an ideal solution for both simple and complex local data storage requirements. Whether you are storing small sets…
How to set up Remote Debugging for Visual Studio
From time to time it can be very useful to debug applications running on remote machines. This is particularly true when the machine you are debugging your code on features specialised built-in hardware devices, or when your application is behaving differently compared to when it is running on your development machine. Many developers know that…
SQL Server Merge Replication: Update existing merge articles in bulk
Whenever you start to scale things up with SQL Server Merge Replication automation becomes essential. This becomes very apparent when there are many subscribers connected to the publisher or when the number of articles that make up your publication is large. As part of this blog post, I am going to demonstrate how to speed…
SQL Server Merge Replication: Identity range check constraint doesn’t match identity range allocations
SQL Server Merge Replication is great when it works, but when it goes awry it can take a while to figure out what the problem is and then rectify it. In this article, I look at the cause of a specific issue where one or more identity range check constraints do not match up with…
How to install MSI packages using msiexec and C#
MSI packages remain a popular means of distributing applications for installation on Windows devices. On occasion, you may find the need to install or uninstall an MSI package programmatically, for example, whenever you need to automate a software installation or update. In this article, I’m going to show you how you can silently install and…
Implementing the Request-Response pattern using C# with JSON-RPC and WebSockets
The Request-Response pattern seems somewhat simple on the surface; send a request, then wait for and receive a response that matches up with the original request. However, implementing this pattern in an efficient manner is something that is easy to get wrong. I’ve found that much of the material online regarding this topic tends to…
SQL Server Merge Replication Error: The schema script could not be propagated to the subscriber
SQL Server Merge Replication is a powerful solution for synchronising data between SQL Server databases. It is useful for working offline, for site-to-site data synchronisation, and for backup system scenarios. However, when replication goes wrong, resolving the issue at hand can prove to be challenging. The number of moving parts means that every time you…
Working with processes using C#
As software developers, working with processes is something that we frequently need to do. Whether it’s checking if a specific process is running, stopping a process, or creating a new process, it is useful to have a reference point for how to accomplish each of these tasks. In the sections below, I’m going to cover…
