In C# core, how do I unit test against a MySQL database?

I am writing an application in C# core and it interacts with a MySQL database. I want to write unit tests for it but so far what I see for the SQLlite option is that it behaves like a MSSQL database.

How can I have an in memory database that behaves like mysql for C# core?