• sql

    Tracing all SQL generated by Entity Framework

    by  • March 3, 2013 • .net, sql • 1 Comment

    A nice quick one this week. I spent a little bit of time trying to debug some Entity Framework queries, particularly the parameter values used in a SQL INSERT composed when calling AddObject/SaveChanges. There are a few ways to determine the underlying SQL. If you are only interested in LINQ queries, using ToTraceString() on ObjectQuery […]

    Read more →

    Effective server side paging in SQL Server 2000

    by  • July 14, 2008 • asp.net, c#, sql • 2 Comments

    Recently a client asked me to implement paging on the administrators side of a CV/online application submission system. This essentially lists all the current applications in the system and other data (time of submission, personal details etc). The system has been well received and little thought was paid when developing it in order to scale […]

    Read more →