The Problem

When you are using SQLite in conjunction with Guids, NH Prof will show formatted queries that will not find any data in the database, even if the data actually exists.

The actual reason is related to the way SQLite parses guids. Since it isn't actually aware of guids, SQLite treats them as strings, and that obviously fails when matching against the actual guid value.

The Solution

The SQLite ADO.NET provider has a workaround for that, you can use the following connection string parameter to do so: "Data Source=database.sqlite;Version=3;New=True;BinaryGuid=False"

You can specify this parameter when using the "Show Results" feature and when using a SQLite browser to inspect the actual database content. That will ensure that the SQL that NH Prof generate will be able to find the actual results in the database.