Implementatin of query optimization tecniques in c#

Question

Hi,
I want to improve query optimization techniques for the database sqlserver 2005 or 2008
using C# language,
please give me sugession on this , send me any appropriate links u have about this concept or any coded project
Thanks in advance