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 […]
MTT's Blog
Technology Simplified.
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 […]
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 […]
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 […]
ASP.NET MVC Web App on 3-Tier for Beginners – Part 1
Objective The objective of this article series is to make the beginners understand how data moves from one layer to another layer in ASP.NET MVC web app when it is designed on 3-layers. Overview Q. Do you want to see a live web app built on 3-Tier arch using ASP.NET MVC, jQuery, Bootstrap, C#.NET, Entity […]
