I'd suggest staying away from Apple's own adapter, it's a short cable, dongle really, that forces you to plug a longer DVI cable into it to make it useable. DVI connectors are physically very large and heavy, the cables are thick and clumsy, using heavy-gauge wiring compared to more modern standards. It will make an ugly and unwieldy monitor connection.
Instead, look for a full-length adapter cable with mini displayport in one end and a DVI plug in the other. I have such a cable plugged into my '11 MBP and it works great. The passively powered signal conversion circuitry is entirely contained in the molded DVI plug, so it's physically no larger than any other DVI connector, and I get a thin, agile cord connection hooking up the two devices.
I'd give you the brand name, but it's sold as a no-name OEM cable, so that'd be pointless.