> Note
> 
> If you're unable to delete objects from the MySQL server, it is possible that the server is running in safe mode. To disable safe mode, you can run the following query: `SET SQL_SAFE_UPDATES=0;`.

### Important Points
- We use `ExecuteNonQuery` for commands which modify the database;
- `ExecuteReader` and `ExecuteScalar` are for querying commands that retrieve data from the database;
- `ExecuteReader` returns a `MySqlDataReader` object;
- `MySqlDataReader` has a method called `read()` which reads the rows in a sequential manner;
We need to `Close()` the `MySqlDataReader` object after use;
- `ExecuteScalar` returns an `object` which can be type-casted into the appropriate data type.

The following command selects and returns all the students that have marks higher than 90, which command is the most appropriate for executing this query?

The following command selects and returns the name of the oldest student in the class, which command is the most appropriate for executing this query?

This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

In this section we will learn about what is .NET, how to setup the development environment and how to start making some console apps. Apart from that we will also learn how to take input from the user in the console for making interactive applications.

In this section, we will be learning how to perform multiple tasks at once to improve the performance and responsiveness of applications. We will also briefly learn what Web Services and APIs are. This will give us an introduction to how the internet and websites work. We will also learn how to use APIs.

In this section we will learn what are databases, specifically what are SQL databases and how to create them. We will study their structure and will learn to perform some basic operations on the databases. This chapter will serve as an introduction to ADO.NET which is a .NET module used for interacting with databases.

In this section, we'll cover the fundamental CRUD operations (Create, Read, Update, Delete) using SQL. We'll explore SQL syntax at a basic level and recap how to implement each SQL statement in C# code. While some parts may serve as a review from the previous section, this will provide a solid understanding of essential database concepts, enabling you to understand both the SQL and C# code and write it independently.

In this chapter we will learn about additional functions or methods for making database management more efficient. For-example executing multiple SQL commands at once using Stored Procedures, and retrieving data in bulk from the SQL database using DataSet.

MySqlCommand Methods

Important Points

1. The following command selects and returns all the students that have marks higher than 90, which command is the most appropriate for executing this query?

2. The following command selects and returns the name of the oldest student in the class, which command is the most appropriate for executing this query?

Awesome!

MySqlCommand Methods

Important Points

1. The following command selects and returns all the students that have marks higher than 90, which command is the most appropriate for executing this query?

2. The following command selects and returns the name of the oldest student in the class, which command is the most appropriate for executing this query?