This recipe will cover the use of OrmLite filters and how they can be used to audit what is being added, updated, and deleted in your database. We will also go over the creation of ResultFilter for OrmLite and how this could be incorporated into your own project. In Chapter 1, Configuration and Routing we wrapped this functionality into a plugin, while focusing on the plugin interface. In this recipe we will have a closer look at OrmLite filters.
In this example, we will use the PlacesToVisit domain to show how OrmLite filters can be used to help with requirements such as auditing or protecting sensitive information coming out of your database. To get started, you'll need a new project created either using a template from the ServiceStackVS extension or by following the section Creating a ServiceStack solution with Visual Studio and NuGet in Appendix A, Getting Started.