How to Compare Two Databases, find differences and update using Visual Studio

In this article, we are going to learn how to compare two databases using SQL Server Database Project (Template) available in Visual Studio. I will cover the following points: Introduction of SQL Server Database Project. Connect two databases: source and target. Compare and identify differences among the two databases. Update or generate script to update the target database.  In the last article, we learned how … Continue reading How to Compare Two Databases, find differences and update using Visual Studio

Invalid option ‘7.3’ for /langversion; must be ISO-1, ISO-2, Default, Latest or a valid version in range 1 to 7.1.

This compiler error occurs sometime because of version change where dotnet compiler version and c# version are incompatible. Error: Compilation ErrorDescription: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.            Compiler Error Message: CS1617: Invalid option ‘6’ for /langversion; must be ISO-1, ISO-2, 3, 4, 5 or Default Compiler Error … Continue reading Invalid option ‘7.3’ for /langversion; must be ISO-1, ISO-2, Default, Latest or a valid version in range 1 to 7.1.

Failed to register URL “http://localhost:XXXX/” for site “..” application “/”. Error description: The process cannot access the file because it is being used by another process. (0x80070020)

Error: Failed to register URL “http://localhost:XXXX/” for site “SITE NAME” application “/”. Error description: The process cannot access the file because it is being used by another process. (0x80070020) **XXXX = port number Reason for this error: This error happens to me because I was using same solution for different project. I copied the solution and created another one in different location. I have done … Continue reading Failed to register URL “http://localhost:XXXX/” for site “..” application “/”. Error description: The process cannot access the file because it is being used by another process. (0x80070020)

Create SQL Server Database Project With Visual Studio. Create or compare two Databases.

Here, we are going to learn about SQL Server Database Project (Template) available in Visual Studio. I will cover following points: Introduction of SQL Server Database Project. Create New SQL Server Database Project. Import database schema from an existing database, a .sql script file or a Data-tier application (.dacpac) the Project. Publish to create new Database in SQL server. Compare Two Database and find differences. … Continue reading Create SQL Server Database Project With Visual Studio. Create or compare two Databases.

How to Create SQL Server Database Project With Visual Studio

In this article, we are going to learn about SQL Server Database Project (Template) available in Visual Studio. I will cover the following points, Introduction of SQL Server Database Project. Create New SQL Server Database Project. Import database schema from an existing database, a .sql script file or a Data-tier application (.bacpac) the Project. Publish to create new Database in SQL server. The database plays … Continue reading How to Create SQL Server Database Project With Visual Studio

Build Your Own Cortana Skill

Building a Cortana skill means that Cortana can use your bots, services, websites, and apps to help people – but did you know that you can write the whole skill with C# and .NET? During this session, we’ll learn about Cortana and the Skills Kit, build a skill step-by-step, and discuss how you can work with Cortana to build personalized, intelligent experiences for your users. … Continue reading Build Your Own Cortana Skill

What’s New in Visual Studio 2017

Visual Studio is a productivity game changer for C#! The .NET Compiler Platform (“Roslyn”) enables many new experiences that will change the way you write and debug code. In this session, we’ll dig into features that bring a new level of awesome to the C# language and IDE experience. Come learn about new language features, refactoring support, major debugging enhancements, code-aware frameworks, and much more! … Continue reading What’s New in Visual Studio 2017