Total Page Preview: 000000007196
What is ADO.NET in English and Hindi
ADO.NET in Engilsh
ADO.NET is a module of .Net Framework which is used to establish connection between application and data sources. Data sources can be such as SQL Server and XML. ADO.NET consists of classes that can be used to connect, retrieve, insert and delete data.
ADO.NET includes a set of classes and interfaces that allow developers to connect to a data source, retrieve and manipulate data, and manage transactions. Some of the key components of ADO.NET include:
-
Data Providers: ADO.NET includes data providers that are specific to various data sources, such as SQL Server, Oracle, and OLE DB.
-
Connection objects: ADO.NET provides connection objects that establish a connection to a data source.
-
Command objects: ADO.NET includes command objects that are used to execute SQL commands against a data source.
-
DataReader objects: ADO.NET provides DataReader objects that provide a read-only, forward-only access to data.
-
DataAdapter: ADO.NET provides DataAdapter in which we can retrieve the object data from database and store in the DataSet.
-
DataSet objects: ADO.NET includes DataSet objects that provide an in-memory representation of data retrieved from a data source.
Overall, ADO.NET provides a powerful set of tools for accessing and manipulating data from various data sources, making it a popular choice for developing data-driven applications in the .NET Framework.
ADO.NET in Hindi
-
ADO.NET (ActiveX Data Objects for .NET) ek Microsoft dwara banaya gaya programming model hai jo .NET Framework ke saath use kiya jata hai. ADO.NET ka upyog .NET applications mein data access karne ke liye kiya jata hai.
-
ADO.NET, relational databases, XML data sources, web services, aur dusre data sources se data access karne ki suvidha pradan karta hai. Iska use database se data retrieve, insert, update aur delete karne ke liye kiya ja sakta hai.
-
ADO.NET ka mukhya component DataSet hota hai, jo data ko tabular form me represent karta hai.
-
DataSet multiple tables, relationships, aur constraints ko store kar sakta hai. ADO.NET ke aur components hai Connection, Command, DataReader, aur DataAdapter, jo data access operations ko perform karne me madad karte hai.
-
ADO.NET me data access ke liye hum Connection object ka upyog karte hai. Connection object database server se connection establish karne me madad karta hai.
-
Iske baad Command object ka upyog karke hum SQL queries ya stored procedures ko execute kar sakte hai.
-
DataReader object ek forward-only, read-only cursor provide karta hai, jiske through hum query results ko iterate kar sakte hai.
-
DataAdapter object data ko database se retrieve karta hai aur use DataSet me store karta hai.
-
ADO.NET database connectivity, disconnected data architecture, aur data manipulation operations ke liye ek powerful aur flexible platform hai, jo .NET developers ko data access karne me madad karta hai.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com