Working with Dotnet and Sql edge on M1 mac nuget packages

Question

Hello,
Im new to mac, I have an M1 mac mini, Im using Visual Studio for M1 mac as well

Recently I have Installed docker with sql edge container in it.

In order to make my Web API projects more efficient,

I couldn't figure it out if I need some NuGet packages to make it work,

Can you please tell which NuGet packages should I install if any ,and direct me to some guides that I can learn more about
working with dotnet and sql edge on m1 mac ?

Answer 1

for all intent and purposes, azure sql edge is sqlserver 2019. use its docs.

you should download azure data studio for the Mac:

https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15

if you correctly exported the port 1433 you should be able to connect

server: localhost
authentication type: SQL Login
user name: sa
password: <your sa password>

to work with dotnet you have several options

nuget Microsoft.Data.SqlClient (AdoNet) is the preferred for SqlServer (replacing System.Data.SqlClient)

https://learn.microsoft.com/en-us/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace?view=sql-server-ver15

you can also use entity framework: Microsoft.EntityFrameworkCore

https://learn.microsoft.com/en-us/ef/core/