Content Editor Web Part in SharePoint 2010

Target Audience : Begineers This articles is targeted to beginners of SharePoint 2010. In this article we will walkthrough 1. Adding a Web part Page 2. Content Editor Web Part on the page. Follow the steps as below, Step1 Open SharePoint site and click on Site Action . From Site Action drop down select moreContinue reading "Content Editor Web Part in SharePoint 2010"

WCF RIA Service Adding Query Methods

Learning WCF RIA Service Part#1 can be read here This is the second article of learning WCF RIA series. In this article we will see 1. How to pass parameter in query 2. How to return single object 3. How to return multiple objects. 4. How to call the query method with parameter. In allContinue reading "WCF RIA Service Adding Query Methods"

Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure

In this walkthrough we will migrate an existing Database from SQL Server 2008 R2 to SQL Azure. Creating Database The first step is to create database. We are going to use School database. Script of sample School Database copy from here Generate Database Script for SQL Azure Right click on School Database and select Tasks.Continue reading "Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure"

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 fromContinue reading "Remote and Local execution of Query in LINQ"

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,Continue reading "Using Stored Procedure in LINQ"