Executing A Stored Procedure From Excel Sheet

How to execute a stored procedure from Excel Sheet? Introduction Reports are one of the key requirements for management from any application whether it is a web application or Windows and they are interested to see it in Excel sheet. So, how about connecting an Excel sheet to a stored procedure and executing it directly […]

Read more

LINQ Query examples using method and Query syntax

I am sure you are gonna bookmark this for future references Introduction Basically, you can write LINQ queries using method syntax (sometimes called as Lambda Expressions) and query syntax. So, here I have tried to gather 36 T-SQL queries along with their equivalent LINQ queries in both method and query syntax. Scenario Let us consider […]

Read more