ASP.NET MVC Web App on 3-Tier for Beginners – Part 3

Introduction This article is the continuation of Part 1 & Part 2 . In the first article, we saw understanding of requirements and then breaking them into objects, then finding out the relationships among them and finally designing and implementing the database. And Good news is our first article won the best article of the Nov 2014 award. In second […]

Read more

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

ASP.NET MVC Web App on 3-Tier for Beginners – Part 2

Introduction This article is the continuation of Part 1. In the first article, we saw understanding of requirements and then breaking them into objects, then finding out the relationships among them and finally designing and implementing the database. Now, let us see how to create a solution, then add multiple projects to it and then add […]

Read more