Search In
While writing codes in MVC we use different way to interact with the database.
Then we can use LINQ for doing it in the database it will make our code easy to read and make the manipulation easy and faster.
First we will create a Da
While working in MVC we use LINQ to make our task easier and to make the manipulations easier
First we will create the action for doing this task.
[HttpPost]
public JsonResult Remove(int id)
{
n
In writing the code in MVC we can use the LINQ Language Integrated Query then we use this query for interacting with the database that will make the manipulations easier and time efficient in terms of execution and in terms of programming .
&n
The Language Integrated Query is used to perform the task of the user programmer more easier as it can be used to interact with any data source like XML file or SQL Server database or Array or Hash table.
We use it for the selection of the d
In today's world, there are lots of client side scripts to make a better user interface. In this article, we are going to bind the data and apply sorting and filtering using AngularJS.
Open your favourite text editor and create directory structu
In today's world, we need to display the data in tabular format with edit and delete functionality. For example, in ASP.NET we have Gridview control, which is more simple to achieve this. We have Edit data template and view template in ASP.NET Gr
Arithmetic operations are very basic in every strongly type programming languages. We will oftenly save the result of this arithmetic computation in certain type of variable. Suppose if I am adding two integers then i will save the result in in
In SQL Server, we are very familiar with IN keyword and we use this keyword in many times which is very helpful for us. It save our extra efforts and code line like below query.
To achieve this in LINQ , we heve below two mechanism
There might be some scenario in your code, where some of the tasks should be performed in the background without affecting the current task. Some time we have scenario, where we needed to fire the function, which consists of some function call, where
TRIGGERS IN MS-SQL
Triggers are special kind of stored procedures that triggers automatically when an event occur. Triggers are written to fire when a specific event on table occurs. Following are the events that may force trigger-:
1) DML operatio
