{"id":963,"date":"2020-10-13T09:02:44","date_gmt":"2020-10-13T09:02:44","guid":{"rendered":"https:\/\/serkanseker.com\/?p=963"},"modified":"2020-12-08T18:25:28","modified_gmt":"2020-12-08T18:25:28","slug":"asp-net-core-web-api-entity-framework-scaffolding","status":"publish","type":"post","link":"https:\/\/serkanseker.com\/tr\/asp-net-core-web-api-entity-framework-scaffolding\/","title":{"rendered":"ASP.NET Core Web API Entity Framework Scaffolding"},"content":{"rendered":"\n

In this article, we will apply the scaffolding technique in the ASP.NET Core Web API that we have created before, and add the existing database to the project and perform CRUD operations. By using scaffolding, you can perform CRUD operations in the database more quickly.<\/p>\n\n\n\n

Before continuing, I would like to take a look at Create And Consume ASP.NET Core Web API<\/a> and the ASP.NET Core Web API Application Structure<\/a> articles to understand the project structure.<\/p>\n\n\n\n

In this tutorial, we will first add the MS SQL database through Server Explorer, then install the necessary plugins and quickly create our Model classes with Scaffolding and perform CRUD operations. Let’s start.<\/p>\n\n\n\n

Add Data Connection in Server Explorer<\/h2>\n\n\n\n

You can add it from the Server Explorer window to quickly access the existing database that we created using MS SQL Server Studio. If you can’t see the Server Explorer window, you can open it using the Ctrl + Alt + S shortcut.<\/p>\n\n\n\n

First, right-click on Data Connections<\/strong> in the Server Explorer window and select Add Connections. In the window that opens, select the Server Name and the database you want to add and press Ok. If you are using MS SQL Server, you can enter the Server Name as .\\SQLEXPRESS<\/strong>.<\/p>\n\n\n\n

\"Server
Server Explorer Data Connections<\/figcaption><\/figure><\/div>\n\n\n\n
\"Server
Server Explorer Add Connection<\/figcaption><\/figure><\/div>\n\n\n\n

If you have not yet created a database and added data, you can review the articles Creating Microsoft SQL Server Database<\/a> and Manually Database Operations in SQL Server<\/a>.<\/p>\n\n\n\n

Add EntityFramework Plugins<\/h2>\n\n\n\n

Now let’s install the EntitiyFramework plug-ins required in our project while performing the scaffolding process. Right click on the project and go to Manage NuGet <\/a>Packages. Add the following plugins to the project.<\/p>\n\n\n\n

\"Scaffolding
Scaffolding NuGet Package Manager<\/figcaption><\/figure><\/div>\n\n\n\n

Or, you can add plugins via the Package Manager Console by typing the following commands.<\/p>\n\n\n\n

Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 5.0.0-rc.1.20451.13<\/code><\/pre>\n\n\n\n
Install-Package Microsoft.EntityFrameworkCore.Design -Version 5.0.0-rc.1.20451.13<\/code><\/pre>\n\n\n\n
Install-Package Microsoft.EntityFrameworkCore.Tools -Version 5.0.0-rc.1.20451.13<\/code><\/pre>\n\n\n\n
Scaffolding Operation<\/h2>\n\n\n\n
Now it’s time to create entity and context classes by performing scaffolding. To apply scaffolding, enter and run the following command in Package Manager Console.<\/p>\n\n\n\n
Scaffold-DbContext "YourConnectionString" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models<\/code><\/pre>\n\n\n\n
Here, write your own connection string in “Your ConnectionString” section.<\/p>\n\n\n\n
After running this command you will see that Model classes have been added to the project. As you can see, scaffolding saved us time.<\/p>\n\n\n\n
\"Scaffolding
Scaffolding Package Manager Console<\/figcaption><\/figure><\/div>\n\n\n\n
Add Connection String to appsettings.json<\/h2>\n\n\n\n
We created our model classes with scaffolding, but we are still not done. We need to add the connection string we entered while scaffolding to appsettings.json file. Add the following line to the appsettings.json file.<\/p>\n\n\n\n
  "ConnectionStrings": {\n    "Database": "Server=.\\\\sqlexpress;Initial Catalog=Palette;Integrated Security=True"\n  }<\/code><\/pre>\n\n\n\n
Ultimately, the attached version will be like this,<\/p>\n\n\n\n
\"Scaffolding
Scaffolding appsettings.json<\/figcaption><\/figure><\/div>\n\n\n\n
Add DbContext to Startup.cs<\/h2>\n\n\n\n
We need to add our DbContext to the Startup class before adding the Controllers class. Otherwise, if we run the project without adding DbContext, we get runtime error.<\/p>\n\n\n\n
Go to the Startup.cs class and paste the following line into the ConfigureServices method. So much.<\/p>\n\n\n\n
services.AddDbContext<YourContext>(op => op.UseSqlServer(Configuration.GetConnectionString("Database")));<\/code><\/pre>\n\n\n\n
Write your own Context in “YourContext”.<\/p>\n\n\n\n
Add Controllers <\/h2>\n\n\n\n
Eventually, we have come to the last step. Right-click on the Controllers folder and go to Add> Controllers. Here, we can quickly create our controller class from API Controller with actions, using Entity Framework. In the window that opens, create a controller by entering your model class, context class and controller name.<\/p>\n\n\n\n
\"Add
Add New Controller Using Entity Framework<\/figcaption><\/figure><\/div>\n\n\n\n
\"API
API Controller  with actions using Entity Framework<\/figcaption><\/figure>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
And finally our project is ready. Run the project and change the address bar as below.<\/p>\n\n\n\n
\"ASP.NET
ASP.NET Web Core API controller run project<\/figcaption><\/figure><\/div>\n\n\n\n
Related Posts<\/h2>\n\n\n\n