DNXCORE 5.0 and mysql / mariadb

dapper dnx50 entity-framework mariadb mysql

Question

For a new project which has to target Linux and Windows, I am searching for a solution to support MySQL (or MariaDB).

Because we have to support those different platforms I wish to work on DNX Core5.0. However I can't find any nuget packages / connectors which I can use to connect to the database. the one that i find are not supported by DNX core 5.0.

Is there a way to connect to mysql in DNX core 5.0 ? Or do you have to fall back on ODBC connections, i don't know if this would work...

Further i was searching for an ORM to support this, my research till now found out that

  • Entity Framework 7 is not supporting MySQL at this moment. (and EF is not my favorite ORM at this moment)
  • NHibernate: Currently nobody is working on it and it will be difficult (breaking changes) to port it to DNX Core
  • Dapper: (MicroORM I know ...): This is supporting DNXCore but i need a vallid IConnection which I can't create.

Thanks for your feedback!

Rob

Popular Answer

I asked a similar question a couple of weeks ago. There is no MySql connector for DNX Core. I had to fall back to DNX 4.5.1 and was able to use MySql with Entity Framework in a project that's running inside a Docker container. Also see the response to my question.



Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why