Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
726 questions
VS 2022 Community WPF C# .Net 6 - Is it possible to use Servers / Data Connections / Model design functionnalities with MariaDB as database?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dmtr_Grms
331
Reputation points
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
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,648 questions
{count} votes
-
AgaveJoe 27,696 Reputation points2022-03-21T17:50:27.907+00:00 I'm not sure I understand what you're asking... I think you are looking for the older Entity Framework database first feature (edmx file) which does not exist in EF Core. EF Core uses code first tooling.
Are you trying to scaffold entities from an existing database?
https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding?tabs=dotnet-core-cli
-
Dmtr_Grms 331 Reputation points
2022-03-21T19:25:34.46+00:00 Thanks for your answer. No I would like to create from scratch a model for my db, starting from designing my db in Visual Studio...
-
AgaveJoe 27,696 Reputation points
2022-03-21T20:26:53.19+00:00 I think you misunderstand how Entity Framework Core fundamentally works. Code first starts by creating the models which are used to create tables in the database using what's called a migration. I recommend the following tutorials to get you up to speed.
It's is possible to start with an existing database. See the link in my first post.
Sign in to comment