Simple.Data has always been designed with "testing as a core feature" and supports unit testing your whole application stack using the InMemoryAdapter found in the Core namespace. There are several configuration methods for the InMemoryAdapter that are not found on other adapters. These are used to replicate the actual state in the database (table relations, autoincremented columns, keys and stored procedures)

SetKeyColumn

With the SetKeyColumn you can tell Simple.Data that a certain column is the key. And by that you can use the Get-methods, for example, to get records by the key.