This seem to be an issue that have been fixed already, at least for the SQLite databases.
My solution consists of 3 projects:
I have installed the following packages into the main WPF project:
Microsoft.EntityFrameworkCore.Tools
Microsoft.EntityFrameworkCore.Design
Projects 2 and 3 are referenced in my main WPF project. So basically, it should be enough for the EF to resolve the DbContextes.
However, it's not - as running Add-Migration
on my WPF project results in:
PM> Add-Migration "Initial"
No DbContext was found in assembly 'TestWPFProject'. Ensure that you're using the correct assembly and that the type is neither abstract nor generic.
Switching to project 3
as default in the Package Manager Console results in:
PM> Add-Migration "Initial"
Unable to create an object of type 'ClientDbContext'. Add an implementation of 'IDesignTimeDbContextFactory<ClientDataStoreDbContext>' to the project, or see https://go.microsoft.com/fwlink/?linkid=851728 for additional patterns supported at design time.
How can I properly use EF Core migrations with my class library project and WPF project?
I reproduced your solution and found... a solution :)
Let's get to deepen.
Name: ClassLibrary1.
Type: .NET Standard 2.0 class library.
Dependencies: none.
In my test solution, it contains only one class, a model called Person.
Person.cs
namespace ClassLibrary1
{
public class Person
{
public int Id { get; set; }
public string Name { get; set; }
public string Surname { get; set; }
}
}
Name: EFClassLibrary.
Type: .NET Standard 2.0 class library.
Dependencies:
This project, in my test solution, contains only one class: the database context.
ClientDbContext.cs
using ClassLibrary1;
using Microsoft.EntityFrameworkCore;
namespace EFClassLibrary
{
public class ClientDbContext : DbContext
{
const string connectionString = "Server=(localdb)\\mssqllocaldb;Database=ClientDb;Trusted_Connection=True;";
public ClientDbContext() : base() { }
public ClientDbContext(DbContextOptions<ClientDbContext> options) : base(options) { }
public DbSet<Person> People { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlServer(connectionString);
}
}
}
In this class a defined an used the connection string to connect to the database (assuming it's LocalDb SQL Server). If you want to put the connection string in a config file, you could add a shared config file in your solution and then reference that file in your App.config
file (for more informartion take a look at this page)
In order to be able to add migrations on this project without setting as startup project other projects, you must set the target framework. Right click on the project and click on the Edit EFClassLibrary.csproj entry. Below the <TargetFramework>netstandard2.0</TargetFramework>
line, you should add another line which specify which framework you want to target. To target the .NET Framework 4.7 you should add
<TargetFramework>net47</TargetFramework>
A list of all allowed values can be found here.
My EFClassLibrary.csproj look like the code below after adding the .NET Framework 4.7 as target.
<Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<TargetFramework>netstandard2.0</TargetFramework>
<TargetFramework>net47</TargetFramework>
</PropertyGroup>
<ItemGroup>
<PackageReference Include="Microsoft.EntityFrameworkCore" Version="2.1.1" />
<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="2.1.1" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="2.1.1" />
</ItemGroup>
<ItemGroup>
<ProjectReference Include="..\ClassLibrary1\ClassLibrary1.csproj" />
</ItemGroup>
</Project>
Now you are ready to add your first migration. Open the Package Manager Console and set as default project the EFClassLibrary. Also, set that project as startup project (right-click on the project and click on the Set as startup project entry).
Type
PM> Add-Migration Initial
then
PM> Update-Database
Name: WpfApp1.
Type: WPF Application using .NET Framework 4.7.
Dependencies:
In this project I added no files. A just edited the MainWindow.xaml.cs
file to check that everything works correctly.
MainWindow.xaml.cs
using ClassLibrary1;
using EFClassLibrary;
using System.Windows;
namespace WpfApp1
{
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
var db = new ClientDbContext();
db.People.Add(new Person()
{
Name = "Omar"
});
db.SaveChanges();
}
}
}
Hope it helps :)
What worked for me is just do your regular stuff on your UI Side Startup.cs
services.AddDbContext<ShentonEvaDbContext>(options =>
options.UseSqlServer(
_configuration.GetConnectionString("DevelopmentConnection")));
Then on your DBContext Configuration just add a constructor
public ShentonEvaDbContext(DbContextOptions<ShentonEvaDbContext> options) : base(options)
{
}
After that on your Package Manager Console just run the following
dotnet ef migrations add InitialMigration --project "NameOfDbContextProject" --startup-project "NameOfWebUIProject"
Then Everytihng went added and do the same for the update of database