Answer Posted / manikanta.srinu

Dataset:1)It is a disconnceted architecture why because
once you fill data in dataset,it'll keep data in it even DB
conncetion was closed.and also no need write code for open
& close database connection.
2)It contain collection of datatables.It can be Add,Edit
and modify at runtime.This property is called Read and
write.

DataReader:
1)It is a Connceted architecture why because we have open
connection to get data from DB.
2)It is Forwarad only.This is only for Reading data from DB.

Diffrence:
==========
DataReader is faster than Dataset,because this is read only.

ADO.net classes
===============
System.data is importent class for ADO.Net.It have
collection of class like Dataset,DataReader.etc...
System.Data.SqlClient;
This is for used making SQL connetion,Command.etc..

Architecture
============
SQLDataProvider is contain DataAdpter.This is used to
retive data from DB and then fill dataset to client.and
also It can do Add,Edit and modify operation on DB.

What's singlecall activation mode used for in .net?

734

---

What are the advantages of .net core?

719

---

How many types of generations are there in a garbage collector?

737

---

Explain what is an interface and what is an abstract class? Please, expand by examples of using both. Explain why?

778

---

What are the two main parts of the .net framework?

796

---

Explain me difference between public and static modifiers?

704

---

How do you instantiate a complex number?

786

---

How can I tell if .net 3.5 is installed?

721

---

Tell us what is a sealed class?

758

---

Explain me what is encapsulation?

742

---

Is there any inbuilt tool or command provided by .NET to view the code inside the assembly?

788

---

What is namespace in .net?

811

---

Please explain what is the .net framework and how does it work?

718

---

What is delegation in .net?

810

---

Can a try block have more than one catch block?

824

---