When to use EF queries, LinQ, or MySQLClient

Attached is one of the Entity Framework (EF) queries I'm referring to (I'm not sure if this is what it's actually called). Assuming you're building an app from scratch, in which contexts does each one perform best/worst? I'm really confused because it seems that you can do basically everything by opening connections and passing SQL queries with MySQLClient, so there must be some advantages to EF or LinQ
I'm told that EF comes with migrations and additional features that make it more appealing to db management, what other advantages does it have when it comes to DB management?
Not requiring you to write SQL
Also, during runtime does EF+LINQ run any slower/faster than manual DB management+MySQLClient?
The difference is marginal to none
MWMonsieur Wholesome10/10/2022
laughs in horribly generated ef sql code
Database Providers - EF Core
Information about specific supported Entity Framework Core providers and about providers in general
So you are saying that these will automatically allow me to swap freely between MySQL, MsSQL, PostGres and MariaDB?
Yep Well, mostly. Sure, just swapping the driver will do the job most of the time, but if you're using for example array columns (Postgres) switching to MariaDB won't be easy since it doesn't support this feature
That's crazy I feel like a neanderthal for manually doing MySQL DB scripts

Looking for more? Join the community!

Want results from more Discord servers?
Add your server
Recommended Posts
Process Checker [Answered]I'm creating an ""antivirus"" and I'm using a thread to check when a new process is started (but theArgumentNullException when argument is not nullI have this code: ```cs public class Config { [JsonProperty("token")] public string Token = "TOKWPF reusing the same template across multiple columnsThe following question https://social.msdn.microsoft.com/Forums/silverlight/en-US/f84e0efd-b1f2-4ab6Cascading DropDownI'm using MVC (.NET5) with EF and had this code to select a species on a View (to Create/Edit): ```cAssembly service findingHi, I am trying to find out if it's possible to get IServiceProvider, Microsoft IConfiguration or sohow do i submit a progra min vs to google classroomim trying to submit a project that's due to today but when i do submit it all i get is this and not WPF custom property not recognized by the compilerI have defined a custom property like below, it's in the namespace `CarApp`. It is supposed to repreEntity Framework DbContextOptionsBuilder.UseSqlServer() missing definitionI just installed the newest version of Entity Framework (6.0.9) and am inside my program.cs trying tDoes API manual nuget downloads come with the package dependencies?-WPF passing binding to a template from DataGridTemplateColumnSay, I have a template like this in resources, which I want to reuse for multiple columns, and whichBest way to implement a regex based lexer [Answered]In a regex lexer, you can loop over every pattern and do something like this: ```cs if (match.Successtring query in C Sharpi am trying to get values from 2 website links and assign them to a lable using visual studio one is there a convention for validating login sessions with MVC?Assuming I'm using ASP, ADO and .NET Say I want to construct a project to have several functions thUsing SQL db to create object ID or application?I have an application where my records in my DB need to have unique IDs. Should I leave this responsObject Initializers - To Parenthesize or Not To Parenthesize (that is the question)What is the difference between the object initializers on lines 1 and 2? In what situations should oHow do I move my mouse curser on screen?I went through most of stack overflow and some YouTube tutorials but didn't fins anythingHow do I move my mouse curser on screen?i was wondering if its possible to move the curse on the screen using c#SQL Error when trying to get an IDI'm trying to add username password and email to my users table And then get the ID of this new userEF Structuring ProblemBasically I have users that I want to assign to a group. But I also want the group to have a parent,data transfer between classesI want to list 'uname' value in method X, to method Y i am new to oop