How to learn ADO.NET from scratch?

Don Xavier

3y1.2k.NET

How to learn C# fro Scratch ?

I am a begginer who need to learn ADO.NET from scrstch.Where to focus for doing projects?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana3y ago
Accepted 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

+4
Sardar Mudassar Ali Khan3y ago
Leran the Ado.Net from scratch from given below link

https://www.javatpoint.com/ado-net-tutorial

+3
Sachin Singh3y ago
You can follow my articles

https://www.sharpencode.com/article/ADONET

feel free to ask any doubts.
+4
Jignesh Kumar3y ago
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/
+3
Raj Bhatt3y ago
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
+3
Pasang Tamang3y ago
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
+3
Rajeev Kumar3y ago
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
+3