|
ADO.NET Overview - ADO.NET is design to provide data access...
|
|
ADO.NET vs ADO - ADO.NET is considered as evolution version of ADO....
|
|
ADO.NET Data Architecture - ADO.NET has four layers - The Physical Data Store: This can be any database, XML files or OLE....
|
|
ADO.NET - Type of database connection in ADO.NET - SQL Connection: This object connects to the SQL Server.....
|
|
ADO.NET - Components of data providers in ADO.NET - The Connection Object: The Connection object represents the connection to the database. ....
|
|
ADO.NET - Connected and disconnected data access in ADO.NET - This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing....
|
|
ADO.NET - CommandType property of a SQLCommand in ADO.NET - A SQLCommand has CommandType property which can take Text, Storedprocedure or TableObject as value.
|
|
Dataview component of ADO.NET - A DataView object allows you work with data of DataTable of DataSet object..
|
|
Ways to create connection in ADO.NET - There are two ways to create connection supported by ADO.NET...
|
|
Access database at runtime using ADO.NET - Steps to connect to database - Declare and initialize database connection object with appropriate connection string...
|
|
ADO.NET Code showing Dataset storing multiple tables - Declare and initialize database connection object with appropriate connection string.....
|
|
ADO.NET Code executing stored procedure - Code showing how to fetch data using Stored Procedure...
|
|
ADO.NET transaction Processing - The transaction object handles concurrency issue using IsolationLevel settings. The settings can be....
|
|
System.data contains basic objects. These objects are used for accessing and storing relational data....
|
|
The data adapter objects connect a command objects to a Dataset object....
|
|
The most commonly used methods of the DataAdapter are.....
|
|
The DataSet object is a disconnected storage, it is used for manipulation of relational data....
|
|
We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished....
|
|
The changes made to the dataset can be tracked using the GetChanges and HasChanges methods.....
|
|
How can we add/remove row’s in “DataTable” object of “DataSet”? - NewRow method is provided by the Datatable to add new row to it.DataTable has DataRowCollection object which has all rows in a DataTable object....
|
|
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
|
|
A DataView is a representation of a full table or a small section of rows, it is used to sort and find data within Datatable...
|
|
DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them...
|
|
Load multiple tables in a DataSet using ADO.NET...
|
|
CommandBuilder builds Parameter objects automatically...
|
|
In pessimistic locking, when a user opens a data to update it, a lock is granted..
|
|
A connection pool is created when a connection is opened the first time...
|
|
To disable connection pooling set Pooling=false in connection string if it is an ADO.NET Connection..
|
