[Hello, we are looking to improve your experience on the Visual Studio Blog. It will be very helpful if you could share your feedback via this short survey that should take less than 2 minutes to fill out. Thanks!]
Cloud services represent a huge leap in functionality, performance, and management simplicity for web apps, APIs, mobile backends, and more. To help you get started with cloud-based development in Visual Studio for Mac, today we’re publishing two new hands-on labs: publishing your ASP.NET Core web app to Azure, and connecting your ASP.NET Core web app to Azure SQL Database.
How to Run Visual Studio on a Mac Visual Studio doesn’t run natively on OS X, so my first step was to get Windows running on my MacBook Pro. (If you want an editor that does run natively, Xamarin Studio or Visual Studio Code might fit the bill).
- Visual Studio for Mac enables the creation of.NET Core solutions, providing the back-end services to your client solutions. Code, debug, and test these cloud services simultaneously with your client solutions for increased productivity.
- Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. The SourceSafe database is a multi-user, multi-process file-system database, using the Windows file system database primitives to provide locking and sharing support. It is possible to run CIL programs in Linux or Mac OS X using non-Microsoft.NET.
- September 29, 2017 Tools code, data, mac, sql, sqlserver, visual studio, Visual Studio Code, vscode, windows Julie Lerman My latest course on Pluralsight, Cross-platform SQL Server Management for Developers using VS Code, went live earlier this month (just as I was about to hop on a plane for 2 weeks of conference travel!).
- I'm creating a hotel management service in C# on Visual Studio (Mac) and I can't seem to find a good explanation on how to add a local database file to my project.
- Visual studio for mac Database Alan Albrecht reported Feb 22 at 04:57 AM I am attempting to connect a.NET ASP MVC project to a database and am unable to find detailed documentation on how to do this and where to put the connection string, as well as how to connect in the code.
These two labs will help develop cloud-ready ASP.NET web apps and APIs with Visual Studio for Mac, using an Azure hosted SQL database, and then publish the web app itself to Azure. What’s more, you can try Azure out for free!
Lab 7: Publishing ASP.NET Core websites to Azure
This lab builds on the earlier Getting Started with ASP.NET Core lab, by showing you how to publish the website to Azure using Visual Studio for Mac in just a few steps:
- Creating an Azure account
- Creating an ASP.NET Core website
- Publishing to Azure
- Managing your website in Azure
To complete the lab, follow these instructions which will guide you through the process.
Lab 8: Using Azure SQL Database in ASP.NET Core web apps
Every website needs a database. It is easy to set up an Azure SQL database to connect and develop locally on Visual Studio for Mac and migrate it to a production instance later. This lab will walk you through getting your first cloud database and ASP.NET Core web app up and running:
- Creating an Azure SQL Database
- Setting up the ASP.NET Core app
- Configuring the SQL Azure Database
- Connecting the ASP.NET Core website to Azure SQL
These step-by-step instructions will show you how to set up and connect to the Azure database from ASP.NET Core. The same steps will work for ASP.NET Core web API projects, which you can use as a mobile app back-end.
Visual Studio for Mac, version 7.3
On December 4, we released Visual Studio for Mac, version 7.3, bringing an even better Visual Studio for Mac to you as a free update. This release brings performance and stability enhancements, as well as new features. Visual Studio Test Platform (VSTest) now provides more flexibility in choosing your test frameworks and automatic iOS app signing, reducing the number of manual steps needed to build your app. Check out the full blog post for more details and be sure to download or update to Visual Studio for Mac, version 7.3 today!
Get Started
Download Visual Studio for Mac today, and visit the VS4Mac labs repo on GitHub to check out the new Azure hands-on labs, as well as the previous ones that help you get started building apps, games, and services for Xamarin mobile, web, and cloud.
Check out the docs for more in-depth information on Visual Studio for Mac features, and let us know what you think of the labs and Visual Studio for Mac in the comments below.
| Craig Dunn, Principal Program Manager @conceptdevCraig works on the Mobile Developer Tools documentation team, where he enjoys writing cross-platform code for iOS, Android, Mac, and Windows platforms with Visual Studio and Xamarin. |
Code faster. Work smarter. Create the future with the best-in-class IDE.
Write code with fewer errors
Type variables quickly and accurately, using IntelliSense code suggestions if you get stuck. Maintain speed no matter the complexity as you navigate to any file, type, member, or symbol declaration you need. Make quick improvements to your code using light bulbs that suggest actions such as renaming a function or adding a parameter.
Learn more about your code
CodeLens helps you easily find important insight such as what changes have been made to your code, the impact of those changes, and whether your method has been unit tested. See references, authors, tests, commit history, and other essential information at a glance.
Quickly find and fix your bugs
Visual Studio lets you pause code execution the moment you want to inspect a bug, using the breakpoint and method you need. If you’ve taken one step too far or encountered an unexpected change, you can step back to any specific line of code–no need to restart your session or recreate your state.
Work efficiently
Easily navigate and organize your test suite so you can analyze how much code you’re testing and see results instantly. Immediately know the impact of every change you make, letting advanced features test code as you type. Fix errors as soon as they happen and see if new changes are covered by existing tests.
Share more than screens
Lead your team with quick and natural collaboration using Live Share to edit and debug together in real time, no matter the language or platform. Personalize your session with access controls and custom editor settings that enforce consistent coding styles for everyone.
Build for the cloud
Get up and running quickly using templates for common application types and local Azure emulators–no need for an Azure account. You can also provision application dependencies such as Azure SQL databases and Azure Storage accounts without leaving Visual Studio. Quickly diagnose any issues using Visual Studio’s remote debugger, which attaches directly to your application.
Install only the tool and component bundles you need for development in Visual Studio
ASP.NET & web development
Build web applications using ASP.NET Core, ASP.NET (.NET Framework), HTML/JavaScript, and Containers including Docker support
Description
Maximize your productivity developing .NET web applications using ASP.NET Core, standards-based technologies like HTML, and JavaScript.
Development applications
– Website using Razor Pages in ASP.NET Core
– Web API with ASP.NET Core MVC
– Real-time web apps with ASP.NET Core SignalR
Components
– .NET Framework 4.x development tools
– .NET Core 2.1 development tools
– ASP.NET and web development tools
– .NET profiling tools
– Container development tools
– Cloud tools for web development
– IntelliSense, code navigation, and refactoring for C#, Visual Basic, and F#
Azure
Azure SDKs, tools, and projects for developing cloud apps, creating resources, and building Containers including Docker support
Description
Easily build, test, deploy, and manage scalable apps and services on the Microsoft cloud. Install to view resources in Cloud Explorer, create resources using Azure Manage tools, build applications for Azure Web and Cloud Services, and perform big data operations using Azure Datalake tools.
Development applications
– Publish an ASP.NET Core app to Azure in the IDE
– Test performance of a cloud service
– Debug a published Azure cloud service
Components
– Azure development prerequisites
– .NET Framework 4.x development tools
– .NET Core 2.1 development tools
– ASP.NET and web development tools
– Container development tools
Python
Editing, debugging, interactive development, and source control for Python
Description
Support for building Python web applications using familiar frameworks including Django and Flask, and Data Science applications with built-in Conda and IPython support.
Development applications
– Python applications
– Django web apps
– Flask web apps
Components
– Support for CPython, virtualenv, venv, and conda environments
– Rich editing, IntelliSense, and code comprehension
– Interactive (REPL) environment window
– Support for Python in open folder workspaces
– Project and item templates to simplify new project creating process
– Profiling and unit testing tools
– Manage Conda environments using Miniconda
– Live Share
Node.js development
Build fast and scalable applications using Node.js, a server-side JavaScript runtime environment
Description
Easily build Node.js applications using web frameworks like Express and front-end frameworks like React.
Development applications
– Node.js app with Express
– Node.js app with React
– Publish Node.js app to Azure cloud
Components
– Project templates
– IntelliCode
– npm integration
– Interactive (REPL) environment window
– Local and remote advanced debugging
– Profiling tools to track performance
– Unit testing support
– TypeScript integration
.NET desktop development
Build WPF, Windows Forms, and console applications using C#, Visual Basic, and F#
Description
Create Windows-based applications by using Windows Presentation Foundation or by using Windows Forms. Also create web applications using the .NET Framework, and client applications for computers or devices that you make available through the Microsoft Store.
Development applications
– Windows Presentation Foundation (WPF)
– Windows Forms
Components
– .NET desktop development tools
– .NET Framework 4.x development tools
– .NET profiling tools
– C# and Visual Basic language support
– Entity Framework 6 tools
– IntelliTrace
– Just-In-Time debugger
– Live Unit Testing
– Live Share
Desktop development with C++
Build modern C++ apps for Windows using the tools of your choice, including MSVC, Clang, CMake, or MS Build
Description
C++ desktop apps run in a console or in a window. Take advantage of the powerful MSVC compiler and libraries toolset or bring your own build tools to do the job.
Development applications
– Traditional Windows Desktop applications using C++
– Windows console applications using C++
Components
– MSVC x64/x86 build tools
– Visual C++ core desktop features
– C++ profiling tools
– Windows 10 SDK
– C++ CMake tools for Windows
– Test adapter for Google Test
– Test adapter for Boost.Test
– IntelliTrace
– Just-In-Time debugger
– Live Share
UWP development
Create applications for the Universal Windows Platform with C#, VB, or optionally C++
Description
Build applications that target Windows Desktop, Xbox, HoloLens, SurfaceHub, and even Windows 10 IoT.
Development applications
– Universal Windows Platform (UWP)
Components
Visual Studio
– Blend for Visual Studio
– .NET Native and .NET Standard
– NuGet package manager
– Universal Windows Platform tools
– Windows 10 SDK
Mobile development with .NET
Build cross-platform applications for iOS, Android, or Windows using Xamarin
Description
Build fully-native iOS, Android, and Universal Windows Platform apps using C# and XAML. Xamarin gives you full access to platform APIs and features using a single language and allows you to have a shared codebase with other .NET platforms.
Development applications
– Build cross-platform apps using Xamarin.Forms
– Access native features with the Xamarin.Essentials API
Components
– Xamarin
– .NET Framework4.x development tools
– C# and Visual Basic language support
– Android SDK setup
Mobile development with C++
Build cross-platform C++ apps for iOS or Android
Development applications
– Android Native App
– Import an XCode Project
– OpenGL ES application on Android and iOS
Components
– Visual Studio C++ core features
– Android SDK setup
– Android NDK
– Apache Ant
– C++ Android development tools
Game development with Unity
Create 2D and 3D games with Unity, a powerful cross-platform development environment
Description
Create games and interactive content and publish to 21 platforms, including all mobile platforms, WebGL, Mac, PC and Linux desktop, web or consoles.
Development applications
Develop Unity games with a premium debugging experience
Components
– Visual Studio Tools for Unity
– C# and Visual Basic
Game development with C++
Use the full power of C++ to build professional games powered by DirectX, Unreal, or Cocos2d
Description
Use the full power of C++ to build professional games for Windows, Xbox, and other consoles powered by DirectX, Unreal Engine, or Cocos2d.
Development applications
– Xbox live apps
– UWP apps on HoloLens
– Marble Maze
Components
– MSVC x64/x86 build tools
– Visual Studio C++ core features
– Windows Universal C Runtime
– C++ profiling tools
– Windows 10 SDK
– IntelliTrace
Data storage & processing
Connect, develop, and test data solutions using SQL Server, Azure Data Lake, Hadoop, or Azure ML
Description
The Data workload enables you to develop across a wide range of relational and big data assets. It provides you the tools to develop queries against databases, data warehouses and data lakes, whether on-premises or in Azure. It provides support for SQL, U-SQL, and Hive.
Development applications
– Use SQL Server Data Tools to design, deploy, and mantain databases
– Develop U-SQL scripts by using Azure Data Lake Tools
– Run Hive queries with Hadoop on Azure HDInsight
Components
– SQL Server Data Tools
– Azure Data Lake and Stream Analytics Tools
– .NET Framework 4.x development tools
Data science & analytical applications
Languages and tooling for creating data science applications, including Python and F#
Description
Use R and Python for wide range of scenarios such as data acquisition, cleaning, model training, deployment, and plotting. Use F#, a powerful functional-first .NET language, for a wide variety of data processing tasks.
Development applications
– Create visual data plots with R
– Work with the R interactive (REPL) window
– Create machine learning models using R and Microsoft ML Server
Components
– R and Microsoft R Client language support & runtime distributions
– Python and Anaconda language support & runtime distributions
– F# with the .NET framework language support & runtime distributions
Visual Studio extension development
Create add-ons and extensions for Visual Studio, including new commands, code analyzers, and tool windows
Description
Add the SDKs and tools you need to create new commands, code analyzers, tool windows, and language services using C#. Then, share your extension with the community in the Visual Studio Marketplace.
Development applications
– Extensions for Visual Studio IDE
– Software development kit development
Components
– Visual Studio SDK
– Visual Studio extension development prerequisites
– .NET profiling tools
– IntelliTrace
Office/SharePoint
Visual Studio For Mac Database Software
Create Office and SharePoint add-ins, SharePoint solutions, and VSTO add-ins using C#, VB, and JavaScript
Description
Take advantage of various project templates to extend Office and SharePoint. Easily build, debug, and publish your add-ins and solutions from Visual Studio.
Development applications
– Office add-ins
– VSTO add-ins
– SharePoint add-ins
– SharePoint solutions
Components
– Office Developer Tools for Visual Studio
– .NET Framework 4.5 targeting pack
– .NET Framework 4.x development tools
– Developer Analytics tools
Linux development with C++
Create and debug applications running in a Linux environment or Windows Subsystem for Linux (WSL)
Description
Build and run code on a remote machine or Windows Subsystem for Linux and browse, edit, and debug from within Visual Studio. Use CMake to target multiple platforms from the comfort of a single IDE.
Development applications
– Get Started
Components
– Visual Studio C++ core features
– Windows Universal C Runtime
– Visual C++ for Linux Development
– Visual C++ tools for CMake and Linux
.NET Core cross-platform development
Build cross-platform applications using .NET Core, ASP.NET Core, HTML/JavaScript, and Containers including Docker support
Description
.NET Core is an open source, general-purpose development platform maintained by Microsoft and the .NET community on GitHub. It’s cross-platform (supporting Windows, macOS, and Linux), and can be used to build device, cloud, and IoT applications.
Development applications
– Complete .NET Core solution on Windows
– Docker images for .NET Core applications
– C# console application using .NET Core
Components
– .NET Core 2.x development tools
– .NET Framework 4.x development tools
– ASP.NET and web development tools prerequisites
– Cloud tools for web development
– .NET profiling tools
– IntelliTrace
– Live Unit Testing
– Live Share Learn more about .NET Core cross-platform development
Get more done with dedicated project templates for Azure. These Quickstart templates give you a working app so you can immediately deploy to the cloud.
Deploy your application to Azure directly from Visual Studio with one click, easily connecting to your database of choice.
If you’re dealing with an issue that is hard to reproduce locally on your machine, you can use Cloud Explorer in Visual Studio to quickly and easily attach the Visual Studio remote debugger to your Azure environment.
Manage and explore your Azure resources and resource groups from Visual Studio using Cloud Explorer. You can inspect their properties and perform key diagnostic actions easily.
Stay comfortable and productive with our most popular add-ons
Live Q&A with Visual Studio Big Wigs
Streamline your dream dev team
Taking DevOps to the next level with GitHub and Azure DevOps
Accelerate your C++ development
Cross-platform iOS & Android development with Xamarin
Build amazing web apps with .NET Core
A tour of Visual Studio for Mac for .NET development
So you have a Visual Studio Subscription? Now what?
James Tramel
Unifying Windows desktop development with .NET Core 3.0
Olia Gavrysh & Scott Hunter
Visual Studio 2019 slam dunks on game development with Unity
Jb Evain & Unity Evangelists
Uniting all containers and Kubernetes fans in this Visual Studio 2019 session
Add Database Visual Studio 2017
Lisa Guthrie
CI/CD for your mobile apps and games with Visual Studio App Center
James White
Visual Studio For Mac Update Database
Machine Learning and Artificial Intelligence for every developer with ML.NET and Visual Studio 2019
Pranav Rastogi
Visual Studio For Mac Database Instability
Quickly take your applications to the “edge” with IoT and .NET Core
Richard Lander
Simplifying IoT development with Azure Sphere and Visual Studio
Visual Studio For Mac Os
Marc Goodner