Is it feasible to use MySQL with Entity Framework 6 and get good performance from CRUD?
Is it feasible to use MySQL with Entity Framework 6 and get good performance from CRUD?
Set good performance.
If it is an acceptable performance, yes, it is feasible, this is proven having a huge amount of people who have already done this.
If it is to get the maximum performance possible, then it is not feasible. Already starts with the Entity Framework which is an extra layer to access the database, which on the one hand facilitates certain operations, on the other hand performs these operations in knowing exactly the best way 'to obtain the best performance. We can also say that some of the fault can be MySQL itself. If you want the most of the performance, there are better options. Of course some will charge some price, but you asked about performance alone.
This is a way of saying that the question is not easily answered unless a huge "depends".
But what is more important is that you can only know about feasibility by having clear parameters and testing with real situations that you will face. But if generic information is enough for you, understand that any product that exists on the market and has users produces at least acceptable results.
Maybe it's not the answer you want, but there are no definite and magical answers.
I prefer not to use these technologies for a number of circumstances, among them it does not give the performance that I would like. Only you can answer if they give you the performance you would like.