Cannot use Entity Framework in .NET standard 2 project

Question

How can I use Entity Framework, or something similar within a .NET Standard project?

It appears as though EF is not supported in .NET Standard 2 which is really annoying!

So I have tried using Microsoft.EntityFrameworkCore.SqlServer and icrosoft.EntityFrameworkCore.SqlServer.Design

Whist I can install these packages, I cannot then add a model

I get the error

---------------------------
Microsoft Visual Studio
---------------------------
The project's target framework does not contain Entity Framework runtime assemblies. Please review the target framework information in the project's property page.
---------------------------
OK   
---------------------------

How can I get around this?

I am seriously thinking to get rid of .NET Standard out of all my projects but that is a bit drastic!

Paul

It's not. EF 6 came years before .NET Standard 2.0. The .NET Standard compatilbe version is EF Core. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Feb 2, 2018 at 12:24
Is it not possible to have a visual model designer for EF Core? — Paul
– Paul, Commented Feb 2, 2018 at 12:25

Panagiotis Kanavos · Accepted Answer · 2018-02-02 12:35:55Z

7

It looks like the actual question is "How can I create models and reverse engineer a database using EF Core like I could with EF 6" ?

The tooling is separate from the NuGet package. Visual Studio 2017 doesn't include modelling or reverse engineer tools for EF Core. Those are available through EF Core Power Tools an open source addon. You can find the code and documentation here

answered Feb 2, 2018 at 12:35

Panagiotis Kanavos

134k16 gold badges211 silver badges270 bronze badges

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

2 Comments

Paul Over a year ago

When I try to use this I get another error Currently only .NET Framework and .NET Core 2.0 projects are supported - TargetFrameworkMoniker: .NETStandard,Version=v2.0

David Browne - Microsoft Over a year ago

The tooling for EF doesn't fully work with a project that targets only .NET Standard. But the runtime does. Try running the tooling in a console app targeting .NET core and moving the generated code artifacts into your .NET Standard class library.

Giovanny Farto M. · Accepted Answer · 2022-05-11 23:41:52Z

0

Change the EF version. There are some versions of EF that work with NetStandard2.0 but other (recently ones) usually don't.

For example with the version 6:

And with version 5, you can use it in a Standard project:

answered May 11, 2022 at 23:41

Giovanny Farto M.

1,60819 silver badges21 bronze badges

Collectives™ on Stack Overflow

Cannot use Entity Framework in .NET standard 2 project

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related