Skip to content

Instantly share code, notes, and snippets.

@georgehemmings

georgehemmings/main.cs

Last active December 15, 2017 09:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save georgehemmings/044423139a7a4f4fb5b1f9c1fb40b7bb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save georgehemmings/044423139a7a4f4fb5b1f9c1fb40b7bb to your computer and use it in GitHub Desktop.
Download ZIP
Sqlite Scratch
Raw
main.cs
using System.Linq;
using ServiceStack;
using ServiceStack.Text;
using ServiceStack.OrmLite;
using ServiceStack.Data;
using ServiceStack.DataAnnotations;
public class Person
{
[AutoIncrement]
public int Id { get; set; }
public string Name { get; set; }
}
var dbFactory = new OrmLiteConnectionFactory(
":memory:",
SqliteDialect.Provider);
var db = dbFactory.Open();
db.CreateTable<Person>();
db.ExecuteSql("INSERT INTO Person (Name) VALUES ('Andy')");
db.ExecuteSql("INSERT INTO Person (Name) VALUES ('George')");
db.Select<Person>("SELECT * FROM Person WHERE Name = 'Andy'").PrintDump();
Raw
packages.config
<?xml version="1.0" encoding="utf-8"?>
<packages>
<package id="ServiceStack.Text" version="4.5.14" targetFramework="net45" />
<package id="ServiceStack.Client" version="4.5.14" targetFramework="net45" />
<package id="ServiceStack.Common" version="4.5.14" targetFramework="net45" />
<package id="ServiceStack.Interfaces" version="4.5.14" targetFramework="net45" />
<package id="ServiceStack.OrmLite" version="4.5.14" targetFramework="net45" />
<package id="ServiceStack.OrmLite.Sqlite" version="4.5.14" targetFramework="net45" />
<package id="System.Data.SQLite" version="1.0.106" targetFramework="net45" />
</packages>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment