Usually in C#, we have 2 different ways to database connectivity. They are Connection Oriented and Disconnected Oriented.
Either it can be connected architecture where you go and connect to the database and get data or disconnected architecture where you connect to the database first time and get all data in an object and use it if required. You can perform any action like insert, update, and search on this.
You can use two C# objects to achieve this, first one is DataSet and other one is DataReader.
DataSet: DataSet is used in part of Disconnected architecture,
Usually in C#, we have 2 different ways to database connectivity. They are Connection Oriented and Disconnected Oriented.
Either it can be connected architecture where you go and connect to the database and get data or disconnected architecture where you connect to the database first time and get all data in an object and use it if required. You can perform any action like insert, update, and search on this.
You can use two C# objects to achieve this, first one is DataSet and other one is DataReader.
DataSet: DataSet is used in part of Disconnected architecture,