ObjectTrackingEnabled – LINQ

You may come across a requirement, where you will retrieve data only for reading. LINQ monitors the changes, which as you might have guessed is the not the best solution everywhere, especially in the above scenario.

Here is a quick tip to increase the performance by disabling object tracking in LINQ using the ObjectTrackingEnabled property. This will turn off the unnecessary identity management of the objects.

using (NorthwindDataContext dbContext = new NorthwindDataContext())
{
	dbContext.ObjectTrackingEnabled = false;
}

c#, linq

Print article

Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site.

Related Posts
Comments (0)

No comments yet.

No trackbacks yet.

NOLOCK in LINQ

about 4 months ago - No comments

The NOLOCK table hint, also known as READUNCOMITTED, is applicable to SELECT statements only. NOLOCK indicates that no shared locks are issued against the table that would prohibit other transactions from modifying the data in the table. The most recommended way of implementing NOLOCK is to use a TransactionScope to affect the TransactionOptions associated with

Random Row – Linq to SQL

about 5 months ago - No comments

You can retrieve a random data record from an SQL database through LINQ using a User Defined Function. We can implement the above in a partial class for the target context. partial class MyTargetContext { [Function(Name="NEWID", IsComposable=true)] public Guid Random() { throw new NotImplementedException(); } } In the above example which returns a uniqe identifier

vCalendar – C# Implementation

about 1 year ago - No comments

I needed to integrate support for vCalendar in my current project. So i went through the vCalendar spec 1.0 at http://www.imc.org/pdi/vcal-10.txt and wrote this class. Although I have not implemented all the specification features, but this should prove sufficient for the usual requirements. If you have any comments / suggestions , let me know. using

An anonymous type cannot have multiple properties with the same name

about 1 year ago - No comments

If you are using LINQ and have a query that looks something like this : var myUser = (from user in dbContext.Users join comp in dbContext.Companies on user.CompanyID equals comp.CompanyID where user.UserID == “12345″ select new {user.UserID, user.Name, comp.Name}).SingleOrDefault(); string _userID = myUser.UserID; string _userName = myUser.Name; string _companyName = myUser.Name; In the above code,

Asp.Net Read Reciept Request

about 1 year ago - No comments

Here’s a quick tip. If you need to include a request for read receipt like Microsoft Outlook while sending mails through Asp.net, just add the Disposition-Notification-To Header to the MailMessage. The MailMessage class does not have a corresponding attribute and thus it has to be set through the Header. MailMessage mm = new MailMessage(fromAddress, toAddress);

Generic Handler – Session State

about 1 year ago - No comments

In my current project I needed to access the Session state in a Generic Handler. To my dismay, i realized that the Session StateBag was null. The StateBag class is sealed and manages the Viewstate of the Asp.net server controls and pages. Upon discussion with my colleague, Mr. Hamed, we found the solution to my

Encypting query string in Asp.Net

about 2 years ago - No comments

When you pass information from one page to another, you are passing information that anybody can sniff. For example consider a scenario, in which you pass the customer id as a query string: http://www.yourapplication.com?customer_id=15 Now if somebody replaced 15 with say 10 or any other number, they can pull up other customer information. And that’s

Asp.Net Reset Password

about 2 years ago - No comments

If you are using Membership Provider in your ASP.net application, you might come across a scenario in which you need to have both Security Question and Answer feature and would also like to pro-grammatically reset the password for an account. So if you run the code string username = “user”; string password = “password”; MembershipUser

Tags

asp.net c# css freebie google javascript jQuery linq mysql open source php sql tools visual studio wordpress
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
My Tweeets

Loading tweets...

Follow me on Twitter!
User Login

User

Password

Remember me
- Lost your password?
Accounts

ObjectTrackingEnabled – LINQ

No comments yet.

No trackbacks yet.

Tags

My Tweeets

User Login

Accounts