Welcome back to the final part of this tutorial! By now, our SQLite DateTimeOffset serializer is functional, all that’s missing are a few improvements to make it more flexible. First of all, our custom implementation still does not solve the…
Read more
If you followed all the steps in the previous blog post, created your own SQLite DateTimeOffset serializer post-build task and tested it, you might wonder how to automate it. At the moment, we need to build the target assembly, register…
Read more
After settings up the basic structure of our post-build task in the previous blog post, let’s bring it two life! This post focuses on the cure steps of our CIL manipulation: Analyzing object structure, declaring new properties, and changing existing…
Read more
Welcome back to part #3 of the aspect-oriented DateTimeOffset SQLite serializer! In this part, we’re going to actually read .NET assemblies, manipulate them, and recompile them. To be able to reconstruct the solution on your side, I’d suggest that you…
Read more
What do we need to get started with our automatic DateTimeOffset-to-SQLite serialization project? Let’s begin with the simplest part: Obviously, we’ll need a custom attribute to flag those DateTimeOffset properties our solution shall handle. Create a new Class Library Project,…
Read more
Today, I’d like to present another real-life example for aspect-oriented programming and post-build reflection. The problem to be solved in a nutshell could be described as follows: How to store date / time values including timezone offset efficiently in an…
Read more
The short story: I recently received a bug ticket stating that records in a many-to-many relationship table in our SQLite database are not deleted when deleting one of the base objects. My first assumption was that this problem occurs due…
Read more
Thanks to the c# methods in the System.IO namespace accepting UNC paths, it’s rather easy to access files and directories located on a remote machine / server. For example, copying a remote file to the local machine is a one-liner:…
Read more