I was recently working on a project where there was an option to export data from the database.  The export function simply exported 2 hard-coded columns that were returned by a stored procedure into a tab-delimited text file. 
The sproc looked something like select id, name from mytable (I am over simplifying of course).  I […]

Posted in LINQ, Programming 3 Comments »
Tags: dynamic linq, LINQ, reflection, SQL

I have just spent the entire day playing with Moq to unit test an asp.net mvc application I am working with. All I wanted to do is test a “create” method that simply adds a record to the database. So here it goes.
1. I created a Mock Http context to be used by my controller. […]

Posted in .net, LINQ, Testing, asp.net, asp.net mvc 3 Comments »
Tags: asp.net, LINQ, mocking, moq, mvc, Testing, unit testing

I was writing a small utility for Outlook 2007 and was using LINQ to query Outlook Tasks.  This query was nested within another query.  While debugging, I realized that looping though the query results in my For Each loop was taking too long.
If you have read anything about LINQ, I am sure you already know […]

Posted in .net, LINQ, Office, Performance, Tips & Tricks, vb.net 2 Comments »

I need your help to bring me fame and fortune.
I wrote an article at code project which was entered for a competition.  The winner gets $10k.  Can you please check it out at http://www.codeproject.com/KB/WCF/myfeedreader.aspx and if you like it, please vote for it.  I can’t win if you don’t vote.  Voting will be closed on […]

Posted in .net, AJAX, LINQ, Programming, Tips & Tricks, Visual Studio, Web Dev, vb.net No Comments »

Here is the scenario, I have collection of books and I want to get a book with a specific ISBN.  In the old ways, you will probably have to create a custom collection and inherit a generic collection of books, then add a method to get by ISBN.
Thanks to LINQ and extension methods, you can […]

Posted in LINQ, Programming, vb.net 1 Comment »