I created an ASP.Net Core API project in VS 2017 and Added .Net Core Class library. Then I installed following nuggets inside the class library. (i need to use this class library as a DAL)
Pomelo.EntityFrameworkCore.MySql
Pomelo.EntityFrameworkCore.MySql.Design
I have an existing database. so i need to generate ModelClasses using Database first approach.
So I executed the following command in the package manager console (Web API project name is Test & Class Library name is DAL). I set the DAL as my default project in the package manager console
dotnet ef dbcontext scaffold "server=localhost;port=3306;user=root;password=abc123;database=test;" Pomelo.EntityFrameworkCore.MySql -o Models -p DAL -s Test
after executing this command im getting following error.
Unable to find provider assembly with name Pomelo.EntityFrameworkCore.MySql. Ensure the specified name is correct and is referenced by the project.
I tried to find a solution for this and I was unable to find it. What am I doing wrong?
Thanks