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();
            }
        }
        public void Insert(PatientDto dto)
        {
            using (var context = new PatientDBEventStoreEntities(ConnectionString))
            {
                Patient patientEntity = new Patient()
                {
                    PatientId = dto.Id,
                    Name      = dto.Name,
                    Status    = dto.Status,
                    Street    = dto.Street,
                    City      = dto.City,
                    State     = dto.State,
                    Zip       = dto.Zip
                };

                context.Patients.AddObject(patientEntity);
                context.SaveChanges();
            }
        }
        public void Update(PatientDto dto)
        {
            using (var context = new PatientDBEventStoreEntities(ConnectionString))
            {
                Patient patientEntity = new Patient()
                {
                    PatientId = dto.Id,
                    Name      = dto.Name,
                    Status    = dto.Status,
                    Street    = dto.Street,
                    City      = dto.City,
                    State     = dto.State,
                    Zip       = dto.Zip
                };

                context.Patients.Attach(patientEntity);
                context.ObjectStateManager.ChangeObjectState(patientEntity, EntityState.Modified);
                context.SaveChanges();
            }
        }