Microsoft TechNet Guru Awards November 2015

New award



ASP.NET 5 – Create Web Application Step by Step


Using MVC, Entity Framework, ASP.NET Scaffolding you can create a web application that stores your information. This demo shows you how to create a ASP.NET 5 web application with MVC and Entity Framework 7.

STEP 1 – Create ASP.NET 5 Web Application

  • Open Visual Studio 2015 and create a new project of type ASP.NET 5 Web Application.
  • On this project I create a solution called Demo.

  • Press OK, and a new screen will appear, with several options of template to use on our project.
  • Select the option MVC.

After selection of our template, your first web application using ASP.NET 5 is created.


STEP 2 – Create Data Model

After we have our web application created, we need to ceate our data model.

For that, select the option Add New Item on solution and choose the option Class. Create the class like the one on the image above.


STEP 3 – Scaffolding

This could be made easily using the Scaffolding functionality.

On the solution on the top of controller folder, select the option Add New Scaffold Item.


On the new screen, select the option MVC6 Controller with views using entity framework.


Select the name of the controller, class model and data context class.

The new controllers and views associated, was created with sucess.


STEP 4 – Change Menu Layout

To test the two tables, we can add two new entries on the web application menu.


STEP 5 – Run Application

Press now the F5 button, to run the web application.

The new entities appear on the menu.

Press the option car to see our entiity in action

An message error will appear sayng that the entity doesn’t exists on internal database and that we need to create it using some commands on package manager console.

Execute the commands like on the image above na try again

An thats it! Now its working

Code –

Congratulations João Sousa, our new Microsoft MVP

DevScope's Blog


It is with great pleasure to announce that we have a new Microsoft Most Valuable Professional (MVP) among our team. The Microsoft MVP Award is an annual award that recognizes exceptional technology community leaders worldwide who actively share their knowledge, real world expertise, and will to help others.

“MVP have been an essential part of Microsoft and Microsoft culture for many years. They are more than fans; they are educators, advocates and above all, they are community leaders.”

Scott Guthrie, Executive Vice President, Microsoft Cloud and Enterprise Group

The road to João’s recognition included:


  • Code Gallery: Check all João’s contributions here


  • TechNet Gallery: Check all his contributions here


It takes two, or more…

This will be his first year in the MVP program and we are thrilled to have two…

View original post 240 more words


I got a message on LinkedIn from Patrick Smacchia, who is the CEO and Lead Developer of NDepend with an amazing offer. It’s a free professional license for NDepend. I tried the tool for a few weeks and found some interesting features in it that could save my time and improve my code quality.


NDepend  is a great tool  for measuring the quality of software development for a .Net projects. On a real project it can be useful for follow the metrics, violated rules… The possibility of editing the queries rules is a plus for this tool.


There is a trial version for 14 days, we can get it here and there is a Visual Studio Extension that can be find here

This tool will analyze the dll output from the project and at the end it allow to show different metrics, graphics, diagrams and rules. Here are what the analyze of NDepend can tell us:


  Application Metric: This section gives you an idea of the topology of your application.

  •   Assembly Metric: This section gives you an idea of the size of each assembly within your application in   terms of #IL instructions and others metrics.
  •   VisualNDepend View: This section illustrates the size of your assemblies, namespaces, types and methods in terms of #IL instructions. You can browse this view dynamically by clicking the Launch Visual NDepend on this Project icon in the NDepend.Project UI.
  •   Assembly AAbstractness vs. Instability: This section illustrate the AAbstractnessInstability principle explained in the assemblies metrics section.
  •   Assembly Dependencies: This section shows all dependencies between assemblies of your application in a table.
  •   Assembly Dependency Diagram: This section shows all dependencies between assemblies of your application in a diagram
  •   Assembly build order: This section gives you one of the possible build order for your assemblies. If a cycle exists in your assemblies dependencies graph, this section will report it.
  •   NDepend information and warnings: This sections gives you advices about your code:
    • It warns you when an assembly depends on a less stable assembly than itself.
    • It warns you when the visibility of a type or of a member is not optimal (in the context of the analysed application).
    • It warns you when a type or a member is not used (in the context of the analysed application).
  • CQLinq Queries and Rules: This section reports default CQLinq rules which have been violated. More about CQLinq here.
  • Type Metrics: This section recaps type metrics in a table. A link to the documentation is provided for each metric.


SQL Server Data Tools to Visual Studio 2013 – Database Reverse Engineering

SQL Server Data Tools to Visual Studio 2013 – Database Reverse Engineering – TechNet Articles – United States (English) – TechNet Wiki

Database Cycle Management is Hard.

Microsoft create SQL Server Data Tools to Visual Studio 2013, to  turn easier the development.

  • Single Tool to support developer’s needs.
  • Can build, debug, test, maintain, and refactor databases.
  • Developers can use familiar Visual Studio tools for database development.
    • Code navigation, IntelliSense, C# language, platform-specific validation,
      • debugging, and declarative editing in the Transact-SQL editor.
  • Works connected or disconnected (Tools work on top of design time)
  • Have Schema Model differencing capabilities (Compare and Update Model)
  • Schema and app under TFS control
  • Publish to all supported SQL platforms

Read more of this post

ASP.NET MVC5 – AngularJS, Create PDF file using Microsoft Report

ASP.NET MVC5 – AngularJS, Create PDF file using Microsoft Report – TechNet Articles – United States (English) – TechNet Wiki

This article walks you through the steps for create a report in Word or PDF format usinf Microsft Report without using Report Viewer.
Read more of this post

ASP.NET MVC – AngularJS, Web API and EntityFramework to build SPA

ASP.NET MVC – AngularJS, Web API and EntityFramework to build SPA – TechNet Articles – United States (English) – TechNet Wiki

This article walks you through the steps for create a web application using AngularJS, that uses WebApi to communicate between client and server side.

Read more of this post