I had just enabled the plugin and restarted Rider.

Sync execution of rpc RiderClient.SolutionModel.solutions.[1].riderEfCoreModel.getAvailableStartupProjects executed too long: 784 ms

java.lang.Exception at com.jetbrains.rd.platform.util.IdeaRdLoggerFactor$getLogger$1.log(IdeaRdLoggerFactor.kt:28) at com.jetbrains.rd.util.SwitchLogger.log(Logger.kt:47) at com.jetbrains.rd.framework.impl.RdCall.sync(RdTask.kt:228) at com.jetbrains.rd.framework.IRdCall$DefaultImpls.sync$default(TaskInterfaces.kt:123) at me.seclerp.rider.plugins.efcore.startup.EfCoreStartupActivity.runActivity$lambda-0(EfCoreStartupActivity.kt:21) at com.intellij.openapi.application.TransactionGuardImpl.runWithWritingAllowed(TransactionGuardImpl.java:215) at com.intellij.openapi.application.TransactionGuardImpl.access$100(TransactionGuardImpl.java:22) at com.intellij.openapi.application.TransactionGuardImpl$1.run(TransactionGuardImpl.java:197) at com.intellij.openapi.application.impl.ApplicationImpl.runIntendedWriteActionOnCurrentThread(ApplicationImpl.java:873) at com.intellij.openapi.application.impl.ApplicationImpl$3.run(ApplicationImpl.java:511) at com.intellij.openapi.application.impl.LaterInvocator$1.run(LaterInvocator.java:96) at com.intellij.openapi.application.impl.FlushQueue.doRun(FlushQueue.java:69) at com.intellij.openapi.application.impl.FlushQueue.runNextEvent(FlushQueue.java:112) at com.intellij.openapi.application.impl.FlushQueue.flushNow(FlushQueue.java:42) at java.desktop/java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:313) at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:776) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:727) at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721) at java.base/java.security.AccessController.doPrivileged(Native Method) at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85) at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:746) at com.intellij.ide.IdeEventQueue.defaultDispatchEvent(IdeEventQueue.java:898) at com.intellij.ide.IdeEventQueue._dispatchEvent(IdeEventQueue.java:746) at com.intellij.ide.IdeEventQueue.lambda$dispatchEvent$6(IdeEventQueue.java:439) at com.intellij.openapi.progress.impl.CoreProgressManager.computePrioritized(CoreProgressManager.java:803) at com.intellij.ide.IdeEventQueue.lambda$dispatchEvent$7(IdeEventQueue.java:438) at com.intellij.openapi.application.TransactionGuardImpl.performActivity(TransactionGuardImpl.java:106) at com.intellij.ide.IdeEventQueue.performActivity(IdeEventQueue.java:604) at com.intellij.ide.IdeEventQueue.lambda$dispatchEvent$8(IdeEventQueue.java:436) at com.intellij.openapi.application.impl.ApplicationImpl.runIntendedWriteActionOnCurrentThread(ApplicationImpl.java:873) at com.intellij.ide.IdeEventQueue.dispatchEvent(IdeEventQueue.java:484) at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:207) at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128) at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113) at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105) at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:92)

Hello, i just installed this amazing plugin and it seems to be not working well, it seems like it wont detect my dotnet ef (i installed it) but Rider seems like to not detect it, any fix for that?

DataAccess project

    <ItemGroup>
      <PackageReference Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="6.0.8" />
      <PackageReference Include="Microsoft.EntityFrameworkCore" Version="6.0.8" />
      <PackageReference Include="Microsoft.Extensions.Identity.Stores" Version="6.0.8" />
      <PackageReference Include="Newtonsoft.Json" Version="13.0.1" />
    </ItemGroup>

Startup Project:

    <ItemGroup>
        <PackageReference Include="Microsoft.AspNetCore.Authentication.JwtBearer" Version="6.0.7" />
        <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="6.0.8">
          <PrivateAssets>all</PrivateAssets>
          <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
        </PackageReference>
        <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="6.0.8" />
        <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="6.0.8">
          <PrivateAssets>all</PrivateAssets>
          <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
        </PackageReference>
        <PackageReference Include="Swashbuckle.AspNetCore" Version="6.2.3" />
    </ItemGroup>

• OS: Win10
• .NET SDK info (installed ones and version used within Rider): Net. 6
• Plugin version: latest
• Rider version: latest

Hi,

