using ServiceStack;
using ServiceStack.Logging;
using ServiceStack.Text;
using ServiceStack.OrmLite;
using ServiceStack.OrmLite.Sqlite;
using ServiceStack.DataAnnotations;

var dbFactory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);
var db = dbFactory.Open(); // Open ADO.NET DB Connection

LogManager.LogFactory = new ConsoleLogFactory();

public class Person
{
    [AutoIncrement]
    public long Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
}

db.CreateTable<Person>();

db.Insert(new Person { FirstName = "Joeseph", LastName = "Smith" });

var rows = db.Select<Person>(x =>
    x.FirstName.Contains("joe") || x.LastName.Contains("joe"));