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 a
runtime cost associated [...]
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 SDK V2). This post presents [...]
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 [...]
Read Users' Comments (0)