C#: ADO. net For Beginners

Partner: Udemy
Affiliate Name:
Area:
Description:      ADODotNET is a set of classes (a framework) to interact with data sources such as databases and XML files.  ADO is the acronym for ActiveX Data Objects. It allows us to connect to underlying data or databases. It has classes and methods to retrieve and manipulate data.The following are a few of the dot NET applications that use ADODotNET to connect to a database, execute commands and retrieve data from the database.ASP.NET Web ApplicationsConsole Applications Windows Applications.Various Connection ArchitecturesThere are the following two types of connection architectures: Connected architecture: the application remains connected with the database throughout the processing. Disconnected architecture: the application automatically connects/disconnects during the processing. The application uses temporary data on the application side called a DataSetImportant Classes in ADODotNETWe can also observe various classes in the preceding diagram. They are:Connection ClassCommand ClassDataReader ClassDataAdaptor ClassDataSet Class   1. Connection ClassIn ADODotNET, we use these connection classes to connect to the database. These connection classes also manage transactions and connection pooling. To learn more about connection classes, start here: Connection in ADODotNET   2. Command ClassThe Command class provides methods for storing and executing SQL statements and Stored Procedures. The following are the various commands that are executed by the Command Class.ExecuteReader: Returns data to the client as rows. This would typically be an SQL select statement or a Stored Procedure that contains one or more select statements. This method returns a DataReader object th
Category: IT & Software > Other IT & Software > ADO.NET
Partner ID:
Price: 29.99
Commission:
Source: Impact
Go to Course