I'm forced to use MacOs at work, and tried to use install the plugin today, but unfortunately the plugin doesn't seem to be able to find dotnet. In the Event log, I can see the following:

13.01.22
11:45	EF Core tools are not installed
			These tools are required to execute EF Core commands
			Fix

11:45	EF Core command failed
			Command: dotnet tool install --global dotnet-ef
			
			Output:
			java.io.IOException: Cannot run program "dotnet": error=2, No such file or directory
			
			Exit code: -1
			Try Again

Using dotnet and dotnet-ef over the normal terminal and Riders integrated terminal works normally, so it seems to be available in the PATH. I'm using dotnet 6.0.101.

I'm using Rider 2021.3.2 Entity Framework Core UI: 1.1.2 MacOS 11.6.1

Any idea why that might be happening or what I can do to get it working? If you do not have access to a Mac I'm happy to further assist.

We have several projects, 2 are relevant: Domain.csproj Web.csproj

Domain contains the migrations, and the DbContext class. Web contains the startup code.

To add a migration is (from within the domain project): dotnet ef --startup-project ../web migrations add …

However the 'Add Migration' dialog does not present the Web project as an option.

Startup project list:

Migrations project list:

If I write multiple migrations, I have to set all fields in the "Add Migration" dialog again for every single migration (mainly "Migrations project", "Startup project" and "DBContext class"). So currently, I'm actually faster if I use the command line, since there I can just save the command in clipboard, paste it and change just the migration name.

Please change the last settings somewhere on the file system so if I use the dialog again, they are still present.

Hi, I am using this plugin in rider of Mac.

There are two projects ZiyouServer and ZiyouServer.Base, the dbcontext class is in the ZiyouServer.Base project and the ZiyouServer is a web api project as startup project. However , I can not select the startup project.

When I open .Net6 project in Rider I got exception. Below is call stack.

• OS: macOS Monterey 12.5
• .NET SDK info (installed ones and version used within Rider): Net6
• Plugin version: 222.0.0
• Rider version: 2022.2.3345.139

Exception java.lang.NullPointerException: Cannot invoke "java.io.File.toString()" because the return value of "com.intellij.execution.configurations.GeneralCommandLine.getWorkDirectory()" is null at me.seclerp.rider.plugins.efcore.cli.execution.CliCommand.<init>(CliCommand.kt:12) at me.seclerp.rider.plugins.efcore.cli.api.ManagementCommandFactory.installEfCoreTools(ManagementCommandFactory.kt:17) at me.seclerp.rider.plugins.efcore.features.eftools.InstallDotnetEfAction$actionPerformed$1.invoke(InstallDotnetEfAction.kt:18) at me.seclerp.rider.plugins.efcore.features.eftools.InstallDotnetEfAction$actionPerformed$1.invoke(InstallDotnetEfAction.kt:11) at me.seclerp.rider.plugins.efcore.cli.execution.ExtensionsKt$executeCommandUnderProgress$$inlined$runBackgroundableTask$1.run(progress.kt:36) at com.intellij.openapi.progress.impl.CoreProgressManager.startTask(CoreProgressManager.java:442) at com.intellij.openapi.progress.impl.ProgressManagerImpl.startTask(ProgressManagerImpl.java:114) at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcessWithProgressAsynchronously$5(CoreProgressManager.java:493) at com.intellij.codeWithMe.ClientId$Companion$decorateFunction$2.apply(ClientId.kt:307) at com.intellij.codeWithMe.ClientId$Companion$decorateFunction$2.apply(ClientId.kt:307) at com.intellij.openapi.progress.impl.ProgressRunner.lambda$submit$3(ProgressRunner.java:252) at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcess$2(CoreProgressManager.java:188) at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$executeProcessUnderProgress$12(CoreProgressManager.java:608) at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:683) at com.intellij.openapi.progress.impl.CoreProgressManager.computeUnderProgress(CoreProgressManager.java:639) at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:607) at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:60) at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:175) at com.intellij.openapi.progress.impl.ProgressRunner.lambda$submit$4(ProgressRunner.java:252) at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:702) at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:699) at java.base/java.security.AccessController.doPrivileged(AccessController.java:399) at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1.run(Executors.java:699) at java.base/java.lang.Thread.run(Thread.java:833)

I love your plugin. It using EF so much easier!

I have a setup, where we are using appsettings.local.json and while using dotnet ef we have to pass --environment Local as arguments to the command line. It would be helpful if we can just pass the environment in the UI and UI would save that for future usage!

Describe the bug

