I heartily want to learn about how to build (simple and complex) queries with and without lambda expression in c#.I searched a lot , but perhaps I am may be miss some links to check. can some body tell me where i can learn from basic of Linq ,its all functions, write the queries and all ? please guide me!
There is a very good book on this to get all the basics. The book is not to thick, and should be quick enough to go through, and perfect for a reference later on.
The book is called LINQ Pocket Reference
If you're looking for free LINQ references, check Jon Skeet's brilliant series Edulinq. He also has an ebook version of the series.
Also check these other links:
50 LINQ Examples, Tips and How To's
LINQ Secrets Revealed: Chaining and Debugging
Happy LINQin'! ;)