Visual Studio For Mac Open Sql Database

Active2 years, 3 months ago

Turn Visual Studio into a powerful development environment for SQL Server, Azure SQL Database and Azure SQL Data Warehouse. Extension for Visual Studio Code - Develop Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere.

I am using Visual Studio on Mac (release edition) and I want to connect to a SQL Server.

I am aware that probably the most recommended way would be to create a web service and I understand why.

However, I am so unsuccessful in doing it any other way. Surely a web backend is not the only way?

I can't seem to link to the Entity Framework and the System.Data.SqlClient does not work either.

Am I missing something crucial?I can set it up successfully in VSCode, but not when I want to create a Mac OS app.

Visual Studio For Mac

In both cases, I am making an app that is 'mobile' on my computer.

Setting up SQLite is not a problem, but I am after sharing data between apps - is a web service, other than just being recommended actually the only way to do this within Xamarin?

Macjwknzjwknz
2,83110 gold badges56 silver badges88 bronze badges

1 Answer

You'll need to use the 'Core' version of the Entity Framework:

Visual studio for mac os x

See:https://docs.microsoft.com/en-us/ef/core/

tg2tg2

Visual Studio For Mac Open Sql Database Files Require

1,2003 gold badges9 silver badges21 bronze badges

Visual Studio For Mac Os

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged asp.netsql-servermacosxamarinsqlclient or ask your own question.

-->

This topic describes how to connect to a SQL Server Compact 3.5 database by using Visual Studio.

To connect to a database

Sql Server Visual Studio Code

  1. Open Visual Studio.

  2. At the top right, open Server Explorer.

  3. In the Server Explorer, right click Data Connections.

  4. Click Add Connection.

  5. In the Choose Data Source dialog box, select Microsoft SQL Server Compact 3.5 and then click Continue.

  6. In the Add Connection dialog box, browse for the SQL Server Compact 3.5 database.

    In the Add Connection dialog box, to set the maximum size for a database, click Advanced. In the Advanced Properties box, under Max Database Size, specify a database size greater than or equal to the size of the SQL Server Compact 3.5 database that you plan to connect to. The default value of the Max Database Size property is 128 MB for devices and 256 MB for desktops.

Comments are closed.