Can I Used wamp server as a db for my web api C#?

Question

I am creating my first webapi on visual studio. I used wamp server as a database and my problem is, I dont know how to connect wamp on my webapi. Is it posible to use wamp instead of microsoft sql server? plss help me guys

Answer 1

use this c# code

 string connstring ="Server=localhost;Database=testDB;Uid=UserName;Pwd=yourPassword;";
    MySqlConnection connection = new MySqlConnection(connstring);
    connection.Open();
Console.WriteLine("Connected");
connection.close();