public void InsertALot() { int n = 10000; var q = from i in Enumerable.Range(1, n) select new TestObj() { Text = "I am" }; var objs = q.ToArray(); _db.Trace = false; var sw = new Stopwatch(); sw.Start(); var numIn = _db.InsertAll(objs); sw.Stop(); Assert.AreEqual(numIn, n, "Num inserted must = num objects"); var inObjs = _db.CreateCommand("select * from TestObj").ExecuteQuery <TestObj>().ToArray(); for (var i = 0; i < inObjs.Length; i++) { Assert.AreEqual(i + 1, objs[i].Id); Assert.AreEqual(i + 1, inObjs[i].Id); Assert.AreEqual("I am", inObjs[i].Text); } var numCount = _db.CreateCommand("select count(*) from TestObj").ExecuteScalar <int>(); Assert.AreEqual(numCount, n, "Num counted must = num objects"); }