ASP.NET Articles (487) - Page 23

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 focus on how we can convert simple existing .NET classes in to LINQ enabled classes.

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 and finally we will end this article by discussing two important error reporting options when concurrency conflict happens.

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 sure you will never like to touch DBML code generator again.

LINQ FAQ Part II 

This FAQ article is dedicated to LINQ to SQL. In this article we will see a basic example of LINQ to SQL, how to define 1-1 and 1-many relationship using LINQ, how we can optimize LINQ queries, execution of stored procedures using LINQ and finally we will see a simple CRUD example using LINQ to SQL. For past some days I was running small sprint to complete this marathon I hope you will like this article.

CRUD operations using LINQ Entities 

This is a pretty simple tutorial dedicated to LINQ newbie’s who want to learn how to do CRUD operations using LINQ entities. I am sure many experienced LINQ players would criticize me for such a mild article. One of the biggest catch which I found is the in-memory update service by LINQ, which I think for any newbie for LINQ is a must to understand.

Simple 6 steps to use stored procedure in LINQ 

This is an extremely small article which describes how to flourish LINQ objects using stored procedure. What provoked me to write this article is the ‘ExecuteMethodCall’ function which helps to execute stored procedures in LINQ. As this is a protected function it changes the way you architect the DAL using ‘DataContext’ class and probably you would like to tweak and consider some options here. You can see more details of it when you read through the steps below. I am writing a huge series of LINQ FAQ and these small articles form small sprints to complete the huge FAQ series. I hope you enjoy it.

Custom SEO friendly paging with ASP.NET Repeater or DataList control 

This article shows how to achieve Custom SEO Friendly paging for controls like Repeater or DataList those doesn't support paging out of box.

Optimizing LINQ Queries using DataLoadOptions 

In this section we will understand the round trip issues of LINQ and how we can overcome the same using ‘DataLoadOptions’. One of the biggest issues with LINQ to SQL is that it fires SQL query for every object which has a huge impact on performance. In this article we will see how we can get all data in one SQL Query.

Ensuring button is clicked only once, Confirmation and Please wait message for ASP.NET Form 

This article explains how to ensure that submit button is clicked only once, get confirmation from user before submitting the form and display "Please wait" message when the ASP.NET web form is submitted to the server. The sample demo also works well when you have many asp.net validation control in your form.

How to get a Selected Row Data from a DataList ? 

In this Article you can learn how to get a Selected Row Data from a DataList and display the data in textBoxes.

One-Many and One-One relationship using LINQ to SQL 

In this article we will start with a basic LINQ to SQL example and then see how we can implement one-many and one-one relationship using ‘Entityref’ and ‘EntitySet’. We have also attached a source which demonstrates the same in a practical manner.

How to get the Values of Selected Row from a Gridview using ASP.NET 

In this Article you can learn how to get the values of selected row from a Gridview and display the values in textBoxes using C# code.

Extending Grid View Control of ASP .NET 

If you want to modify some functionality of existing Grid View control of ASP .Net then you always have the option of extending the control. In this article I have extend the Grid View with custom field. To extend the Grid View control you can inherit the new class from existing class or any of the following class 1). DataControlField – The base class for bind field 2). ButtonFieldBase – The base class for all button field and command field. In this article I am extending the Grid View control of ASP .Net with LongTextField and ConfirmDeleteButton (it will be in my next blog)

Setting up Start Options in Visual Studio and Visual Web Developer 

While working with Visual Studio or Visual Web Developer, we usually come across setting start up options, this article focuses on each of the start up options and explains their uses.

Website vs Web Application - Embedded resources 

In this small article, I am going to show the use of Build Action and Copy to Output Directory property of a file inside the class library and how it behaves differently in Web Site and Web Application projects.