Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to use ef6.exe

I'm a newbie in entity framework. I have seen examples of using migrate.exe or enable-migration etc.

But migrate.exe does not exist any more. I explored the web and found that ef6.exe replaced the old migrate.exe

so I tried

ef6 -contexttypename musicstoredatacontext
ef6 -context musicstoredatacontext

nothing worked

I cannot find further support/documentation regarding the migration commands. and i'm new to migration.

Can somebody give me some hint how to work on it?

like image 595
Trio Cheung Avatar asked Mar 23 '20 02:03

Trio Cheung


People also ask

Where is ef6 exe?

The ef6.exe command line tool is found in the tools/ subfolder of the EntityFramework NuGet package. Because it is a standalone tool and NuGet packages are ZIP files, the executable can be extracted directly from the package in Windows by downloading the package, changing the extension from . nupkg to .

What is migration exe?

Code First Migrations can be used to update a database from inside visual studio, but can also be executed via the command line tool migrate.exe. This page will give a quick overview on how to use migrate.exe to execute migrations against a database.

What are the different approaches to use EF6?

Here you learn about two different approaches to use EF6: EF Designer and Code First. Make sure you follow the discussion and watch the video about the difference. Working with DbContext DbContext is the first and most important EF type that you need to learn how to use.

Is it possible to use DotNet in EF6?

@Andrew Sorry not so familiar with EF 6. If you are able to use same command line locally. It should also qualify with Azure DevOps. Otherwise , you may not be able to use dotnet command for EF6. Alternatively, you could try to follow Krzysztof Madej's suggestion use Update-Database command with -Migration paramater:

What version of Visual Studio do efef tools come with?

EF Tools are included in all recent versions of Visual Studio. If you perform a custom install of Visual Studio you will need to ensure that the item "Entity Framework 6 Tools" is selected by either choosing a workload that includes it or by selecting it as an individual component.

What is Entity Framework (EF)?

Entity Framework is made up of the EF Tools for Visual Studio and the EF Runtime. The Entity Framework Tools for Visual Studio include the EF Designer and the EF Model Wizard and are required for the database first and model first workflows.


Video Answer


2 Answers

"If you execute Update-Database -Verbose inside Visual Studio's Package Manager Console, it will show you the call it uses to ef.exe to apply migrations." -Brice Lambson

It will be something like:

<PATH_TO_EXE>\ef6.exe database update --connection-string "<CONNECTION_STRING>" --connection-provider System.Data.SqlClient --verbose --no-color --prefix-output --assembly <PATH_TO_DLL> --project-dir <PATH_TO_PROJECT_DIR> --language C# --data-dir <PATH_TO_APP_DATA> --root-namespace <NAMESPACE> --config <PATH_TO_WEB_CONFIG>

Some of the arguments above can be omitted.

You can use the same strategy to determine how to create a migration (Add-Migration) with ef6.exe.

SOURCE: https://github.com/dotnet/ef6/issues/1365#issuecomment-540067758

like image 144
derekbaker783 Avatar answered Sep 25 '22 06:09

derekbaker783


use the command help to get the docs

ef6 --help

or

ef6.exe migrations --help
like image 32
Icewindq Liu Avatar answered Sep 26 '22 06:09

Icewindq Liu