Programmer / Analyst

Babak Sekandari

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have an ASP.NET MVC Core 2.1.1 project running in Visual Studio 2019. <br />
Since I have already created a database, I want to connect the application to the existing database with database-first development.<br />
From the Visual Studio, Package Manager Console, I put in:<br />
<br />
Scaffold-DbContext &quot;server=ServerName;Databas<wbr />e=DbName; Trusted_Connection=true; Microsoft.EntityFrameworkC<wbr />ore.SqlSer<wbr />ver -OutputDir Models<br />
<br />
That gives me the following error:<br />
The EF Core tools version '2.1.1-rtm-30846' is older than that of the runtime '2.1.8-servicing-32085'. Update the tools for the latest features and bug fixes.<br />
Unable to find provider assembly with name server=ServerName. Ensure the specified name is correct and is referenced by the project.<br />
<br />
I got the name, ServerName, directly from the Visual Studio connection properties:<br />
Data Source=ServerName; Initial Catalog=DbName; Integrated Security=True<br />
<br />
Is there something different I should put for ServerName?
</div>
</div>


Hi,
I have an ASP.NET MVC Core 2.1.1 project running in Visual Studio 2019. 
Since I have already created a database, I want to connect the application to the existing database with database-first development.
From the Visual Studio, Package Manager Console, I put in:

Scaffold-DbContext "server=ServerName;Database=DbName; Trusted_Connection=true; Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

That gives me the following error:
The EF Core tools version '2.1.1-rtm-30846' is older than that of the runtime '2.1.8-servicing-32085'. Update the tools for the latest features and bug fixes.
Unable to find provider assembly with name server=ServerName. Ensure the specified name is correct and is referenced by the project.

I got the name, ServerName, directly from the Visual Studio connection properties:
Data Source=ServerName; Initial Catalog=DbName; Integrated Security=True

Is there something different I should put for ServerName?

For .NET Core Database-First scaffolding, how do I get the server connection ?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.