{"id":50954,"date":"2025-03-15T10:53:35","date_gmt":"2025-03-15T10:53:35","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=50954"},"modified":"2026-02-17T13:16:36","modified_gmt":"2026-02-17T13:16:36","slug":"integrate-dot-net-core-with-mssql-on-linux","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/integrate-dot-net-core-with-mssql-on-linux","title":{"rendered":"How to integrate .Net Core with MSSQL Server in Linux System?"},"content":{"rendered":"

How to integrate .Net Core with MSSQL Server in Linux System?<\/h2>\n

Setting up .NET Core with SQL Server on Linux helps developers build apps that work across different platforms with a strong database. This setup includes installing SQL Server, setting up .NET Core dependencies, and configuring the database connection using Entity Framework Core or ADO.NET.<\/p>\n

With the right setup, your .NET Core app can easily connect to SQL Server while taking advantage of Linux\u2019s speed and flexibility.<\/p>\n

Requirements Before Installation<\/h2>\n

– .NET Core SDK and SQL Server must be installed on Linux.<\/p>\n

– Root access to the Linux system is required.<\/p>\n

Here, we will create an MVC Employee Management System and integrate it with the MSSQL Server.<\/p>\n

Step 1: Create an MVC Project<\/h3>\n

Open your terminal and run this command to create a new MVC project named EmployeeManagement:<\/p>\n

dotnet new mvc -o EmployeeManagement<\/b><\/code><\/pre>\n
\"Create<\/a><\/p>\n
Go to the newly created project folder:<\/p>\n
cd EmployeeManagement<\/b><\/code><\/pre>\n
\"Created<\/a><\/p>\n
Step 2: Install Required Entity Framework Core Packages<\/h3>\n
Entity Framework Core lets your .NET app interact easily with the MSSQL Server. Run these commands to install the needed packages:<\/p>\n
dotnet add package Microsoft.EntityFrameworkCore<\/b><\/code><\/pre>\n
dotnet add package Microsoft.EntityFrameworkCore.SqlServer<\/b><\/code><\/pre>\n
dotnet add package Microsoft.EntityFrameworkCore.Design<\/b><\/code><\/pre>\n
dotnet add package Microsoft.EntityFrameworkCore.Tools<\/b><\/code><\/pre>\n
Step 3: Create a Database<\/h3>\n
Log into your SQL Server using this command (replace ‘YourPassword’ with your actual password):<\/p>\n
sqlcmd -S localhost -U SA -P 'YourPassword'<\/b><\/code><\/pre>\n
Create a new database named EmployeeDB:<\/p>\n
CREATE DATABASE EmployeeDB;<\/b>\r\nGO<\/b><\/code><\/pre>\n
Check if the database is created:<\/p>\n
SELECT Name FROM sys.databases;<\/b>\r\nGO<\/b><\/code><\/pre>\n
Exit SQLCMD:<\/p>\n
EXIT<\/b><\/code><\/pre>\n
<\/div>\n\t\t
\n\t\t\t        
\n            \n                        
\n                    
\n        
\n                    \n        \t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t            <\/div>\n        <\/div>\n                    <\/div>\n        <\/section>\n        \t\t<\/div>\n\t\t\n
<\/div>\n
\"Log<\/a><\/p>\n
Step 4: Install EF Core Tool Globally<\/h3>\n
The EF Core Tool helps manage database migrations, create models, and update database schemas. Installing it globally means you can use EF commands in any .NET Core project without reinstalling them each time.<\/p>\n
Install the EF Core Tool<\/b><\/p>\n
Run this command in the terminal:<\/p>\n
\"Install<\/a><\/p>\n
Update the System Path<\/b><\/p>\n
Run these commands to make sure the tool works everywhere:<\/p>\n
export PATH=\"$HOME\/.dotnet\/tools:$PATH\"<\/b>\r\necho 'export PATH=\"$HOME\/.dotnet\/tools:$PATH\"' >> ~\/.bashrc<\/b>\r\nsource ~\/.bashrc<\/b><\/code><\/pre>\n
\"Update<\/a><\/p>\n
Check the Installation<\/b><\/p>\n
Verify that EF Core is installed by checking its version:<\/p>\n
dotnet ef --version<\/b><\/code><\/pre>\n
\"Check<\/a><\/p>\n
If installed correctly, it will show the EF Core version.<\/p>\n
Step 5: Add the Database Connection in appsettings.json<\/h3>\n
The connection string in appsettings.json helps .NET Core connect to the SQL Server database. Storing it here makes it easy to change settings without modifying the code. It also supports different environments like development and production.<\/p>\n
Add the Connection String<\/b><\/p>\n
Open the appsettings.json file using this command:<\/p>\n
nano appsettings.json<\/b><\/code><\/pre>\n
Then, add the following code:<\/p>\n
{<\/b>\r\n\u00a0\u00a0\"Logging\": {<\/b>\r\n\u00a0\u00a0\u00a0\u00a0\"LogLevel\": {<\/b>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Default\": \"Information\",<\/b>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"Microsoft.AspNetCore\": \"Warning\"<\/b>\r\n\u00a0\u00a0\u00a0\u00a0}<\/b>\r\n\u00a0\u00a0},<\/b>\r\n\u00a0\u00a0\"AllowedHosts\": \"*\",<\/b>\r\n\u00a0\u00a0\"ConnectionStrings\": {<\/b>\r\n\u00a0\u00a0\u00a0\u00a0\"DefaultConnection\": \"Server=localhost;Database=EmployeeDB;User Id=sa;Password=YourPassword;TrustServerCertificate=True\"<\/b>\r\n\u00a0\u00a0}<\/b>\r\n}<\/b><\/code><\/pre>\n
-> Replace YourPassword with your actual SQL Server SA password.<\/p>\n
-> If SQL Server is on another server, replace localhost with the server’s IP address.<\/p>\n
\"Replace<\/a><\/p>\n
Step 6: Create Database Context<\/h3>\n
The DbContext in Entity Framework Core (EF Core) is like a bridge between your .NET Core application and the SQL database. It helps manage database connections, transactions, and queries using LINQ (instead of writing SQL manually).<\/p>\n
It also:<\/p>\n
Tracks changes in data<\/p>\n
Supports migrations (database updates)<\/p>\n
Helps with Create, Read, Update, Delete (CRUD) operations<\/p>\n
\n