OrmLite Filter Transaction

main.cs

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

using System;

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

OrmLiteConfig.InsertFilter = (dbCmd, row) => {


 IDbConnection db = dbCmd.Connection;
 if (dbCmd.Transaction != null) {
  db = dbCmd.Transaction.Connection;

 }
 try {
  var modelDef = row.GetType().GetModelMetadata();
  //var name = modelDef.ModelName;
  var dialectProvider = dbCmd.GetDialectProvider();
  var tableName = dialectProvider.NamingStrategy.GetTableName(modelDef);



  var key = modelDef.GetPrimaryKey(row);
  var auditLog = new Audit() { Id = 1 };
  var identity = db.Insert <Audit> (auditLog, selectIdentity: true);


 } catch  {
  //ex.PrintDump();
 }

};


var db = dbFactory.Open(); // Open ADO.NET DB Connection

public class Audit {
 [AutoIncrement]
 public long Id {
  get;
  set;
 }
}

public class Todo {
 [AutoIncrement]
 public long Id {
  get;
  set;
 }
 public string Content {
  get;
  set;
 }
 public int Order {
  get;
  set;
 }
 public bool Done {
  get;
  set;
 }
}

db.CreateTable < Todo > ();
db.CreateTable < Audit > ();

var newTodo = new Todo {
 Content = "Learn OrmLite",
  Order = 1
};
using (var trans = db.OpenTransaction()) {
  db.Save(newTodo);
}
var audits =db.Select<Audit>();

packages.config

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="ServiceStack.Text" version="5.0.2" targetFramework="net45" />
  <package id="ServiceStack.Interfaces" version="5.0.2" targetFramework="net45" />
  <package id="ServiceStack.Common" version="5.0.2" targetFramework="net45" />
  <package id="ServiceStack.OrmLite" version="5.0.2" targetFramework="net45" />
  <package id="ServiceStack.OrmLite.Sqlite" version="5.0.2" targetFramework="net45" />
</packages>