Literature ADO.NET

0 like 0 dislike
10 views
Comrades .NET developers :).
Advise, please, the good literature on this technology.
Yes, and more. Because interhouse this topic is for educational purposes, is also interested in the relevance ADO.NET today? I now have in mind a purely ADO.NET. Whether it is used where today? Or to replace it something else (Entity Framework, NHibernate), and there is no sense in this way.
by | 10 views

2 Answers

0 like 0 dislike
ADO.net old. Although a lot of tools able to generate code for it and all the controls prekrasno work with him, to maintain a very difficult and uncomfortable. Code is just terrible. If you want to only work with MS SQL look at Entity Framework, SLI there are even the slightest possibility that there is another base then it is better to learn NHibernate.
by
0 like 0 dislike
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.
by

Related questions

0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
0 like 0 dislike
5 answers
0 like 0 dislike
4 answers
0 like 0 dislike
2 answers
110,608 questions
257,186 answers
0 comments
28,782 users