Using an in Memory Sqlite database as mock for Mysql connection,

Question

I was building unit tests for Data access blocks and liked to replace a MySql db with Sqlite in memory database, which i could consider as mock and load with test values.

Sqlite is created as below

using (var connection = new SqliteConnection("" +new SqliteConnectionStringBuilder
                            {
                                DataSource = ":memory:"
                            }))
{

  connection.Open();

  using (var transaction = connection.BeginTransaction())
  {
    //code to create table and load data
    var connectionString=connection.ConnectionString
    methodToBeTested(connectionString);
    //Assert codes
  }
}

MySql code that need to be unit tested is as below

methodToBeTested(string connectionString)
{
 using (MySqlConnection cn = new MySqlConnection(connectionString))
 {
    cn.Open();//Exception->Unable to connect to any of the specified MySQL hosts
    //other codes
  }
}

The MySqlClient adapter throws exception while opening a SQLite db connection. Is there a way to achieve this?

virullius · Accepted Answer · 2020-03-13 15:10:04Z

2

No.

At least not as you have it setup. The MySQL client does not know how to use a SQLite database. MySQL client is meant to connect to a MySQL server process while SQLite would be a code library that reads a local database file. That both are "SQL" only means they (mostly) follow the same standard for querying data once connected to the database. The connection process itself is very different.

Even if you were to build a abstraction layer for the connection process, SQLite would not be a good test for database function written for MySQL. Neither follow and SQL spec perfectly and either can offer more than standard functionality.

answered Mar 13, 2020 at 15:10

virullius

9997 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using an in Memory Sqlite database as mock for Mysql connection,

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related