ASP.NET_MacOs 💻 🍏

setting up the environment

1️⃣ Install Rider

Rider is made by the same company who does Resharper(JetBrains). Resharper is awesome and makes your life a lot easier when you're coding. It can also suggest better ways of doing things. It also works like a charm on Mac which is great for me who likes to work across my PC and Mac.

Actually that's the best IDE to develop .NET application on MacOs (Apple silicon). However a lot of things that are easily accomplished in Visual Studio take a few more steps to initially setup in Rider. Entity Framework is one of them. Hopefully this will help someone else set it up or me when I need to do this again for my next project and forget 😁

First Go download the full version of Rider from jetbrains.com

Then you may install The UI for EntityFramework Core from plugins.jetbrains

2️⃣ Install SQL Server in Mac M1

🔴 Step 1

We must utilize Docker because MacOS does not provide native support for Microsoft technology. Fortunately, Docker already supports ARM applications, so we can get it from the Docker website.

🔴 Step 2

After that go running SQL Query and other DB activities, you’ll need to download an IDE. SQL Server Management Studio is the greatest tool for SQL Server to run SQL Query, although it is only supported on Windows OS. Microsoft has developed an alternative to SQL Server Management Studio, thanks to their team. Azure Data Studio is the tool’s name. This tool will be used on our M1-based Mac.

🔴 Step 3

We’ll need to create an ID on Docker or log in with the one you already have. After you’ve logged in, you’ll need to download a Microsoft-hosted docker image called Azure SQL Edge. We’ll use docker commands to download this image to our local system, and then run it in a docker container on the localhost port. We’ll be able to use the SQL server on our M1-based Mac once we run the image in the container.

🔴 Step 4

We can use the mac OS terminal to download the docker image. Open the terminal in your Mac System and Enter the command:

Docker will start pulling the image from the web repository and downloading it to your local machine after you run the command above. The image is also visible in the Docker Desktop window, as illustrated below.

🔴 Step 5

Once you’ve downloaded the Docker image, you’ll need to execute it in a Docker container on a live localhost port. Use the same terminal window to run the command below.

When the command completes successfully, go to the container option in the Docker desktop window and look for a container with the same name as the one we specified in the command.

🔴 Step 6

After that, we can log in to Azure Data Studio using the credentials we just created. Here’s how you can get in touch with it. You can now construct queries to generate tables, stored procedures, and other objects using the new query option. If you forget your password, you may simply remove the image and establish a new one.

Now let's start creating our first project 💻

I'll assume you have created your .Net Core project and it's noice and fresh (Nine-Nine!) and that you are intending to use code-first approach. I personally am using a .Net Core application template with C#, MVC and Github.

Here's a noice clean project:

🔴 Install NuGet packages

🔴 Creating a class

Using code first, we need to have some classes created to populate our DB with. In my application, I am going to create a student class.

🔴 Okay let's hookup our models to a database.

1️⃣ Create a new directory (file) and call it Data

2️⃣ Then create a class and call it whatever you want your database context to be called. I'll call mine ApplicationDbContext.cs (If it's already there, it's probably called ApplicationDbContext.cs and you can leave it as this or update the name to whatever you want. You'll just need to rename some references later where ever they're found)

3️⃣ Once created, we need to override the OnConfiguring method to read the connection string of database from SQL server via appsettings.json file as shown below

4️⃣ Set Dependency Injection with service container. This is done in our Program.cs file as shown below:

5️⃣ Let's now go into appsettings.json and tell our application about our data context.

6️⃣ Now let's actually go and build 🏗 and then add a migration and create our database 🔥

7️⃣ Let's go to Azure Data Studio to check our new table

🔴voilà! Congratulations for creating your first Table in SQL server by using your MacBook🔴