Month: January 2011
-
Remote and Local execution of Query in LINQ
Remote Execution of Query 1. This query executes on the server. 2. Remote execution of query is default in LINQ. 3. In Remote execution advantage of Databases index can be taken. 4. Remote execution allows us to take the advantage of Database server engine. 5. Remote execution allows us to only select particular rows from […]
-
Complied Queries in LINQ
There may be scenario where we need to execute a particular query many times and repeatedly. LINQ allows us to make this task very easy by enabling us to create a query and make it complied always. We call this type of query as complied query. Benefit of Compiled Query 1. Query does need […]
-
Using Stored Procedure in LINQ
We have a strored procedure like below , It is a very simple SP returning grades of the student. This stored procedure name is GetStudentGrade USE [School] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetStudentGrades] @StudentID int AS SELECT EnrollmentID, […]
-
Silverlight WebPart in Share Point2010 using Client object model
In this article we will walkthrough to create Silverlight WebPart and deploy to SharePoint 2010 sites. We will fetching list items using client object model and bind to the Silverlight datagrid. Step1 Open Visual Studio 2010 and create a new Silverlight project by choosing Silverlight project template from Silverlight tab. Step 2 Add the reference […]
Dhananjay Kumar 