Hi,

I'm starting a project using MySQL tomorrow. If I make sure all tables are InnoDB, are there any major gotchas that anyone would care to mention?

I'm concerend about transactions not working the same as they do in SQL Server.

Cheers, Ian.

Hi Ian,

In my own experience, I have worked on MySql projects and everything seems ok to me. I even have migrated whole SQLServer projects to MySql with very tiny effort.

Anyway, please red this carefully:

• LLBLGenPro Help - Concepts - Database drivers - Supported features per database driver - MySql.

• LLBLGenPro Help - Using the generated code - Compiling the code - SD.LLBLGen.Pro.DQE.yourDatabase assembly - MySql specific.

• http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=9757

Hi daelmo,

Which version of MyDirect .NET do I need? Can I get away with the standard or do I need the proffesional?

And I need to buy this?

Cheers, Ian.

You could use any version since 3, the standard version is enough for LLBLGenPro. I use heavily Mysql (every day) with LLBLGenPro and it works great.

OK, thanks.

I just copied my entire solution over to another machine. It compiles ok but I get the following runtime error...

An exception of type 'System.IO.FileLoadException' occurred in SD.LLBLGen.Pro.DQE.MySql.NET20.DLL but was not handled in user code

Additional information: Could not load file or assembly 'CoreLab.MySql, Version=4.0.9.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

How could this be? All the dll references are to the same set of files as copied over from the original machine.

Please check the following threads: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12868 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12040 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=11803