using ServiceStack.OrmLite;

​

​

OrmLiteUtils.PrintSql();

​

​

var dbFactory = new OrmLiteConnectionFactory(":memory:", SqliteDialect.Provider);

using var db = dbFactory.Open();

db.CreateTableIfNotExists<MyType>();

​

​

db.Save(new MyType { field1 = "Hello", field2 = "World!" });

​

​

try // first -- like I'd expect it to work:

{

    var q = db.From<MyType>().Where("field1 = @theVariable", new { theVariable = "Hello" });

    var results = db.Select(q);

}

catch (SQLiteException ex) { Console.WriteLine(ex.Message); }

​

try // same problem if I convert to SQL statement and run as string....

{

    var q2 = db.From<MyType>().Where("field1 = @theVariable", new { theVariable = "Hello" });

    var stmt = q2.ToSelectStatement();

    var results2 = db.Select<MyType>(stmt);

}

catch (SQLiteException ex) { Console.WriteLine(ex.Message); }

​

​

try // ... but it works if the variable is inserted at the end

{

    var q2 = db.From<MyType>().Where("field1 = @theVariable");

    var stmt = q2.ToSelectStatement();

    var results2 = db.Select<MyType>(stmt, new { theVariable = "Hello" });

}

catch (SQLiteException ex) { Console.WriteLine(ex.Message); }

​

// db.SelectMany doesn't have the option of passing in an SQL-string + parameters

​