Modify Table Schema Examples

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 = dbFactory.Open();

public class Track
{
    [AutoIncrement]
    public int Id { get; set; }
    public string Name { get; set; }
    public string Album { get; set; }
    public int ArtistId { get; set; } 
}

[Alias("Track")]       // Map to same "Track" RDBMS Table, not needed when Track is refactored
public class Track_v2
{
    [AutoIncrement]
    public int Id { get; set; }
    public string Name { get; set; }
    public string Album { get; set; }
    public int ArtistId { get; set; } 
    [Default(5)]
    public int Rating { get; set; }  // ADD
}
bool v1TableExists, v2TableExists, v1RatingExists, v2RatingExists;

v1TableExists = db.TableExists<Track>();
"Table Exists: {0}".Print(v1TableExists);
if (!v1TableExists)
{
	db.CreateTable<Track>(); 
	v1TableExists = db.TableExists<Track>();
    "Table Exists v1: {0}".Print(v1TableExists);
}

v1RatingExists = db.ColumnExists<Track_v2>(x => x.Rating);
"Rating Exists v1: {0}".Print(v1RatingExists);
if (!v1RatingExists)
{
    db.AddColumn<Track_v2>(x => x.Rating);
    v2RatingExists = db.ColumnExists<Track_v2>(x => x.Rating);
    "Rating Exists v2: {0}".Print(v2RatingExists);
}

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>