Married Couples of India, living in Metro cities like Delhi, Noida, Banglore. How common are Extramarital affairs?

So I go to know that my manager, is having an affair with the new joine. Now He is 36 years old guy married for 5 years and good looking guy. His wife is also working in different company in IT field, don't know if she is having same or not. Which got me thinking how common are these cases? How common do you see it around you?

I am also looking for bride, so I wanted to know is this relevant in Metro cities. Should I find a non working wife ? because I don't want to face this.