Ans:enables an application to use a connection from a pool of connections that do not need to be re-established for each use. Once a connection has been created and placed in a connection pool, an application can reuse that connection without performing the complete connection creation process. By default, it is created when the first connection with a unique connection string connects to the database. The pool is populated with connections up to the minimum pool size. Additional connections can be added until the pool reaches the maximum pool size.
8. Is XML a component of ADO.NET ?
Ans:The answer is always Yes. 1. XML is an important component of ADO.NET architecture.
2. ADO.NET use XML to store and transfer data.
3. We do not have to convert data to XML format.
4. Datasets helps XML to integrate with ADO.NET.
5. XML schema plays a role to get table definition, column ,data types and constraints helps DataSet.
8. Difference between ADO and ADO.NET
9.Difference between ADO and ADO.NET?
ADO
1.This object model could be used even for non RDBMS products. We can read data from xml, excel, csv files also.
2.objects are dependent on OLEDB providers and OLEDB providers would connect to the backend.
3.Fully COM based.
ADO.NET
1.This is not an enhanced version of ADO. Its a new object model, which has some objects similar to ADO.
2.we use Managed Providers.
10. What are the three Objects of ADO ?
Ans:1. Connection
2. Command
3.Adapter
11. What is Diffgram in ADO.NET? When do we use Diffgram?
Ans:It is an XML format. It is used to identify current and original versions of data elements.
A DataSet may use a DiffGram format to load and persist the contents, and further to serialize its contents for porting across a network connection.
Whenever a DataSet is written as a DiffGram, the DataSet populates the DiffGram with all the important information to accurately recreate the contents.
Note that schema of the DataSet is not recreated. This includes column values from both the Current and the Original row versions, row error information, and row order.
When do we use Diffgram?
When sending and retrieving a DataSet from an XML Web service, the DiffGram format is implicitly used.
when loading the contents of a DataSet from XML using the ReadXml method, or when writing the contents of a DataSet in XML
using the WriteXml method, we can specify that the contents be read or written as a DiffGram.
DiffGram format is primarily used by the .NET Framework as a serialization format for the contents of a DataSet
we can also use DiffGrams to modify data in tables in a Microsoft SQL Server database.
Diffgram is generated by writing the contents of all tables to a
No comments:
Post a Comment