EF Core error

Problem

When I run Add-Migration or update-database commands in PM I get these errors.

Add-Migration : Exception calling "Substring" with "1" argument(s): "StartIndex cannot be less than zero.
Parameter name: startIndex"
At line:1 char:1
+ Add-Migration -Name 'Firstqa' -verbose
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Add-Migration], MethodInvocationException
    + FullyQualifiedErrorId : ArgumentOutOfRangeException,Add-Migration

Explanation

When the project structured like

• .NET CORE
• MySql (SapientGuardian)
• StructureMap

Structuremap obviously try to auto fill an interface in a constructor in MySql EF code ..

It works and does the job but it also displays this error.

Problem : No Migration Table Exists

if you get an error like this in MySql it means migration table is not automatically created

Solution

CREATE TABLE `__EFMigrationsHistory` 
( 
    `MigrationId` nvarchar(150) NOT NULL, 
    `ProductVersion` nvarchar(32) NOT NULL, 
     PRIMARY KEY (`MigrationId`) 
);