How to learn ADO.NET from scratch?

Question

How to learn C# fro Scratch ? I am a begginer who need to learn ADO.NET from scrstch.Where to focus for doing projects?

Naimish Makwana · Answer

Hello Don, ADO.NET (ActiveX Data Objects .NET) is a set of software components that enable applications to access and manipulate data from various data sources. It is a part of the .NET Framework and provides a consistent and efficient way to work with data. ADO.NET includes classes for connecting to databases, executing queries and commands, retrieving and updating data, and managing transactions. ADO.NET supports a variety of data sources, including Microsoft SQL Server, Oracle, MySQL, and other databases. It also provides support for XML data sources and data services. ADO.NET includes two main sets of classes: the DataSet and the DataReader. The DataSet is an in-memory representation of data that can be filled from a database or other data source, and then manipulated independently of the original data source. The DataReader provides a fast, read-only stream of data from a database, which is useful for retrieving large amounts of data. Overall, ADO.NET provides a powerful and flexible way to work with data in .NET applications. You can refer below links which will help you to learn ADO.NET. https://www.javatpoint.com/ado-net-tutorial https://dotnettutorials.net/course/ado-net-tutorial-for-beginners-and-professionals/ https://www.tutorialspoint.com/asp.net/asp.net_ado_net.htm https://www.completecsharptutorial.com/ado-net/ Thanks Naimish Makwana

Sachin Singh · Answer

You can follow my articles https://www.sharpencode.com/article/ADONET feel free to ask any doubts.

Pasang Tamang · Answer

Hi, I have listed few of the videos where you can learn ADO.NET https://www.youtube.com/watch?v=YNcF53YvAwE https://www.youtube.com/watch?v=T-e554Zt3n4 Regards, Pasang

Sardar Mudassar Ali Khan · Answer

Leran the Ado.Net from scratch from given below link https://www.javatpoint.com/ado-net-tutorial

Jignesh Kumar · Answer

Hello Xavier, Please refer this thread for basics for ado .net, https://www.c-sharpcorner.com/UploadFile/18fc30/understanding-the-basics-of-ado-net/ for scrach learning you can refer this one, https://www.pragimtech.com/courses/ado-net-tutorial-for-beginners/ https://dotnettutorials.net/lesson/ado-net-architecture/

Raj Bhatt · Answer

Hello Don , You can refer below links to learn ADO.NET. https://www.w3schools.com/asp/ado_intro.asp https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-overview https://www.tutorialspoint.com/asp.net/asp.net_ado_net.htm https://www.javatpoint.com/ado-net-tutorial https://www.pragimtech.com/courses/ado-net-tutorial-for-beginners/ Thanks Raj Bhatt

Rajeev Kumar · Answer

Hi Don ADO stands for Microsoft ActiveX Data Objects. ADO.NET is one of Microsoft’s Data Access Technologies using which we can communicate with different data sources. It is a part of the .NET Framework which is used to establish a connection between the .NET Application (Console, WCF, WPF, Windows, MVC, Web Form, etc.) and different data sources. The Data Sources can be SQL Server, Oracle, MySQL, XML, etc. ADO.NET consists of a set of predefined classes that can be used to connect, retrieve, insert, update and delete data (i.e. performing CRUD operation) from data sources.Here we cover all most all the concepts of ADO.NET such as Data Providers, Connection , Command , DataReader , DataAdapter , DataTables , DataSet , working with SQL Server database, working with XML Document, Understanding connected and disconnected architecture, SQL Bulk Copy, SQL Injection, and its Prevention, Transactions in ADO.NET, etc. You go for this Vedio Pragim Technology- Below https://www.youtube.com/watch?v=aoFDyt8oG0k&list=PL6n9fhu94yhX5dzHunAI2t4kE0kOuv4D7