public void event_store_type_and_id_are_indexed()
 {
     using (var context = new EventStoreDbContext())
     {
         var result = context.QueryDynamic(@"SELECT * FROM sys.indexes WHERE name='IX_Id_and_Type' AND object_id = OBJECT_ID('eventstore.events')").Single();
         result.Should().NotBeEmpty();
     }
 }
 public void event_store_etag_is_nullable()
 {
     using (var context = new EventStoreDbContext())
     {
         var  result      = context.QueryDynamic(@"SELECT * FROM sys.columns WHERE name='ETag' AND object_id = OBJECT_ID('eventstore.events')").Single();
         bool is_nullable = result.Single().is_nullable;
         is_nullable.Should().BeTrue();
     }
 }