Merry Christmas to all my readers

This is not a usual technical post I am writing here. I just wanted to take a moment and wishing you Merry Christmas and happy holidays. All readers are has been great support to this blog and on this occasion I want thank you guys for all the support and love you have shown during this year 2012. I have achieved so much through this blog and its been not possible without your support.

I wish that year 2013 will bring you all joy and happiness you required. May all your wishes fulfil.



Stay tuned for more. I have lots of stuff for you in 2013. Till then happy holidays!! and once Merry Christmas to you and your family.

Continue Reading

Where I can find SQL generated by Linq-To-SQL

Yesterday I have written a blog post about Where I can find SQL Generated by Entity Framework? and same day I got request from one of the our reader Ramesh that how I can find SQL generated by Linq-To-SQL?. I thought its a good idea to write a blog post to share amongst all who need this instead of reply in comments.  In this post I am going to explain how we can get SQL generated by Linq-To-SQL.

For this post I am going to use same table like following. A customer table with two columns CustomerId and CustomerName.

Continue Reading

Where I can find SQL Generated by Entity framework?

Few days back I was optimizing the performance with Entity framework and Linq queries and I was using LinqPad and looking SQL generated by the Linq or entity framework queries. After some point of time I got the same question in mind that how I can find the SQL Statement generated by Entity framework?

After some struggling I have managed to found the way of finding SQL Statement so I thought it would be a great idea to write a post about  same and share my knowledge about that. So in this post I will explain how to find SQL statements generated Entity framework queries.

To demonstrate the idea Let’s a very simple console application with C# and then  create a table called ‘Customer’ with CustomerId and CustomerName field in sql server.

Continue Reading