What are the differences between Dataset and DataReader?
Answer Posted / eduardo belmonte
A ds (dataset) can be used when the connection is closed.
A dr (datareader) needs the connection open to be used.
A ds can be used to modify or delete or insert data in the
database.
A data reader can be used only to read data
A ds can let you access the info on any order at any time.
A dr lets you access the info only one time per item and
only in a sequential order.
A ds data can be loaded in longer time than a dr can be
loaded at.
A ds can contain separated and structured data from several
database tables.
A dr can contain data in one register per item, that
register can include data from serveral tables id the sql
select statement so indicates, but it has no separate
structure per table.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are tuples?
What are the features of asp net?
What New Features comes with ASP.NET Web API 2.0?
What is the difference between page-level caching and fragment caching?
What is the difference between a cookie and a pixel?
Why web api is better than wcf?
Describe the disadvantage of cookies.
Explain global assembly cache.
explain code with multi inhertance
Differentiate strong typing and weak typing
Which type of state management is provided by Query String in ASP.NET?
Give a few examples of page life cycle events.
Explain the difference between panel and groupbox classes using .net?
What is the most appropriate lifetime for a database connection/orm context in an asp.net mvc application? : Asp.Net MVC
What are the Types of session management in ASP.NET