CODE EXAMPLE FOR SQL

vs 2019 connect to local mysql database

-- Download MySQL Connectors for .net
https://dev.mysql.com/downloads/file/?id=504670

-- Download MySQL for Visual Studio 1.2.9
-- This will add a new item into tools -> connect to database

https://dev.mysql.com/downloads/file/?id=491638

-- set servername 'localhost', username 'root'
-- Press connect