public void OneEvent_SqlStoreTest() { var streamId = Guid.NewGuid(); var event1 = EventFactory.Create(streamId, new Created("Apa1")); using (var store = persistenceStore.CreateSqlConnection()) using (var stream = store.OpenStream(streamId, 0)) { stream.Add(new EventMessage { Body = event1.Data }); stream.CommitChanges(event1.EventId); } using (var connection = new SqlConnection("Server = (localdb)\\MSSQLLocalDB; Initial catalog = NEventStore; Integrated Security = true;")) { var result = connection.Query("select * from commits where streamIdOriginal = @streamId", new { streamId }); result.Count().ShouldBe(1); } using (var store = persistenceStore.CreateSqlConnection()) using (var stream = store.OpenStream(streamId, 0)) { stream.CommittedEvents.Count.ShouldBe(1); } }