Reply to thread

TVEngine on MySQL

I currently use TVEngine on MySQL 5.0.26 and it's works.

you can download my sql script to create db from

http://www.samposoft.it/database.zip

I have use MyIsam table for best performance.

I have made some modification to the TVLibraty project to add the latest reference to

Gentle-1.2.9 DLL because in SVN are 2 missing dll

Gentle.Provider.MySQL.dll

MySql.Data.dll

I have removed in all project reference to

Gentle.Provider.SQLServer.dll

because Gentle.Framework load dynmically these dll based on Gentle.config configuration.

http://www.samposoft.it/Gentle129Dll.zip

The only bug that i found in source code is in

TVLibrary\TVDatabase\Channel.cs

TVLibrary\TVDatabase\TvBusinessLayer\BusinessLayer.cs

that format bad datetime string in query "yyyyMMdd HH:mm:ss"

I've changed to "yyyy-MM-dd HH:mm:ss"

I think that SQLserver support this format (is more flexible).

I have also commented code in

TVLibrary\SetupTv\Startup.cs

[CODE]      //SetupDatabaseForm dlg = new SetupDatabaseForm();

      //if (!dlg.TestConnection())

      //{

      //  dlg.ShowDialog();

      //}

      //if (dlg.ShouldDoUpgrade())

      //{

      //  dlg.CreateDatabase();

      //}[/CODE]

because the SetupDatabaseForm works only for SQLServer and use System.Data.SqlClient.

The next step is to create a new SetupDatabaseForm for support MySQL or SQLServer.

I think that is very simple...