Reply to thread

Message

<blockquote data-quote="samposoft" data-source="post: 108542" data-attributes="member: 29191">TVEngine on MySQLI currently use TVEngine on MySQL 5.0.26 and it's works.<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" /> you can download my sql script to create db from <a href="http://www.samposoft.it/database.zip" target="_blank">http://www.samposoft.it/database.zip</a>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 dllGentle.Provider.MySQL.dllMySql.Data.dllI have removed in all project reference to Gentle.Provider.SQLServer.dllbecause Gentle.Framework load dynmically these dll based on Gentle.config configuration.<a href="http://www.samposoft.it/Gentle129Dll.zip" target="_blank">http://www.samposoft.it/Gentle129Dll.zip</a>The only bug that i found in source code is inTVLibrary\TVDatabase\Channel.csTVLibrary\TVDatabase\TvBusinessLayer\BusinessLayer.csthat format bad datetime string in query &quot;yyyyMMdd HH:mm:ss&quot;I've changed to &quot;yyyy-MM-dd HH:mm:ss&quot;I think that SQLserver support this format (is more flexible).I have also commented code inTVLibrary\SetupTv\Startup.cs[CODE]&nbsp; &nbsp; &nbsp; //SetupDatabaseForm dlg = new SetupDatabaseForm();&nbsp; &nbsp; &nbsp; //if (!dlg.TestConnection())&nbsp; &nbsp; &nbsp; //{&nbsp; &nbsp; &nbsp; //&nbsp; dlg.ShowDialog();&nbsp; &nbsp; &nbsp; //}&nbsp; &nbsp; &nbsp; //if (dlg.ShouldDoUpgrade())&nbsp; &nbsp; &nbsp; //{&nbsp; &nbsp; &nbsp; //&nbsp; dlg.CreateDatabase();&nbsp; &nbsp; &nbsp; //}[/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...</blockquote>

[QUOTE="samposoft, post: 108542, member: 29191"] [b]TVEngine on MySQL[/b] I currently use TVEngine on MySQL 5.0.26 and it's works.:D you can download my sql script to create db from [URL="http://www.samposoft.it/database.zip"]http://www.samposoft.it/database.zip[/URL] 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. [URL="http://www.samposoft.it/Gentle129Dll.zip"]http://www.samposoft.it/Gentle129Dll.zip[/URL] 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... [/QUOTE]

Verification