LINQ FAQ Part 3

This is the third series in my LINQ FAQ series. In this series we will cover LINQ FAQ’s related to concurrency handling, compiled queries, CRUD implementation and mapping simple .NET classes with XML file configuration. I love to write articles in FAQ format for the only purpose that they are to the point and you [...]

SQL Server SUBSTRING – Explained

We have used SUBSTRING in many ways/scenarios. This article explains how it works.
Read more at http://www.dotnetfunda.com/articles/article476-sql-server-substring–explained.aspx
Author: Pandians

Migration strategy for simple .NET classes to LINQ classes

When new technologies are introduced one of the biggest business challenges faces is migrating the current projects to new technologies with least effort. I am sure scratch development is not always a preferred option from business investment point of view. One of the new technologies which is talked most is ‘LINQ’. This article will [...]

Data Concatenation – SQL Server

In this article, I shall show how to concatenate data from COLUMN1 by grouping against COLUMN2 without looping CURSOR.
Read more at http://www.dotnetfunda.com/articles/article474-data-concatenation–sql-server.aspx
Author: Pandians

SQL Server SUBSTRING – Explained

We have used SUBSTRING in many ways/scenarios. This article explains how it works.
Read more at http://www.dotnetfunda.com/articles/article476-sql-server-substring–explained.aspx
Author: Pandians

Data Concatenation – SQL Server

I want to concatenate data from COLUMN1 by grouping against COLUMN2 without looping CURSOR.
Read more at http://www.dotnetfunda.com/articles/article474-data-concatenation–sql-server.aspx
Author: Pandians

How to handle concurrency in LINQ to SQL?

In this article we will touch base some important concepts of handling concurrency in LINQ to SQL. We will first see how LINQ supports optimistic concurrency and then we will see what support LINQ provides to handle concurrency violation. We will then touch base on some fine tuning features provided by LINQ at field level [...]

jQuery and ASP.NET AJAX UpdatePanel

This article describes the solution of the problem in which jQuery doesn’t work for elements placed under ASP.NET AJAX UpdatePanel when partial postback is done.
Read more at http://www.dotnetfunda.com/articles/article471-jquery-and-aspnet-ajax-updatepanel.aspx
Author: SheoNarayan

Passing data between layers using Generic list collection

This simple article describes how to pass data between different layers of your application using Generic list collections.
Read more at http://www.dotnetfunda.com/articles/article472-passing-data-between-layers-using-generic-list-collection.aspx
Author: SheoNarayan

How to improve your LINQ query performance by 5 X times ?

LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am [...]