The source code to get the MySQL version is given below. The given program is compiled and executed successfully.
//C#.NET program to get MySQL version.
using MySql.Data.MySqlClient;
using System;
class Program
{
static void Main(string[] args)
{
//Connection String to connect with MySQL database.
string connString = "server=localhost;userid=root;password=root;database=mydb";
MySqlConnection conn = new MySqlConnection(connString);
conn.Open();
Console.WriteLine("MySQL version : " + conn.ServerVersion);
conn.Close();
}
}
Output:
MySQL version : 8.0.22
Press any key to continue . . .
Explanation:
In the above program, we imported a namespace MySql.Data.MySqlClient to establish the connection with the MySql database. Then we created a class Program that contains the Main() method.
The Main() method is the entry point for the program. In the Main() Method, we created a connection string variable ConnString that contains the database connectivity credentials. After that, we established the connection to the database using MySqlConnection class and then print the MySql version using the ServerVersion property on the console screen.
Program:
The source code to get the MySQL version is given below. The given program is compiled and executed successfully.
Output:
Explanation:
In the above program, we imported a namespace MySql.Data.MySqlClient to establish the connection with the MySql database. Then we created a class Program that contains the Main() method.
The Main() method is the entry point for the program. In the Main() Method, we created a connection string variable ConnString that contains the database connectivity credentials. After that, we established the connection to the database using MySqlConnection class and then print the MySql version using the ServerVersion property on the console screen.
need an explanation for this answer? contact us directly to get an explanation for this answer