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

Welcome to the journey of becoming ADONET expert,if you are a beginner and really want to be a professional, then follow the below steps:-

  • Go through each article one by one without skipping any of them.
  • Try to implement and practice what you have learnt in the article by yourself.
  • Use your imagination and thinking power and ask these questions to yourself:-
    • Why did i read this article?
    • What i learned after reading this article?
    • Should i open visual studio and try to implement something?
    • Am i getting errors?ok ,which type of error
      • Is it compilation error?
      • Is it Run time error?
      • Can i solve this myself?
      • Can my friends solve this problem?
      • Should i ask this question on Stackoverflow?