Category - Entity Framework
Results 61 - 80 of 313
15 Dec 2020 15 Dec 2020 0 Comments  12451 Views
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.
12 Dec 2020 15 Dec 2020 0 Comments  21496 Views
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.
09 Dec 2020 09 Dec 2020 0 Comments  17909 Views
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.
28 Nov 2020 28 Nov 2020 1 Comments  16383 Views
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.
28 Nov 2020 28 Nov 2020 0 Comments  4771 Views
Here Mudassar Ahmed Khan has explained with an example, how to create and consume a Web API that gets data from SQL Server Database in ASP.Net MVC Razor.

This article will illustrate how to connect a Web API to Database using Entity Framework in ASP.Net MVC Razor.
27 Nov 2020 27 Nov 2020 0 Comments  4975 Views
Here Mudassar Ahmed Khan has explained with an example, how to create and consume a Web API DELETE Action method in ASP.Net MVC Razor.

This article will illustrate how to create a DELETE Action method in Web API and use it for deleting records in Database using Entity Framework in ASP.Net MVC Razor.
27 Nov 2020 27 Nov 2020 0 Comments  7286 Views
Here Mudassar Ahmed Khan has explained with an example, how to delete data from Database using Web API and Entity Framework in ASP.Net MVC Razor.

When the Delete Button is clicked, the DeleteCustomer Action method of the Web API is called using jQuery AJAX and the details of Customer are sent as JSON object.

Finally, a Customer object is sent to the View which indicates that the record was successfully deleted or not.
24 Nov 2020 24 Nov 2020 0 Comments  4153 Views
Here Mudassar Ahmed Khan has explained with an example, how to create and consume a Web API POST Action method in ASP.Net MVC Razor.

This article will illustrate how to create a POST Action method in Web API and use it for inserting records in Database using Entity Framework in ASP.Net MVC Razor.
24 Nov 2020 24 Nov 2020 0 Comments  8426 Views
Here Mudassar Ahmed Khan has explained with an example, how to update data into Database using Web API and Entity Framework in ASP.Net MVC Razor.

When the Update Button is clicked, the UpdateCustomer Action method of the Web API is called using jQuery AJAX and the details of Customer are sent as JSON object.

Finally, a Boolean response is sent to the View which indicates that the record was successfully updated or not.
24 Nov 2020 24 Nov 2020 0 Comments  5839 Views
Here Mudassar Ahmed Khan has explained with an example, how call (consume) Web API GET method in ASP.Net MVC Razor.

The Web API Action method will be called inside the MVC Controller’s Action method using HttpClient class in ASP.Net MVC Razor.
24 Nov 2020 24 Nov 2020 0 Comments  11993 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert data into Database using Web API and Entity Framework in ASP.Net MVC Razor.

When the Add Button is clicked, the InsertCustomer Action method of the Web API is called using jQuery AJAX and the details of Customer are sent as JSON object.

Finally, after insertion the ID of the inserted Customer record is returned back to the View in ASP.Net MVC Razor.
21 Nov 2020 21 Nov 2020 0 Comments  14166 Views
Here Mudassar Ahmed Khan has explained with an example, how to do a Database Connection without using Entity Framework in ASP.Net Core Razor Pages.

This article will illustrate how to connect to Database using ADO.Net and fetch data from Database using SqlDataReader in ASP.Net Core Razor Pages.
21 Nov 2020 21 Nov 2020 0 Comments  12459 Views
Here Mudassar Ahmed Khan has explained with an example, how to get Auto Increment Primary Key with Entity Framework Database First using C# in ASP.Net MVC Razor.

When the Form is submitted, the value of the submitted Form fields will be fetched using Entity Framework Model class object and will be inserted into database using Entity Framework. After successful insert, the ID of the last inserted record fetched using SCOPE_IDENTITY will be displayed using JavaScript Alert Message Box.
20 Nov 2020 20 Nov 2020 0 Comments  11790 Views
Here Mudassar Ahmed Khan has explained with an example, how to call Web API from another Project in ASP.Net MVC Razor.

The Web API 2 Controller’s Action method will fetch records from the SQL Server Database using Entity Framework in ASP.Net MVC Razor.

The Web API 2 Controller’s Action method will be called using WebClient class from another MVC Project using the Web API URL.
19 Nov 2020 19 Nov 2020 0 Comments  19272 Views
Here Mudassar Ahmed Khan has explained with an example, how to create Web API in ASP.Net C# with SQL server database in ASP.Net MVC Razor.

The Web API Controller method will fetch records from SQL server database using Entity Framework in ASP.Net MVC Razor.
19 Nov 2020 19 Nov 2020 0 Comments  9032 Views
Here Mudassar Ahmed Khan has explained a tutorial with example, how to perform Web API CRUD with Entity Framework Database First approach in ASP.Net MVC Razor.

The Entity Framework will be used to connect to the SQL Server Database with existing Tables i.e. Database First Approach.
19 Nov 2020 19 Nov 2020 0 Comments  6539 Views
Here Mudassar Ahmed Khan has explained a tutorial with example, how to perform Web API CRUD Operations using Entity Framework in ASP.Net MVC Razor.

The Web API will contain Action methods for performing the CRUD operations i.e. Create (Insert), Read (Select), Update and Delete and the CRUD operations will be performed in SQL Server Database using Entity Framework in ASP.Net MVC Razor.
18 Nov 2020 18 Nov 2020 0 Comments  13461 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass (send) data from Page Model to Razor Page (cshtml) in ASP.Net Core Razor Pages.

The data will be set into a public property inside the Page Model and then using Razor syntax the data will be fetched inside the Razor Page (cshtml) in ASP.Net Core Razor Pages.
17 Nov 2020 17 Nov 2020 0 Comments  11707 Views
Here Mudassar Ahmed Khan has explained with an example, how to loop through Model properties using FOR EACH loop in ASP.Net Core MVC.

The Entity Framework will be used to fetch the data from Database and populate the Model class properties.

Then inside the View, using a FOR EACH loop the Model items will be traversed and data will be displayed using HTML Table in ASP.Net Core MVC.
17 Nov 2020 17 Nov 2020 0 Comments  14247 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform looping through Model properties in View using FOR EACH loop in ASP.Net MVC Razor.

The Entity Framework will be used to fetch the data from Database and populate the Model class properties.

Finally inside the View, using a FOR EACH loop the Model items will be traversed and data will be displayed using HTML Table in ASP.Net MVC Razor.
Results 61 - 80 of 313