Contoso University - DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer'

Question

User281366353 posted

I am trying to work through the Contoso University example application.  I have simply copied the Startup.cs class statements:

services.AddDbContext<SchoolContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

I receive the error:

DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer' and no accessible extension method. 'UseSqlServer' accepting a first argument of type 'DbContextOptionBuilder' could be found ( are you missing a using directive or an assemply reference)

What do I need to do to move forward?

Thanks

Answer 1

User475983607 posted

What do I need to do to move forward?

You missed a the scaffolding step.  This step creates adds the required packages, connection string, and updates the startup.cs file. 

https://docs.microsoft.com/en-us/aspnet/core/data/ef-rp/intro?view=aspnetcore-3.1&tabs=visual-studio#scaffold-student-pages

Answer 2

User711641945 posted

Hi Geol4549,

Add the reference like below:

using Microsoft.EntityFrameworkCore;

Best Regards,

Rena

Answer 3

User-1955300613 posted

Hi Geol4549,

Thanks for your question,

The following maybe a solution:

If you use the EF Core, you must add  ' Microsoft.EntityFrameworkCore.SqlServer ' to your reference,

and then don't forget to apply   ' using Microsoft.EntityFrameworkCore ' to source file.

Best regards,

Tsaisoul.

Answer 4

User281366353 posted

I'd like to thank those who replied, but I can't  run the scaffolding procedure because in the Program.cs file error: 

CreateWebHostBuilder does not exist in the current context. 

Answer 5

User475983607 posted

Geol4549

I'd like to thank those who replied, but I can't  run the scaffolding procedure because in the Program.cs file error: 

CreateWebHostBuilder does not exist in the current context. 

It's not real clear how you got to this point.   Delete the project and start over or download the completed project and compare the difference to your code.

Answer 6

User281366353 posted

Thank you for your response.  I did delete the project and start over.