How to Use 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 going to consume too much CPU and make your site slow. There’s [...]

  • Share/Bookmark

Read Users' Comments (0)

How to Debug LINQ Queries

Debugging LINQ queries can be problematic.  One of the reasons is that quite often, you write a large query as a single expression, and you can’t set a breakpoint mid-expression.  Writing large queries in expression context is particularly powerful when using functional construction to form XML (or using the strongly typed DOM in Open XML [...]

  • Share/Bookmark

Read Users' Comments (0)

Using LINQ to Query Excel Tables

Excel has a very cool feature where you can declare that a range of cells is a table.  It is a feature that allows you to use Excel very much like a database.  You can add new rows as necessary, sort the table by columns, do some simple filtering, calculate the sum of columns, and [...]

  • Share/Bookmark

Read Users' Comments (0)