The project aims to develop a robust and efficient web application using ASP.NET Core 7 technologies that allows user to import data files, such as XLSX and CSV into a SQL Server database. This application will provide a seamless and user-friendly experience for importing large volumes of data from various file formats (XLSX, CSV) using ASP.NET Core Web API, XML Bulk Insert, Dapper, CsvHelper, EPPlus and coding best practices.
» XLSX and CSV File Support
» File Validation and Error Handling
» Mapping and Transformation
» Data Import Performance Optimization
Tools and Technology Used:
» ASP.NET Core 7 Web API
» ASP.NET Core 7 Razor Pages
» Clean Architecture
» Dapper as ORM
» XML Bulk Insert
To use the solution, you will need the following:
» ASP.NET Core 7
» SQL Server Express 2019
» Visual Studio 2022
To get started with the solution, follow these steps:
» Make sure you have the required tools and technologies installed.
» The solution has two separate execuable projects; ImportDataFile.API and ImportDataFile.UI. Make sure to run API project first, then the UI project.
» Make sure to change the settings in appsettings files according to your UserRootPath, ConnectionStrings, BaseAPIAddress, SiteSettings etc.
» Start exploring the features and functionalities of the solution.
What You Will Get:
» Full Source Code with Visual Studio Solution
» Database Script in SQL Express 2019
Have any questions, issues, or doubts? Feel free to reach out via the comments section or email for direct consultations: email@example.com