What is a web service? Explain its working.

1.What is a data provider? Explain.

A data provider is used for connecting to a database, retrieving data, storing the data in a dataset, reading the retrieved data, and updating the database. There are two types of data providers:

a) OLE DB data provider: - This type of data provider works with all the OlE DB provides, such as SQLE DB provider, Oracle OLE DB provider and Jet OLE DB provider. The DB Data Provider classes are present in the System.Data.OleDb namespace.

b) SQL Server data provider: - This type of data provider is use to work specifically with Microsoft SQL Server. A SQL Server data provider is recommended for working with a Microsoft SQL Server data source, because   SQL Server data provides allows fast access to a data source without going through an OLE.DB or ODBC layer. The SQL Server data provider classes are present in the fast System.Data.SqlClient namespace.

The .NET data provider is designed t be light weight, creating a minimal layer between the data source and application code, increasing performance without sacrificing functionality. The four main components of .NET data Provider.-

1) Connection: - Establishes a connecting to a specified data source.

2) Command: - Executes a command against a data source,

3) Data Reader: - Reads a forward-only, read-only stream of data from a data source.   

4) Data Adapter: Populates a Dataset and resolves updates with a data source.

2. What is a data set? Explain.

DataSet: - The Dataset is a memory based relational representation of data. A Dataset is a part of the disconnected environment. A dataset is a disconnected, cached set of recorded that are retrieved from a database. ADO.NET supports scalability by working with datasets. Database operations are performed on the dataset instead of on the database. The dataset acts like a virtual database containing tables, rows, and columns. An Application work with the database records stored in the dataset. A Dataset is present in the Dataset class in the system. Data namespace. The key-components of a Dataset are:-

1) Data Table Collection: - It contains all the tables retrieved from the Data source.

2) Data Relation Collection: - It contains relationship and links between tables in a Dataset.

3) Data Table: - It represents a table in    the database Collection of a dataset.

4) Data Row Collection: - It contains the entire row in a data table.

5) Data Column Collection: - It contains all the columns in a database.

3. What is a web service? Explain its working.

Web Service: - A web service is a very simple idea. It is application logic, accessible through some standard Web Protocol. A Web service is just between computer to computer application another computer and calling it through the Internet.  A Web services does not have user interface. A web service is designed to interact with application. Web service of XML web service is just a collection of methods that can be called from some other computer from a remote location. The cloud in the middle of figure is the Internet. The result goes back to the consumer. To the consumer there is very little difference from calling a method that is running or the same machine, but is running at some other location on the Internet.

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos