Skip to content

Instantly share code, notes, and snippets.

@gistlyn
Last active February 13, 2017 04:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gistlyn/3716a91483d032c1951d8c274a36478f to your computer and use it in GitHub Desktop.
Save gistlyn/3716a91483d032c1951d8c274a36478f to your computer and use it in GitHub Desktop.
OrmLite wildcard in Custom SQL
using ServiceStack;
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
public class SomeTable
{
[AutoIncrement]
public long Id { get; set; }
public string Value { get; set; }
}
db.CreateTable<SomeTable>();
db.Insert(
new SomeTable { Value = "foo" },
new SomeTable { Value = "food" },
new SomeTable { Value = "bar" });
db.Select<SomeTable>();
var sql = "SELECT Id,Value FROM SomeTable WHERE Value Like @term";
var results = db.Select<SomeTable>(sql, new { term = "%foo%" });
<?xml version="1.0" encoding="utf-8"?>
<packages>
<package id="ServiceStack.Text" version="4.5.0" targetFramework="net45" />
<package id="ServiceStack.Interfaces" version="4.5.0" targetFramework="net45" />
<package id="ServiceStack.Common" version="4.5.0" targetFramework="net45" />
<package id="ServiceStack.OrmLite" version="4.5.0" targetFramework="net45" />
<package id="ServiceStack.OrmLite.Sqlite.Mono" version="4.5.0" targetFramework="net45" />
</packages>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment