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 moreContinueContinue 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 allContinueContinue 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.ContinueContinue reading “Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure”

walk through WCF RIA Service

It may be bit late but let us learn WCF RIA together. I will be writing many parts on Learning WCF RIA Services. Part1 In this part just to get a feeling of WCF RIA and see our one application is running on WCF RIA, I am going to walkthrough creating first application through WCFContinueContinue reading “walk through WCF RIA Service”

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 fromContinueContinue 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,ContinueContinue reading “Using Stored Procedure in LINQ”