Unable to open dtproj projects in Visual Studio 2017

Problem
I was trying to open a sln file which contains “.dtproj”. Unfortunately the project is marked as incompatible and the migration report displayed as below.

Solution

• Install the latest version of SSDT
• Open Visual Studio 2017: Go to: Tools > Extensions And Updates > Search: Microsoft Integration Services Projects > Click: Enable

• Restart Visual Studio
• In SSIS Project On Solution: Right Click > Reload Project

Visual Studio 2017 Hangs on Startup

Introduction
My Microsoft Visual Studio Community 2017 was hanging on startup. 

Solution

I reset the user data and it worked fine. 

Step 01.
Open "Developer Command Prompt for VS 2017"

Step 02.
Navigate to the following location 
C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE
By typing 
cd "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE"

Step 03.

Run the below command

devenv.exe /ResetUserData

Cannot add .Net Standard 2.0 Class as .Net Type in Workflow Foundation Activity Designer projects in Visual Studio 2017

Introduction

I was working on Workflow Foundation 4.5 using Activity Designer Library template in Visual Studio 2017.

Problem Background

When I try to add a class library as input Type through Type Browser in Activity designer it shows an error as “The selected type could not be created” as shown in the image below.

I compared another machine with the latest update of Visual Studio which was working fine. The problem seems to be I didn’t have .Net framework 4.6.2 SDK and .Net framework 4.7 SDK installed.

Solution

I modified the Visual Studio as below using Visual Studio Installer.

Conclusion

You will can refer .Net Standard 2.0 projects and dlls in workflow foundation project templates and use without any issue.

Get the visual view of the model in Entity Framework Code First

Introduction

In this post we will discuss how to generate visual view from the models in Entity Framework Code First.

I’m using Visual Studio  2017 as the tool and Entity Framework version 6.

Solution Structure

I have two projects in the solutions.

1. BlogSample.BO
   In this project we will have all the Business Objects.
2. BlogSample.DAL
   This is  the data access layer and we have installed Entity Framework 6 and created DbContex and the Dataset. Also the BlogSample.BO project has been referenced as well.

Step 1

Install Entity Framework 6 Power Tools Community Edition

In Visual Studio go to Tools –> Extensions and Updates.

Search for Entity Framework 6 Power Tools and install the extension.

See the image below. I have already installed.

Step 2

Make DAL project as Startup project. Right click on the Context.cs file and go to Entity Framework –> View Entity Data Model.

Your .edmx visual diagram will be generated as below. 

Solution

The solution is available in the below url.

https://drive.google.com/file/d/0ByEnOE8DAdvhYXhCTU5nVEdBR3M/view?usp=sharing

Develop SharePoint Framework projects in Visual Studio 2015/2017

Introduction

You will come across so many tutorials on SharePoint Framework (SPFx) which were illustrated using “Visual Studio Code”. But don’t worry you can develop SPFx projects using Visual Studio.

Recently “SPFx Project Template for Visual Studio” was released in GitHub. In this post we are going to see how to install “SPFX Template” and create a new SPFx project after installing the extension.

As of today the extension supports Visual Studio 2015 and Visual Studio 2017.

Steps

Step 01

Go to GitHub Releases page and download the latest .vsix file. Reason for downloading from GitHub is that you may not find the latest in Visual Studio Extension Gallery.

Step 02

Double click on the download template and install.

Select the Products and click install.

Step 03

Open Visual Studio and add New Project (File –> New –> Project)

Under Templates you will see “SharePoint Framework”. Select it and click OK

Step 04

Then you have to Select a framework which you are going to use; Give Component Name and Component Description.

Also you can select the check box if you don’t want to install Dependencies. Usually installing dependencies make our life easier, So keep it as it is.

Click on Generate.

Conclusion

It took me around 15 minutes to create a new project. So keep calm when you are trying to create a new project.

Your solution will be looking as below and you can start working on the solution.

Run the project by clicking “Start” and your first Workbench project will be opened in the browser.

By clicking on + You can add SPFx webpart.