Getting started with ADONET
ADO.NET is not more than a set of classes so you can think of it as a library that acts as a bridge between data sources and any .net application. Obviously, you will keep data in a database and will write your business logic or any code somewhere else like the platform you selected for the development of your dream website or app or anything whether it be MVC or Webforms anything. But remember your selected platform will not allow you to write SQL directly to talk to the database so you need a mediator, that mediator is ADO.NET.
In order to connect to the database and perform some action on it, you need to write a huge amount of code, but Microsoft developers have already created a set of classes that enables the .Net applications to communicate to Databases, we just need to create the appropriate objects and use the right method.
In this course you will learn each and every class of Ado.Net in great detail with examples, after going through each article of this course, you will be able to create the persistence layer or Data Access layer for your application easily, using Ado.Net
At present, most of the companies prefer to use ORMs like Entity Framework or Dapper but Ado.Net has its own place, learning Ado.Net gives you a better understanding of the logic that ORMs uses behind the scene.
In.Net interviews, Ado.Net still plays a vital role, there is a huge chance that you will be asked a number of questions on Ado.Net, so it is better to learn Ado.Net