Hi there. I'm just starting a new project, and using Entity Framework 4 for the first time, with Devart's MySql Connect product.
I've created my model and I've noticed it uses INNODB, which makes sense. However, I'm more comfortable with MyISAM, and can happily live without transactions and foreign keys. I've edited the db create file to use MyISAM and deleted the foreign key definitions, and so I'll be experimenting myself using just that anyway, but I wondered if there was anything I'm going to run in to. I'm happy to control referential integrity on deletes in my code, so this is purely from a Devart/Entity point of view.
I may well opt to return to INNODB anyway, but I need to consider any potential pitfalls of using either engine at this early stage in the project's development.
Thanks for your time.