Joins in LINQ to SQL

The following post shows how to write different types of joins in LINQ to SQL. I am using the Northwind database and LINQ to SQL for these examples. 1: NorthwindDataContext dataContext = new NorthwindDataContext(); INNER JOIN : 1: var q1 = from c in dataContext.Customers 2: join o in dataContext.Orders on c.CustomerID equals o.CustomerID 3: [...]

Read Full Post »

What’s New in ASP.NET 4.0 – Better ViewState Control

This article is Part II of the multi-part series covering new features on ASP.NET 4.0. In ASP.NET 2.0/3.5, you could disable ViewState for individual controls. However what you could not do is disable ViewState at a Page level and then enable it individually for controls on that page that require it. ASP.NET 4.0 changes that [...]

Read Full Post »

What’s New in ASP.NET 4.0

With the ASP.NET 4.0 release round the corner, I thought of starting an article series that covers the new features introduced in ASP.NET 4.0, one at a time. This article is Part I of this multi-part series. In this article we will learn 2 new properties added to Pages Class. Metkeywords. MetaDescription. The MetaDescription is [...]

Read Full Post »

Cookies and jQuery

To use cookies with jQuery, you will need the special Cookie plugin. Setting cookies : Setting cookies with the Cookie plug-in is quite intuitive: 1: $(document).ready(function(){ 2:  3: // Setting a kittens cookie, it will be lost on browser restart: 4: $.cookie("kittens","Seven Kittens"); 5:  6: // Setting demoCookie (as seen in the demonstration): 7: $.cookie("demoCookie",text,{expires: [...]

Read Full Post »

PageMethods In ASP.NET AJAX

Page Methods is a new mechanism in ASP.Net application where the server code cab be bound to Asp.Net pages.  It is an easy way to communicate asynchronously with the server using Asp.Net Ajax technologies. It’s an alternate way to call the page which is reliable and low risk.  In a nutshell, it is used to [...]

Read Full Post »

Value Type Vs Reference Type

Value Type : When a value-type instance is created, a single space in memory is allocated to store the value. Primitive types such as integer, float, Boolean and char are also value types. Structure are value types. Memory Allocation : Value type local variable stored in Stack. C# parameters are (by default) passed by value. [...]

Read Full Post »

Page life Cycle

PreInit: All the Pre and Post events are introduced as part of .NET Framework 2.0. As the name suggests, this event is fired before the Init method is fired. Most common functionalities implemented in this method include: Check the IsPostBack property Set the master page dynamically Set the theme property of the page dynamically Read [...]

Read Full Post »

Evaluation of .NET Framework

Read Full Post »

View Vs. Stored Procedure

Differences : View does not accepts parameters while SP takes parameters. View contain only one single query while SP contain several statements like conditional , loop etc. Can not perform modification in any table (DDL Statement) while SP can do this. View is nothing but an imaginary table. It contains data at run time only [...]

Read Full Post »

Trigger Vs. Stored Procedure

Differences: Actually trigger in action which is performed automatically before or after a event occur and stored procedure is a procedure which is executed when the it is called. Stored procedure is module. SP can pass the parameters which is not a case with Triggers. While creating a Trigger triggering event and action has to [...]

Read Full Post »