public void BulkInsert() { using (Transaction tr = new Transaction()) { var max = Database.Query <NoteWithDateEntity>().Select(a => a.Id).ToList().Max(); var list = Database.Query <AlbumEntity>().Select(a => new NoteWithDateEntity { CreationTime = DateTime.Now, Text = "Nice album " + a.Name, Target = a }).ToList(); Administrator.BulkInsert(list); Database.Query <NoteWithDateEntity>().Where(a => a.Id > max).UnsafeDelete(); tr.Commit(); } }