EfCoreinAction-SecondEdition VS Pomelo.EntityFrameworkCore.MySql

Got this approach to making a dropdown from Jon P Smit's app https://github.com/JonPSmith/EfCoreinAction-SecondEdition

I want to write a filter like here /BookServices/QueryObjects/BookListDtoFilter.cs (Query Object pattern) but applying to my situation. I have a Course table, which is linked to tables Module and Instructors as Course-Instructors like Many to one and Course to Modules like One- to- Many. One Module might have many videos (one -to - many). I need to filter courses by Instructor and by the Duration. How would i achieve that? I think that at first I probably need to alter CourseDTO class to include fields of interest there (Duration and Instructor's name) to be able to fill in them through linq queries in subsequent stages?

EntityFramework uses providers to translate Linq queries into real queries and connect to the datasource and convert the data into .net readable format. The MySQL provider for .NET is the official one but I think it has fallen on hard times and is not developed as much as before. You should probably look at Pomelo, which is a community library for .net core: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql

For MySQL and friends you'll need the Pomelo data provider from https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql . Turns out there's an example of using the MySQL provider about halfway down that shows how to, but it is missing the '-o Model' parameter that you'd use to get your database model into a folder called Model.

This approach has become my preferred way of generating IDs for database rows. It is relatively space efficient and doesn't require a round trip to the database to generate an ID like auto increment does.

While working on a C# implementation for MySQL and we found that when the DB uses Little Endian Binary that the GUID must be reversed to store in order:

https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCo...