Undergarment Help

So I am finding it difficult to find the correct bra for under my dress. I went to Victoria Secret yesterday and purchased the 100 different way convertible bra. I had grabbed the wrong size, so I went to the VS closer to my house and the woman told me I should get a push-up strapless bra and have it sewn into my dress with the straps.

The whole point to my story...has anyone ever had a whole bra with straps sewn into their dress? I am worried it is going to show through the dress.

I was also thinking of getting the strapless and backless shaping bra from VS but the woman said that this and any strapless bra would be uncomfortable. Has anyone ever worn the strapless adhesive bra?

TIA

P.S. Here is a picture of my dress so you can see where I am struggling.

I haven't heard of an actual bra being sewn in... But I HAVE had cups sewn into a Bmaid dress before.... I think this might be the better way to go- from looking at your dress. I would ask the seamstress what she thinks too- they usually know better than anyone. HTH