VS 2022 Community WPF C# .Net 6 - Is it possible to use Servers / Data Connections / Model design functionnalities with MariaDB as database?

Dmtr_Grms 331 Reputation points
2022-03-21T17:33:29.17+00:00

Hi, I need to create a desktop application that will use MariaDB as database (in local for Dev and then in remote for PROD on a Synology). I tried to create my development environment on my local machine (Windows 11). I installed MariaDB 10.3.29, with nuget manager I installed Microsoft.EntityFrameworkCore.Tools / Microsoft.EntityFrameworkCore.Design / MySqlConnector / Pomelo.EntityFrameworkCore.MySql.
I created a ConnectionString and developed a function to receive in a MessageBox the content of a file --- it works. Now I tried to use in Visual Servers / Data Connections / Model design functionnalities but I'm not successful in connecting, creating datasource or design a model using the offered options... I had a look to dozen of docs and explanations on Internet but I'm not able to make it works... At this point I'm wondering if such options are available using MariaDB or what I'm missing to make it run. Could someone help me? Thanks in advance.

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
700 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,350 questions
{count} votes