public void Insert() { Database.CreateTable <TestModel>(); // Populate the database with test data var newItems = new TestModel[10]; for (int i = 0; i < newItems.Length; i++) { newItems[i] = new TestModel() { Id = i == 4 ? (int?)15 : null, TextField = "InsertTest", NumberField = i }; } Database.Insert <TestModel>(newItems); // Check if the primary keys have been replaced Assert.IsTrue(newItems.All(x => x.Id.HasValue), "The primary keys have not been updated."); // Check if the primary keys have the correct incrementing value Assert.IsTrue(newItems.Select((x, i) => x.Id == (i >= 4 ? i + 11 : i + 1)).All(x => x), "The primary keys of the inserted items did not follow the expected sequence." ); // Verify inserted data with select var items = Database.Select <TestModel>().ToList(); Assert.IsTrue(items.SequenceEqual(newItems), "The inserted items did not match the returned elements."); }