Data Adapter

Data Adapter

Introduction In ADO.NET a DataAdapter functions as a bridge between a data source, and a disconnected data class, such as a DataSet. A Data Adapter represents a set of data commands and a database connection to fill the dataset and update a SQL Server database. A Data Adapter contains a set of data commands and a database connection to fill the dataset and update a […]

Read More Leave comment

Data Reader

Data Reader

Introduction DataReader object is used to obtain the results of a SELECT statement from a command object. DataReaders are used to efficiently retrieve a forward-only stream of data from a database. DataReaders are appropriate when the need is to simply display the result set, as only one record at a time is ever present in memory. The DataReader is mainly used in scenarios where in […]

Read More Leave comment

Command

Command

Introduction A Command object executes SQL statements on the database. These SQL statements can be SELECT, INSERT, UPDATE, or DELETE. It uses a connection object to perform these actions on the database. SELECT cmd =new SqlCommand(“select * from Employee”, con); cmd =new OracleCommand(“select * from Employee”, con); INSERT cmd = new SqlCommand(“INSERT INTO Employee(Emp_ID,Emp_Name)VALUES (‘” + aa + “‘,'” + bb +”‘)”,con); cmd = new […]

Read More Leave comment

Connection

Connection

Introduction One of the first ADO.NET objects is the connection object, that allows you to establish a connection to a data source. The sqlconnection object, that is designed specially to connect to Microsoft SQL Server and the OleDbConnection object, that is designed to provide connection to a wide range of databases, such as Microsoft Access.The OracleConnection object for Oracle. string connstr = “DATA SOURCE=TAPTI;USER ID=ORD59;Password=ORD59;”; […]

Read More Leave comment

Data Provider

Data Provider

Introduction A data provider is used for connecting to a database, executing commands and retrieving data, storing it in a dataset, reading the retrieved data and updating the database. There are following different types of data providers included in ADO.Net The .Net Framework data provider for SQL Server – provides access to Microsoft SQL Server. The .Net Framework data provider for OLE DB – provides […]

Read More Leave comment

Connection Pooling

Connection Pooling

Connection pooling is the ability of reusing your connection to the database. This means if you enable Connection pooling in the connection object, actually you enable the re-use of the connection to more than one user. ADO.NET uses a technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections. Connection pooling reuses existing active connections with the same connection string instead […]

Read More Leave comment

ADO.NET-Architecture

ADO.NET-Architecture

Connected Architecture of ADO.NET The architecture of ADO.net, in which connection must be opened to access the data retrieved from database is called as connected architecture. Connected architecture was built on the classes connection, command, datareader and transaction. Connected architecture is when you constantly make trips to the database for any CRUD (Create, Read, Update and Delete) operation you wish to do. This creates more […]

Read More Leave comment

ADO.NET

ADO.NET

Introduction ADO.NET is a collection of managed libraries used by .NET applications for data source communication using a driver or provider: Enterprise applications handle a large amount of data. This data is primarily stored in relational databases, such as Oracle, SQL Server, and Access and so on. These databases use Structured Query Language (SQL) for retrieval of data. To access enterprise data from a .NET […]

Read More Leave comment
Visitors
Page Hits: 51760
Unique Visitors :
12539
Made With By Keshab