I have a lot of work with Entity Framework and ADO.NET in this case, I want to defend the latter. I can't say that ADO.NET by far bad, and the Entity Framework definitely good. They have different applications. Entity Framework as ORM, is just a higher layer of abstraction, and he uses ADO.NET inside.
Choose Entity Framework (or any other ORM framework), if the DB queries are more or less standard, just departing from basic CRUD operations. However, if you need to use specific and complex MS SQL for things like recursive CTE, SQLCLR, FILESTREAM, Bulk Insert, hints and other things, without ADO.NET you simply can not do, as if you didn't want.
Total, if you need is CRUD functionality, then feel free to choose the ORM, and if anything more difficult, or are you concerned about performance then ADO.NET.
Regarding the literature on ADO.NET - a lot of it, including in Russian, however, as a rule, ADO.NET described in the BCL or FCL. I can recommend well-known series of books Andrew Troelsen "C# 20xx and platform .NET xx" and Christian Nagel the book "C Sharp 2008 and platform .NET 3.5 for professionals". Also about ADO.NET quite often described in books devoted to the work with MS SQL Server.