Reply to thread

Message

And here's the patch. I've made this change because I think it will be valuable not to have to install a full db server just to run TVServer.

Note: I've not been able to test it fully yet as I could do with some hints on how to build MP in such a way that it resembles the standard deployment package. I will test it however as soon as I can get it up and running in that state (or learn how to run the service in debug)..

In summary, my changes are these:

Gentle.Framework
Changed Gentle.Provider.SQLite to use NuGet and the latest SQLite package (1.0.99)
Changed the PostBuild.bat to copy the correct file to the references directory under TVDatabase (and allow spaces in paths)
Removed the old reference to System.Data.SQLite referenced by Gentle
SetupTv
Uncommented the SQLite provider in the default Gentle.config so it becomes available to Gentle
Added a reference to Gentle.Provider.SQLite and System.Data.SQLite pointing at the TVDatabase\references directory
App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0)
Created a create_sqlite_database.sql script to create the basic tables in a SQLite database
Created each of the upgrade scripts (39-61) so they work with SQLite
Added SQLite as a selection in the SetupDatabaseForm next to SQLServer and MySQL
Used the server textbox for the path to the database, and defaulted it to the same location as Gentle.config (could be made clearer)
Modified various locations where the ProviderType enum is referenced to add SQLite and make the associated code (test, save, upgrade) work.
TvService
App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0)
Referenced Gentle.Provider.SQLite and System.Data.SQLite from the TVDatabase/references location
The extent of my testing so far is to start with the default Gentle.config and run SetupTv in interactive mode. It allows me to select and create a SQLite db, which is then upgraded to the latest DB schema using the scripts. I can then run TVServer in debug without errors. I need however to run the two together so that they can communicate using remoting and scan for channels for example, which I might need some help on.

Happy to answer any questions about these changes.

<blockquote data-quote="grahamd" data-source="post: 1180641" data-attributes="member: 70875">And here's the patch.&nbsp; I've made this change because I think it will be valuable not to have to install a full db server just to run TVServer.Note: I've not been able to test it fully yet as I could do with some hints on how to build MP in such a way that it resembles the standard deployment package.&nbsp; I will test it however as soon as I can get it up and running in that state (or learn how to run the service in debug)..In summary, my changes are these:Gentle.Framework<ul>
<li data-xf-list-type="ul">Changed Gentle.Provider.SQLite to use NuGet and the latest SQLite package (1.0.99)</li>
<li data-xf-list-type="ul">Changed the PostBuild.bat to copy the correct file to the references directory under TVDatabase (and allow spaces in paths)</li>
<li data-xf-list-type="ul">Removed the old reference to System.Data.SQLite referenced by Gentle</li>
</ul>SetupTv<ul>
<li data-xf-list-type="ul">Uncommented the SQLite provider in the default Gentle.config so it becomes available to Gentle</li>
<li data-xf-list-type="ul">Added a reference to Gentle.Provider.SQLite and System.Data.SQLite pointing at the TVDatabase\references directory</li>
<li data-xf-list-type="ul">App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0) 
</li>
<li data-xf-list-type="ul">Created a create_sqlite_database.sql script to create the basic tables in a SQLite database</li>
<li data-xf-list-type="ul">Created each of the upgrade scripts (39-61) so they work with SQLite</li>
<li data-xf-list-type="ul">Added SQLite as a selection in the SetupDatabaseForm next to SQLServer and MySQL</li>
<li data-xf-list-type="ul">Used the server textbox for the path to the database, and defaulted it to the same location as Gentle.config (could be made clearer) 
</li>
<li data-xf-list-type="ul">Modified various locations where the ProviderType enum is referenced to add SQLite and make the associated code (test, save, upgrade) work.</li>
</ul>TvService<ul>
<li data-xf-list-type="ul">App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0)</li>
<li data-xf-list-type="ul">Referenced Gentle.Provider.SQLite and System.Data.SQLite from the TVDatabase/references location</li>
</ul>The extent of my testing so far is to start with the default Gentle.config and run SetupTv in interactive mode.&nbsp; It allows me to select and create a SQLite db, which is then upgraded to the latest DB schema using the scripts.&nbsp; I can then run TVServer in debug without errors.&nbsp; I need however to run the two together so that they can communicate using remoting and scan for channels for example, which I might need some help on.Happy to answer any questions about these changes.</blockquote>

[QUOTE="grahamd, post: 1180641, member: 70875"] And here's the patch. I've made this change because I think it will be valuable not to have to install a full db server just to run TVServer. Note: I've not been able to test it fully yet as I could do with some hints on how to build MP in such a way that it resembles the standard deployment package. I will test it however as soon as I can get it up and running in that state (or learn how to run the service in debug).. In summary, my changes are these: [B] Gentle.Framework[/B] [LIST] [*]Changed Gentle.Provider.SQLite to use NuGet and the latest SQLite package (1.0.99) [*]Changed the PostBuild.bat to copy the correct file to the references directory under TVDatabase (and allow spaces in paths) [*]Removed the old reference to System.Data.SQLite referenced by Gentle [/LIST] [B]SetupTv[/B] [LIST] [*]Uncommented the SQLite provider in the default Gentle.config so it becomes available to Gentle [*]Added a reference to Gentle.Provider.SQLite and System.Data.SQLite pointing at the TVDatabase\references directory [*]App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0) [*]Created a create_sqlite_database.sql script to create the basic tables in a SQLite database [*]Created each of the upgrade scripts (39-61) so they work with SQLite [*]Added SQLite as a selection in the SetupDatabaseForm next to SQLServer and MySQL [*]Used the server textbox for the path to the database, and defaulted it to the same location as Gentle.config (could be made clearer) [*]Modified various locations where the ProviderType enum is referenced to add SQLite and make the associated code (test, save, upgrade) work. [/LIST] [B]TvService[/B] [LIST] [*]App.config: Allowed .NET 2.0 assemblies to be loaded under 4.0 (Gentle is .NET 2.0) [*]Referenced Gentle.Provider.SQLite and System.Data.SQLite from the TVDatabase/references location [/LIST] The extent of my testing so far is to start with the default Gentle.config and run SetupTv in interactive mode. It allows me to select and create a SQLite db, which is then upgraded to the latest DB schema using the scripts. I can then run TVServer in debug without errors. I need however to run the two together so that they can communicate using remoting and scan for channels for example, which I might need some help on. Happy to answer any questions about these changes. [/QUOTE]