No this won't work. The mDP input can only speak DisplayPort so you need to have something that talks DisplayPort. Adapters like the dual link DVI one are meant to hook up dual link DVI displays to a Mac with mini DisplayPort port. The language they speak will be DVI (the mDP port is just a port, whatever is behind it can output VGA, DVI and DisplayPort). DVI is something different than DisplayPort and that's why it won't work. Currently there are no adapters that I know of that can convert things like VGA, DVI and HDMI to DisplayPort.
The mini DisplayPort is now part of the open DisplayPort standard. Apple currently uses the DisplayPort standard so there is no way there will be any proprietary adapter (when using an open standard something like that is quite impossible). Actually there are companies like Monoprice and Circuit Assembly that already have a lot of DisplayPort products with the normal DisplayPort connector and the mini DisplayPort connector. The only big advantage with Apple's mini DisplayPort is the loss of audio. This creates a bit of a problem for HDMI converters, they have to get the audio elsewhere (most adapters use usb for that).