Category - Entity Framework
Results 41 - 60 of 313
27 May 2021 27 May 2021 0 Comments  10137 Views
Here Mudassar Ahmed Khan has explained with an example, how to bind JSON data to View in ASP.Net MVC Razor.

The article will illustrate, how to fetch data from SQL Server Database using Entity Framework, then send it from Controller to View in JSON format and finally bind the JSON data to HTML Table and populate it in ASP.Net MVC Razor.
26 May 2021 26 May 2021 0 Comments  4157 Views
Here Mudassar Ahmed Khan has explained with an example, how to filter Grid using TextBox in ASP.Net MVC Razor.

When the User types in the TextBox, the Grid will be filtered with the help of jQuery AJAX in ASP.Net MVC Razor.
26 May 2021 26 May 2021 0 Comments  7780 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement search as you type in ASP.Net MVC Razor.

Search as you type means, the records in the Grid will be filtered as user types in the TextBox with the help of jQuery AJAX in ASP.Net MVC Razor.
26 May 2021 26 May 2021 0 Comments  6747 Views
Here Mudassar Ahmed Khan has explained with an example, how to use LIKE operator in Entity Framework.

This article will illustrate with an ASP.Net MVC Web Application, how to perform LIKE operator operation in Entity Framework with the help of LINQ Contains function.
24 May 2021 24 May 2021 0 Comments  10923 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using jQuery AJAX in ASP.Net MVC Razor.

The jQuery AJAX function will call Controller’s Action method which will search the SQL Server Database Table using Entity Framework and return the results in JSON format in ASP.Net MVC Razor.
20 May 2021 20 May 2021 0 Comments  2743 Views
Here Mudassar Ahmed Khan has explained with an example, what is the difference between FromSql and ExecuteSqlCommand functions in Entity Framework Core 2.1 framework.
20 May 2021 20 May 2021 1 Comments  5219 Views
Here Mudassar Ahmed Khan has explained with an example, how to execute RAW SQL using Entity Framework Core 2.1 framework in ASP.Net Core MVC.

The RAW SQL Query will be executed using the FromSql function of the Entity Framework Core 2.1 framework in ASP.Net Core MVC.
19 May 2021 19 May 2021 0 Comments  5782 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass parameters to the FromSql function of Entity Framework in ASP.Net Core.

The FromSql function of Entity Framework accepts the parameters as SqlParameter class objects.
19 May 2021 19 May 2021 0 Comments  7334 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the FromSql function of Entity Framework in ASP.Net Core.

The FromSql function is used to execute SQL Queries and Stored Procedures when using Entity Framework in .Net Core.
19 May 2021 19 May 2021 0 Comments  8205 Views
Here Mudassar Ahmed Khan has explained with an example, how to call Stored Procedure with parameters using Entity Framework in .Net Core 2.1.

The Stored Procedures are called with parameters using the FromSql function of Entity Framework in .Net Core 2.1.
19 May 2021 19 May 2021 0 Comments  7772 Views
Here Mudassar Ahmed Khan has explained with an example, how to solve the error related to FromSql function of Entity Framework in .Net Core 2.1.

Error: DBSet<Entity> does not contain a definition for FromSql

The above error occurs because the namespace required to use the FromSql function has not been inherited.

The FromSql function belongs to the Microsoft.EntityFrameworkCore namespace.
18 May 2021 18 May 2021 0 Comments  11729 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using Entity Framework in ASP.Net Core MVC.

The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net Core MVC.
30 Apr 2021 30 Apr 2021 0 Comments  9098 Views
Here Mudassar Ahmed Khan has explained with an example, how to delete data from Database using jQuery AJAX and Entity Framework in ASP.Net MVC Razor.

When the Delete Button is clicked, the DeleteCustomer Action method of the Controller 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.
29 Apr 2021 29 Apr 2021 0 Comments  10779 Views
Here Mudassar Ahmed Khan has explained with an example, how to update data into Database using jQuery AJAX and Entity Framework in ASP.Net MVC Razor.

When the Update Button is clicked, the UpdateCustomer Action method 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.
28 Apr 2021 28 Apr 2021 0 Comments  7612 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert data to Database using jQuery AJAX in ASP.Net MVC Razor.

The data will be inserted in SQL Server Database using Entity Framework in ASP.Net MVC Razor.

Finally, after insertion the ID of the inserted Customer record is returned back to the View in ASP.Net MVC Razor.
28 Apr 2021 28 Apr 2021 0 Comments  10149 Views
Here Mudassar Ahmed Khan has explained with an example, how to get data from Database using jQuery AJAX in ASP.Net MVC Razor.

This article will illustrate how to use jQuery AJAX function to get data from SQL Server database and then populate the data in an HTML Table using ASP.Net MVC Razor.
28 Apr 2021 28 Apr 2021 0 Comments  9424 Views
Here Mudassar Ahmed Khan has explained with an example, how to save Form data to Database using jQuery AJAX in ASP.Net MVC Razor.

When the Add Button is clicked, the InsertCustomer Action method 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.
30 Mar 2021 30 Mar 2021 0 Comments  6369 Views
Here Mudassar Ahmed Khan has explained an example, how to display multiple CheckBoxes with Checked Unchecked values in ASP.Net MVC Razor.

The CheckBoxes along with their checked or unchecked (selected) values will be populated from SQL Server database using Entity Framework in ASP.Net MVC Razor.
19 Feb 2021 19 Feb 2021 0 Comments  7767 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert DropDownList selected value in SQL Server Database in ASP.Net Core MVC.

The selected value of the DropDownList will be inserted into SQL Server Database using Entity Framework in ASP.Net Core MVC.
15 Jan 2021 15 Jan 2021 0 Comments  7199 Views
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.
Results 41 - 60 of 313