SQL Server Articles

Category - SQL Server

15 Jan 2021 Mudassar Khan 0 Comments 1097 Views

ASP.Net SQL Server Entity Framework MVC Model Core

Here Mudassar Ahmed Khan has explained with an example, how to pass Model data from Controller to View in ASP.Net Core MVC.

The data from the SQL Server Database will be fetched using Entity Framework and populated into Model which will be later sent to the View in ASP.Net Core MVC.

02 Jan 2021 Mudassar Khan 0 Comments 1744 Views

ASP.Net SQL Server MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to set Connection String with Windows Authentication in AppSettings.json in .Net Core and ASP.Net Core MVC.

In a Connection String with Windows Authentication, the Integrated Security property is set to TRUE.

02 Jan 2021 Mudassar Khan 0 Comments 1901 Views

ASP.Net SQL Server MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to set SQL Server Connection String in AppSettings.json in .Net Core and ASP.Net Core MVC.

SQL Server Database has two types of Connection Strings i.e. Windows Authentication and SQL Server Authentication.

02 Jan 2021 Mudassar Khan 0 Comments 1268 Views

ASP.Net SQL Server MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to set Connection String with SQL Server Authentication in AppSettings.json in .Net Core and ASP.Net Core MVC.

In a Connection String with SQL Server Authentication, the User Id and Password of the SQL Server Database is specified.

15 Dec 2020 Mudassar Khan 0 Comments 1099 Views

ASP.Net Excel SQL Server Entity Framework Core Razor Pages

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

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.