Interested to Buy Any Domain ? << Click Here >> for more details...
explain connection less and with connection?diference
between data reader,data set,data adapter? can we use data
reader,data set in a single application? if yes explain
with simple code,if no explain?
- 3 Answers
- 17033 Views
- Techno Labs, I also Faced
- E-Mail Answers
Answer Posted / kavitha
in connection less architecture connection to the database
need not be persist till the end of the process.after
fetching the data form database it is pushed in database
object called dataset and connection object need not to be
persist and its closed. and the data will be available from
the dataset.
data reader - ADO.NET DataReader to retrieve a read-only,
forward-only stream of data from a database. Using the
DataReader can increase application performance and reduce
system overhead because only one row at a time is ever in
memory.Connection to the database is maintained till the
end.it is simply like an ado object.it contains only one
table at a time.it is much faster than dataset.
dataset - is used to hold the data from the database along
with their relation. it is connection less object.it also
persist the value which are retrieved form the database.
it is a bit bulky object.it gives both forward and backward
access to data. it uses XML.it can consist more than one
table.we have atrribtes for the dataset
dataset
datatable
datarow
datacolumn
an adapter object is used to fill the data from the database.
dataadapter - dataadapter is a database object which
used to fill the dataset object with data from the database.
| Is This Answer Correct ? | 35 Yes | 2 No |
Post New Answer View All Answers
Explain how to pass multiple tables in datasets simultaneously?
How do I delete a row from a DataTable?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How can we load multiple tables in a dataset?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is data reader in ado.net?
Can we connect two dataadapters to same data source using single connection at same time?
What are different layers of ADO.Net?
Why do we use sqldataadapter?
What is ado asp?
Is entity framework better than ado.net?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
Give few examples of datareader that is used in different dataproviders.
What is untyped dataset?
Explain the different row versions available in table?
