|
|
7. What does the Initial Catalog parameter define in the connection string?
The database name to connect to.
8. What does the Dispose method do with the connection object?
Deletes it from the memory.
To Do: answer better. The current answer is not entirely correct.
9. Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
1. A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
2. A DataSet is designed to work without any continuing connection to the original data source.
3. Data in a DataSet is bulk-loaded, rather than being loaded on demand.
4. There's no concept of cursor types in a DataSet.
5. DataSets have no current record pointer You can use For Each loops to move through the data.
6. You can store many edits in a DataSet, and write them to the original data source in a single operation.
7. Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.
10. What is a pre-requisite for connection pooling?
Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.
|
| Pervious4-6
Next |
|
|
|
|
|
|
|
