What is the primary purpose of non-query commands (INSERT, UPDATE, DELETE) in ADO.NET?
- Creating a new database.
- Establishing a connection to a database.
- Inserting data into, updating data in, or deleting data from a database.
- Retrieving data from a database.
Non-query commands in ADO.NET, such as INSERT, UPDATE, and DELETE, are primarily used for modifying data in a database. These commands allow you to insert new records into a table, update existing records, or delete records from a table. They do not return any data, hence the term "non-query."
Loading...
Related Quiz
- Scenario: You are building a high-performance application that requires reading a large dataset from a database. How can you efficiently achieve this using a data reader?
- Scenario: You have two collections of objects, orders and customers, and you need to retrieve a list of orders along with their corresponding customer information. Which LINQ operator would you use for this task?
- A stored procedure is a precompiled ___________ of SQL statements.
- Which approach allows you to define entity classes and then generate a database schema from those classes in Entity Framework?
- How can you handle data conflicts when multiple users are trying to modify the same data in a dataset simultaneously?