public void Delete(PatientDto dto)
        {
            using (var context = new PatientDBEventStoreEntities(ConnectionString))
            {
                Patient patientEntity = new Patient()
                {
                    PatientId = dto.Id
                };

                context.Patients.Attach(patientEntity);
                context.DeleteObject(patientEntity);
                context.SaveChanges();
            }
        }