When I try to run any of the Entity Framework Core UI tools I get the same error. "EF Core command failed". The error shows the command that I tried however if I were to copy the command into the terminal in Rider the command will execute.

To Reproduce

Steps to reproduce the behavior:

1. Create a new ASP.NET Core Web Application. SDK: Net 6, Web App (MVC), Individual Authentication
2. Try to use the tool

Expected behavior

This is the error I received: Command: dotnet ef database update --project /home/<username>/<path-to-project>/<projectname>.csproj --startup-project /home/<username>/<path-to-project>/<projectname>.csproj --context <projectname>.Data.ApplicationDbContext --configuration Debug 00000000000000_CreateIdentitySchema Output: Unable to retrieve project metadata. Ensure it's an SDK-style project. If you're using a custom BaseIntermediateOutputPath or MSBuildProjectExtensionsPath values, Use the --msbuildprojectextensionspath option. Error: Could not execute because the application was not found or a compatible .NET SDK is not installed. Possible reasons for this include: * You intended to execute a .NET program: The application 'msbuild' does not exist. * You intended to execute a .NET SDK command: It was not possible to find any installed .NET SDKs. Install a .NET SDK from: https://aka.ms/dotnet-download Exit code: 1

Environment (please complete the following information):

• OS: Ubuntu 20.04.4 x86_64
• .NET SDK info (installed ones and version used within Rider): (installed) 3.1, 5; (using) Net 6.0.301
• Plugin version: 1.4.0
• Rider version: 2022.1.2

Additional context

I have manually installed the .Net SDKs that I used because snap is annoying. I don't know if that affects this bug.

Changes allow for persistence of the DbContext fields between reloads. Support mentioned in https://github.com/seclerp/rider-efcore/issues/54. Once entered and OK is pressed, values are saved for the next scaffolding. Build option was shared between dialog screens, so that was untouched.

Now that the wonderful console view is implemented, could you please add the command to list migrations?

ie: Having a new 'List Migrations' command here:

This is really crucial when working across multiple environments and you want to check which migrations are currently applied – as well as during development as you temporarily up and down migrations until you get the ORM mappings in the DbContext set up just right.

EF command dotnet ef migrations list

NOTE: The same parameters from the other commands should be included, such as the starting project, custom arguments being passed in etc.

Keep rocking! 💪

EF Core 7 adds support for the dotnet ef dbcontext scaffold output customization using T4 templates. There is an article about it.

From the plugin side, we need to add action to support dotnet new ef-templates (.NET template that generates EF Core related T4 templates) from Microsoft.EntityFrameworkCore.Templates::7.0.0-*.

Also need to investigate a way of managing installed EF Core Tooling in the separated dialog or settings page.

Because of Microsoft.EntityFrameworkCore.Templates is still not available, there is a .zip containing EF Core T4 templates snapshot.

Related discussion: https://github.com/dotnet/efcore/issues/26798#issuecomment-1227748887

In current behavior, we are using .NET CLI just like simple dotnet command from a working directory.

Need to get a path to the currently selected .NET SDK in Rider to obtain the correct dotnet CLI path.

Notes:

• ISolutionToolset.GetDotNetCoreToolset() should help with that (backend)

Describe the bug

The extension is throwing an extension that seems to be related to dotnet not command not being accessible (not installed or not on the path).

Note that, once dotnet is installed the problem no longer occurs, therefore the "impact" is low.

To Reproduce

Steps to reproduce the behavior:

1. Remove all traces of dotnet (or use a machine that does not have it installed yet)
2. Install Rider and the extension
3. Open a project where the extension would be used
4. Check that the extension throws an exception (excerpt is below)

Expected behavior

The extension should gracefully notify the user that it was unable to find or access the dotnet command.

Environment (please complete the following information):

• OS: Windows 10 Pro
• .NET SDK info (installed ones and version used within Rider): No .NET SDK was installed
• Plugin version: 1.4.0
• Rider version: 2022.1.2

Additional context

Exception log from Rider:

