Scaffold-dbcontext : a positional parameter cannot be found that accepts argument 'models

Question

1.00/5 (1 vote)

See more:

Hi Team

I am facing this Nuget command issue with my console, basically i want to run DbContext to my project hence its not existing. I ran some packages like EntityFramework.Tools and SqlServer, still i wasnt able to achieve this on time, what could be an issue?

What I have tried:

scaffold-DBContext "Data Source=(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-OutputDir Models

Posted 10-Feb-20 19:02pm

gcogco10

Updated 10-Feb-20 22:14pm

Add a Solution

Comments

gcogco10 11-Feb-20 2:30am

I am trying to amend the command to scaffold-DBContext "Data Source=(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-Verbose, still no luck as to what could be an issue.

Liktor Janos 11-Feb-20 2:44am

Can you show the exact error message? It would be easier to help if we know more than "still no luck"

gcogco10 11-Feb-20 2:46am

Unable to find provider assembly with name Microsoft.EntityFrameworkCore.SqlServer-Verbose. Ensure the specified name is correct and is referenced by the project.

Liktor Janos 11-Feb-20 2:50am

Hm... maybe you should put a space between "SqlServer" and "-Verbose"
The same goes to your first command too with the -OutputDir argument.

Liktor Janos 11-Feb-20 2:49am

By the way, you should check these:
- Are your connection string settings correct?
- All of your related tables has primary keys?
- Maybe your new files exists, however they are not added to the solution.

gcogco10 11-Feb-20 2:51am

@Liktor, i would say each time im trying to run the command its not added to the solution. Here is my connectionString below, <connectionstrings>
<add name="eNtsaOnlineRegistrationDB" connectionstring="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=eNtsaOnlineRegistration; Integrated Security=True" providername="System.Data.SqlClient">

gcogco10 11-Feb-20 2:53am

Ok mate i re ran the command and getting new error. Its this one scaffold-DBContext : Exception calling "Start" with "1" argument(s): "The system cannot find the file specified" yes i put space after sqlServer -Verbose and got the above error.

Liktor Janos 11-Feb-20 3:00am

Ok, now we have an error message :) Let's see what file path involved in this issue.
You can be wrong with:
- path to mdf file
- path to target directory
You should try all of these paths as an absoulute path. Of course not for production, just for bug hunting. I mean like this: -OutputDir c:\somedirectory\

gcogco10 11-Feb-20 3:02am

Ok so now must i put the directory of the project where mdf file is located, right after -OutputDir?

Liktor Janos 11-Feb-20 3:31am

It's worth a try. Just for make sure: your MDF file is exists and valid and accessible.
And the same goes for the -OutputDir, because there is no directory hanging in the air like "Models". It has to be a path that leads for this directory. You can specify it, or it can depends on current directory.

By the way what happens if you run the DIR command in package management console?

gcogco10 11-Feb-20 3:34am

Ok i did that mate, and had missing package called Microsoft.EntityFramework.Tools v 3.1.1. The error was gone, but now i cant seem to find new DbContext class under Model folder. that was initial goal to get access to my DBContext. Help me to this issue.

Liktor Janos 11-Feb-20 3:53am

Mmmmaybeeee.. I'm misunderstood something.
You HAD missing package problem, but you RESOLVED it already, and now you simply seek for that DbContext.cs file?

Liktor Janos 11-Feb-20 3:46am

I think this is merely an RTFM situation :-)
Nevertheless I'll try to help :)
So... now you should resolve the missing package issues. Yes, maybe you'll have more than one as you proceed further. Try the NuGet GUI to resolve these missing package things. It's more simple than command line.
After that, you should check the current directory in PM console. Try that DIR command as I suggested above. Based on that output you can check if there is a MODEL directory, and WHERE is this MODEL directory.

gcogco10 11-Feb-20 3:58am

I ran it and now iam getting Keyword not supported 'catalog'

Liktor Janos 11-Feb-20 4:04am

Your connectionstring is wrong. There is no catalog parameter. The correct one is "Initial Catalog"

gcogco10 11-Feb-20 4:12am

How do i modified my connectionString mate? an example will be enough for me to try and test this now.

Liktor Janos 11-Feb-20 4:16am

A can't give you a working example, because the exact environment is known by only you.
Try this one though: https://www.connectionstrings.com/sql-server/

gcogco10 11-Feb-20 4:27am

Here is my connectionString and yet i am using Initial Catalog correctly, <connectionstrings>
<add name="eNtsaOnlineRegistrationDB" connectionstring="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=master; Integrated Security=True" providername="System.Data.SqlClient">

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2020-02-10T22:15:00

Solution 1

See EF Core tools reference (Package Manager Console) - EF Core | Microsoft Docs[^]

Posted 10-Feb-20 22:15pm

Richard MacCutchan

Comments

gcogco10 11-Feb-20 5:33am

Richard McCutchan thanks so much mate, you are star. I had to follow the documentation step by step. Now can able to see my all my DbContext under the Model Folder. Thanks mate dammm what an excercise.

Richard MacCutchan 11-Feb-20 11:51am

It's always worth going to the documentation first.