OrmLite Basic Update Examples

data.cs

using System.Collections.Generic;
using System.Data;
using ServiceStack;
using ServiceStack.OrmLite;
using ServiceStack.DataAnnotations;

public class Artist
{
    public int Id { get; set; }
    public string Name { get; set; }
    
    [Reference]
    public List<Track> Tracks { get; set; }
    public override string ToString() => Name;
}

public class Track
{
    [AutoIncrement]
    public int Id { get; set; }
    public string Name { get; set; }
    public int ArtistId { get; set; }
    public string Album { get; set; }
    public int Year { get; set; }
    public override string ToString() => Name;
}

var Artists = new [] {
    new Artist { 
        Id = 1, Name = "Faith No More", 
        Tracks = new List<Track> { 
            new Track { Name = "Everythings Ruined", Album = "Angel Dust", Year = 1992 },
            new Track { Name = "Ashes to Ashes", Album = "Album of the Year", Year = 1997 },
        }
    },
    new Artist { 
        Id = 2, Name = "Live", 
        Tracks = new List<Track> { 
            new Track { Name = "Lightning Crashes", Album = "Throwing Copper", Year = 1994 },
            new Track { Name = "Lakini's Juice", Album = "Secret Samadhi", Year = 1997 },
        }
    },
    new Artist { 
        Id = 3, Name = "Nirvana", 
        Tracks = new List<Track> { 
            new Track { Name = "Smells Like Teen Spirit", Album = "Nevermind", Year = 1991  },
            new Track { Name = "Heart-Shaped Box", Album = "In Utero", Year = 1993 },
        }
    },
    new Artist { 
        Id = 4, Name = "Pearl Jam", 
        Tracks = new List<Track> { 
            new Track { Name = "Alive", Album = "Ten", Year = 1991 },
            new Track { Name = "Daughter", Album = "Vs", Year = 1993 },
        }
    },
};

IDbConnection CreateArtistAndTrackTablesWithData(IDbConnection db)
{
    db.DropAndCreateTable<Artist>();
    db.DropAndCreateTable<Track>();
    Artists.Each(x => db.Save(x, references:true));
    return db;
}

main.cs

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

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

var alive = db.Single<Track>(x => x.Name == "Alive"); 
alive.Name = "Still Alive";
alive.Year = 2000;
db.Update(alive); // Updates all fields except `Id` which is used to filter
var updatedTrackById = db.SingleById<Track>(alive.Id);
$"Track Updated by Id: {updatedTrackById}".Print();

var pearlJamTracks = db.Select<Track>(x => x.ArtistId == alive.ArtistId);
pearlJamTracks.Each(x => x.Album = "Rearviewmirror (Greatest Hits 1991–2003)");
db.Update(pearlJamTracks[0], pearlJamTracks[1]); //Update by params
pearlJamTracks = db.Select<Track>(x => x.ArtistId == alive.ArtistId);
$"Updated all Pearl Jam Tracks: {pearlJamTracks.Dump()}".Print();

//Updates only non-default value fields (inc Id) matching specified filter
db.UpdateNonDefaults(new Track { Id = 10, Name = "Still Alive..." }, x => x.Name == "Still Alive");
var updatedNonDefaults = db.SingleById<Track>(10);
$"UpdateNonDefaults: {updatedNonDefaults.Dump()}".Print();

//Updates ALL fields matching specified filter
db.Update(new Track { Id = 20, Name = "Partially Alive...", ArtistId = alive.ArtistId }, 
	where: x => x.Name == "Still Alive...");
var updatedAllFields = db.SingleById<Track>(20);
$"Update ALL fields with custom filter: {updatedAllFields.Dump()}".Print();

//Update only fields in anonymous type
db.Update<Track>(new { Year = 2000 }, where: x => x.Id == 20);
var updateOnlyAnonTypeFields = db.SingleById<Track>(20);
$"Update only fields in anonymous Type: {updateOnlyAnonTypeFields.Dump()}".Print();

packages.config

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="System.Memory" version="4.5.4" targetFramework="net45" />
  <package id="ServiceStack.Text" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.Client" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.Common" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.Interfaces" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.OrmLite" version="5.10.0" targetFramework="net45" />
  <package id="ServiceStack.OrmLite.Sqlite.Windows" version="5.10.0" targetFramework="net45" />
</packages>