com.intellij.execution.process.ProcessNotCreatedException: Cannot run program "dotnet": CreateProcess error=2, The system cannot find the file specified at com.intellij.execution.configurations.GeneralCommandLine.createProcess(GeneralCommandLine.java:362) at com.intellij.execution.process.OSProcessHandler.startProcess(OSProcessHandler.java:92) at com.intellij.execution.process.OSProcessHandler.(OSProcessHandler.java:45) at com.intellij.execution.process.CapturingProcessHandler.(CapturingProcessHandler.java:20) at com.intellij.execution.util.ExecUtil.execAndGetOutput(ExecUtil.kt:88) at me.seclerp.rider.plugins.efcore.cli.execution.CliCommand.execute(CliCommand.kt:14) at me.seclerp.rider.plugins.efcore.cli.api.ManagementClient.getEfCoreVersion(ManagementClient.kt:18) at me.seclerp.rider.plugins.efcore.startup.EfCoreStartupActivity.runActivity(EfCoreStartupActivity.kt:30) at com.intellij.ide.startup.impl.StartupManagerImpl.runStartupActivity(StartupManagerImpl.kt:311) at com.intellij.ide.startup.impl.StartupManagerImpl.runActivityAndMeasureDuration(StartupManagerImpl.kt:290) at com.intellij.ide.startup.impl.StartupManagerImpl.runActivityAndMeasureDuration$default(StartupManagerImpl.kt:285) at com.intellij.ide.startup.impl.StartupManagerImpl$runPostStartupActivities$1$1.run(StartupManagerImpl.kt:238) at com.intellij.openapi.project.DumbServiceImpl.runWithWaitForSmartModeDisabled(DumbServiceImpl.java:648) at com.intellij.ide.startup.impl.StartupManagerImpl$runPostStartupActivities$1.accept(StartupManagerImpl.kt:237) at com.intellij.ide.startup.impl.StartupManagerImpl$runPostStartupActivities$1.accept(StartupManagerImpl.kt:62) at com.intellij.openapi.extensions.impl.ExtensionPointImpl.processWithPluginDescriptor(ExtensionPointImpl.java:301) at com.intellij.openapi.extensions.ExtensionPointName.processWithPluginDescriptor(ExtensionPointName.java:143) at com.intellij.ide.startup.impl.StartupManagerImpl.runPostStartupActivities(StartupManagerImpl.kt:232) at com.intellij.ide.startup.impl.StartupManagerImpl.access$runPostStartupActivities(StartupManagerImpl.kt:62) at com.intellij.ide.startup.impl.StartupManagerImpl$projectOpened$3$1.run(StartupManagerImpl.kt:180) at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcess$2(CoreProgressManager.java:189) at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$executeProcessUnderProgress$12(CoreProgressManager.java:608) at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:683) at com.intellij.openapi.progress.impl.CoreProgressManager.computeUnderProgress(CoreProgressManager.java:639) at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:607) at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:60) at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:176) at com.intellij.openapi.progress.util.BackgroundTaskUtil.runUnderDisposeAwareIndicator(BackgroundTaskUtil.java:365) at com.intellij.openapi.progress.util.BackgroundTaskUtil.runUnderDisposeAwareIndicator(BackgroundTaskUtil.java:343) at com.intellij.ide.startup.impl.StartupManagerImpl$projectOpened$3.run(StartupManagerImpl.kt:180) at java.base/java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) Caused by: java.io.IOException: Cannot run program "dotnet": CreateProcess error=2, The system cannot find the file specified at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1128) at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1071) at com.intellij.execution.configurations.GeneralCommandLine.startProcess(GeneralCommandLine.java:438) at com.intellij.execution.configurations.GeneralCommandLine.createProcess(GeneralCommandLine.java:352) ... 35 more Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified at java.base/java.lang.ProcessImpl.create(Native Method) at java.base/java.lang.ProcessImpl.(ProcessImpl.java:487) at java.base/java.lang.ProcessImpl.start(ProcessImpl.java:154) at java.base/java.lang.ProcessBuilder.start(ProcessBuilder.java:1107) ... 38 more

When the project uses EntityFramework.Exceptions, SaveChanges/SaveChangesAsync could lead to exceptions. E.g.:

context.Posts.Insert(post);
context.{caret}SaveChanges(); // Warning EFXXXX: EF Core state mutatioon could lead to exceptions

context.Posts.Insert(post);

try
{
  context.SaveChanges();
}
catch (UniqueConstraintException ex)
{
  {selstart}throw new NotImplementedException();{selend}
}

The fix should generate exception-catching blocks according to an analysis of the model and context. For example, [UniqueConstraint] or [ForeignKey] attributes could lead to UniqueConstraintException and ReferenceConstraintException respectively.

Full list of currently available exceptions:

• UniqueConstraintException
• CannotInsertNullException
• MaxLengthExceededException
• NumericOverflowException
• ReferenceConstraintException