-
Wednesday, April 30, 2008
Like a lot of web programmers, I spent years using PHP to create web applications. One of the tools I frequently used in conjunction with PHP was phpMyAdmin . This helpful web-based tool allowed me to easily manage my MySQL databases via a web browser. After reading Scott Guthrie's "Binding UI using the ASP:LinqDataSource Control" article I became intrigued by the idea of building a phpMyAdmin-like inteface that could utlize any "LINQ to SQL Class". In theory this seemed simple, in practice it involved a lot reflection . I ...
Full story
-
Tuesday, April 22, 2008
I've often found it helpful to use ASP.NET's Page Trace to identify performance problems with my dynamic pages. However, database queries are frequently responsible for performance problems. Because of this, I began displaying SQL via the Page Trace. This let me see the SQL being executed to render a page. It also let me see how much time the SQL was taking to execute. As I began toying with LINQ to SQL I found myself missing the ability to see the SQL being executed to render my pages. As it turns out, it's very easy to ...
Full story