VB.NET - What is data provider? Explain its components.

What is data provider? Explain its components.

1. Data Provider is a set of components that facilitate data access.
2. It contains components like connection, command, dataReader, dataAdapter.
3. Connection object connects to the data source.
4. Command object represents a direct command to the data source.
5. DataReader object that provides connected, forward-only, read-only access to a database.
6. DataAdapter that provides disconnected data access.
DataReader and DataAdapter in ADO.NET
VB.NET - DataReader and DataAdapter in ADO.NET - DataReader: It is lightweight class that provides connected and forward-only data access......
VB.NET - commandType property of a SqlCommand object
VB.NET - commandType property of a SqlCommand object - CommandType property can set to Text, StoredProcedure, or TableDirect.....
VB.NET - typed and untyped DataSet objects
VB.NET - typed and untyped DataSet objects - An untyped dataset has no corresponding built-in schema......
Post your comment