Can someone suggest a good book for ADO.NET? What all technologies do i need to know for 70-536?. The detailed list is confusing for me.
Note that 70-536 does *NOT* cover ADO.NET. This exam deals with other Framework libraries, but ADO.NET is not included; instead, there are separate exams about ADO.NET, such as 70-561 if you are aiming for a certification on Visual studio 2008.
If you want a book that covers 70-536, I suggest the Self-Paced Training Kit:
http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-536/dp/0735626197/ref=sr_1_1?ie=UTF8&qid=1318404164&sr=8-1
If you want instead to prepare for the ADO.NET exam then there's this one:
http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-561/dp/0735625638/ref=sr_1_1?s=books&ie=UTF8&qid=1318404235&sr=1-1