Hello B.rashed,
as for my experience the main difference is in how data are manipulated in your programs.
With SQL you tend to work <i>live</i> with data while with Ado.Net you may have datasets that retreive data, manipulate it and then send back to the source, this would solve lots of issues related to delays, timeouts, latency on slow connections and so on.
Also consider its being built on the .Net Framework that makes this product highly scaable and portable.