{"id":42404,"date":"2024-05-29T10:24:39","date_gmt":"2024-05-29T10:24:39","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=42404"},"modified":"2026-02-19T04:44:44","modified_gmt":"2026-02-19T04:44:44","slug":"articles-connect-mysql-mariadb-with-net-core","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/articles-connect-mysql-mariadb-with-net-core","title":{"rendered":"How to Connect MySQL or MariaDB With The .Net Core Application?"},"content":{"rendered":"

How to Connect MySQL or MariaDB With The .Net Core Application?<\/h2>\n

Conn\u0435cting a .NET Cor\u0435 application to a MySQL or MariaDB databas\u0435 is a crucial st\u0435p for many d\u0435v\u0435lop\u0435rs, \u0435sp\u0435cially when working with data int\u0435nsiv\u0435 applications. AccuW\u0435b.Cloud provides a robust platform to host both your .NET Cor\u0435 application with MySQL\/MariaDB databas\u0435, \u0435nsuring high p\u0435rformanc\u0435, scalability, and r\u0435liability. In this compr\u0435h\u0435nsiv\u0435 guid\u0435, we will walk you through th\u0435 st\u0435ps to connect your .NET Cor\u0435 application with MySQL or MariaDB on AccuWeb.Cloud<\/a><\/p>\n

\".NET<\/a><\/p>\n

1. Creating a .NET Core Server with MySQL or MariaDB on AccuWeb.Cloud<\/h2>\n

Setting up a .NET Core server with a MySQL or MariaDB database on AccuwWeb.Cloud is a straightforward process.<\/p>\n

Follow these steps to get your environment up and running quickly.<\/p>\n

Step 1.<\/strong> Log in to your AccuWeb.Cloud dashboard. Navigate to the top-left corner and click on the New Environment <\/strong>button.<\/p>\n

\"New<\/a><\/p>\n

Step 2.<\/strong> In the opened topology wizard, go to the .NET tab<\/strong> and select the .NET Core application server<\/strong>. Configure the other parameters according to your needs, such as: Cloudlets, Disk limit, and Public IP.<\/p>\n

Step 3.<\/strong> Choose either the MySQL or MariaDB<\/strong> database server. Make sure to select the version and configurations that match your requirements.<\/p>\n

Step 4.<\/strong> Enter a suitable Environment name to easily identify your setup.<\/p>\n

Step 5.<\/strong> Click Create to proceed.<\/p>\n

\"Create<\/a><\/p>\n

Your environment with the .NET Core server and MySQL or MariaDB database will be created in a few minutes.<\/p>\n

2. Retrieving Database Credentials<\/h2>\n

Once your environment is ready, you will receive an email containing all the administrative details and credentials for your newly created database server. Keep this information secure as it will be essential for connecting your application to the database.<\/p>\n

\"Database<\/a><\/p>\n

3. Install Necessary Packages<\/h2>\n

Add the required packages for Entity Framework Core and MySQL:<\/strong><\/p>\n

<\/div>\n
\r\ndotnet add package Microsoft.EntityFrameworkCore\r\ndotnet add package Microsoft.EntityFrameworkCore.Design\r\ndotnet add package Pomelo.EntityFrameworkCore.MySql<\/code><\/pre>\n
<\/div>\n
\"Install<\/a><\/p>\n
4. Create `appsettings.json`<\/h2>\n
Create or update an `appsettings.json` file in the root directory of your project with the following content:<\/p>\n
<\/div>\n
\r\n{\r\n\"Logging\": {\r\n\"LogLevel\": {\r\n\"Default\": \"Information\",\r\n\"Microsoft.AspNetCore\": \"Warning\"\r\n}\r\n},\r\n\"AllowedHosts\": \"*\",\r\n\"ConnectionStrings\": {\r\n\"DefaultConnection\": \"Server=your_server;Database=your_database;User=your_username;Password=your_password;\"\r\n}\r\n}\r\nReplace <YOUR_DB_HOST>, <YOUR_DB_NAME>, <YOUR_DB_USER>, and <YOUR_DB_PASSWORD> with the actual credentials received in the email from Accuweb Cloud.\r\n<\/code><\/pre>\n
<\/div>\n
\"appsettings.json\"<\/a><\/p>\n
5. Create `ApplicationDbContext.cs`<\/h2>\n
Create a class file named `ApplicationDbContext.cs` to manage your database context:<\/p>\n
<\/div>\n
\r\nusing Microsoft.EntityFrameworkCore;\r\nusing Microsoft.Extensions.Configuration;\r\nusing System.IO;\r\npublic class ApplicationDbContext : DbContext\r\n{\r\npublic DbSet<YourEntity> YourEntities { get; set; }\r\nprotected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)\r\n{\r\nvar configuration = new ConfigurationBuilder()\r\n.SetBasePath(Directory.GetCurrentDirectory())\r\n.AddJsonFile(\"appsettings.json\")\r\n.Build();\r\noptionsBuilder.UseMySql(configuration.GetConnectionString(\"DefaultConnection\"), new MySqlServerVersion(new Version(8, 0, 21)));\r\n}\r\n}\r\npublic class YourEntity\r\n{\r\npublic int Id { get; set; }\r\npublic string Name { get; set; }\r\n}<\/code><\/pre>\n
<\/div>\n
\"\"<\/a><\/p>\n
6. Update `Program.cs`<\/h2>\n
Modify your `Program.cs` to check and display the database connection status:<\/p>\n
<\/div>\n
\r\nusing System;\r\nusing Microsoft.EntityFrameworkCore;\r\nclass Program\r\n{\r\nsatic void Main(string[] args)\r\n{\r\ntry\r\n{\r\nusing (var context = new ApplicationDbContext())\r\n{\r\n\/\/ Try to open a connection to the database\r\ncontext.Database.OpenConnection();\r\ncontext.Database.CloseConnection();\r\nConsole.WriteLine(\"Successfully connected to the database.\");}\r\n}\r\ncatch (Exception ex)\r\n{\r\nConsole.WriteLine($\"An error occurred while connecting to the database: {ex.Message}\");\r\n}\r\n}\r\n}<\/code><\/pre>\n
<\/div>\n
\"Program.cs\"<\/a><\/p>\n
7. Verify Directory Structure<\/h2>\n
Ensure your directory structure looks like this:<\/p>\n
<\/div>\n
\r\n\/home\/jelastic\/APP\/ROOT\/\r\n\/bin\r\n\/obj\r\n\/.nuget\r\n\/.dotnet\r\n\/Properties\r\n\/wwwroot\r\n\/Pages\/ApplicationDbContext.cs\r\nProgram.cs\r\nappsettings.json\r\nROOT.csproj<\/code><\/pre>\n
<\/div>\n
\"Directory<\/a><\/p>\n
8. Build and Run the Application<\/h2>\n
Build and run your application to verify the database connection:<\/p>\n