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);
}
}