Import Excel Data to SQL Server Database using ASP .Net Core Web API and Entity Framework

Опубликовано: 20 Октябрь 2024
на канале: Dex Code Lab
2,163
63

In this tutorial I have created ASP .Net Core Web Web API to uploaded excel file to the server and then insert the content of excel file to Microsoft SQL Server Database. ExcelDataReader nuget package is used to read the excel file.

00:00 - Introduction
00:21 - Create Project
01:30 - Install nuget packages
02:22 - Database Connectivity and Models
05:34 - Run Migration
06:41 - Create Controller
09:28 - Install ExcelDataReader nuget package
11:49 - Test the API

BuyMeCoffee
https://www.buymeacoffee.com/techiebo...