Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and then the data is exported and downloaded as Microsoft Excel file using ClosedXML Excel library which is a wrapper for OpenXml Excel library.

Here Mudassar Ahmed Khan has explained with an example, how to return an Excel File from Controller in ASP.Net MVC Razor using C#.

The Excel File will be generated from database using Entity Framework and then it will be returned from Action method of Controller with FileResult return type in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to split a String into Rows in SQL Server.

This article will illustrate how to create a function that will split a string separated (delimited) by comma, space or some other special characters into Table Rows in SQL Server.

Here Mudassar Ahmed Khan has explained with an example, how to save (upload) Image files to Database using Web API in ASP.Net MVC Razor.

The Web API will insert and retrieve Image files from SQL Server database using Entity Framework in ASP.Net MVC Razor.