Browse by Tags

All Tags » linq » .net (RSS)

Simple way to cache objects and collections for greater performance and scalability

Caching of frequently used data greatly increases the scalability of your application since you can avoid repeated queries on database, file system or to webservices. When objects are cached, it can be retrieved from the cache which is lot faster and...
Posted by omar | 11 comment(s)
Filed under: , ,

Web 2.0 AJAX Portal using jQuery, ASP.NET 3.5, Silverlight, Linq to SQL, WF and Unity

Dropthings – my open source Web 2.0 Ajax Portal has gone through a technology overhauling. Previously it was built using ASP.NET AJAX, a little bit of Workflow Foundation and Linq to SQL. Now Dropthings boasts full jQuery front-end combined with ASP.NET...

Memory Leak with delegates and workflow foundation

Recently after Load Testing my open source project Dropthings , I encountered a lot of memory leak. I found lots of Workflow Instances and Linq Entities were left in memory and never collected. After profiling the web application using .NET Memory Profiler...
Posted by omar | 1 comment(s)
Filed under: , , ,

Linq to SQL solve Transaction deadlock and Query timeout problem using uncommitted reads

When your database tables start accumulating thousands of rows and many users start working on the same table concurrently, SELECT queries on the tables start producing lock contentions and transaction deadlocks. This is a common problem in any high volume...
Posted by omar | 14 comment(s)

Linq to SQL: Delete an entity using Primary Key only

Linq to Sql does not come with a function like .Delete(ID) which allows you to delete an entity using it’s primary key. You have to first get the object that you want to delete and then call .DeleteOnSubmit(obj) to queue it for delete. Then you...
Posted by omar | 19 comment(s)
Filed under: , ,

Solving common problems with Compiled Queries in Linq to Sql for high demand ASP.NET websites

If you are using Linq to SQL, instead of writing regular Linq Queries, you should be using Compiled Queries . if you are building an ASP.NET web application that’s going to get thousands of hits per hour, the execution overhead of Linq queries is...
Posted by omar | 16 comment(s)
Filed under: , ,

My first book - Building a Web 2.0 Portal with ASP.NET 3.5

My first book " Building a Web 2.0 Portal with ASP.NET 3.5 " from O'Reilly is published and available in the stores. This book explains in detail the architecture design, development, test, deployment, performance and scalability challenges...

Linq to SQL: How to Attach object to a different data context

After upgrading to Visual Studio 2008 RTM, you will have trouble updating Linq to SQL Classes which are read from one data context and then updated into another data context. You will get this exception during update: System.NotSupportedException: An...
Posted by omar | 16 comment(s)
Filed under: ,