Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 1096645" data-attributes="member: 82144">Merged, thanks. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />I think the &quot;preferred connection&quot; you mention is just [USER=25430]@gibman[/USER]'s connection string, because I certainly have to modify app.config to connect to my database. IMHO there is nothing really special to protect there. Either way, surely it would be good to have an example SQLite connection string like we already have for MySQL, SQL Server and SQL Server CE?[collapse]&nbsp; &lt;connectionStrings&gt;&nbsp; &lt;!--&nbsp; for MYSQL use:&nbsp; &lt;add name=&quot;Model&quot; connectionString=&quot;metadata=res://Mediaportal.TV.Server.TVDatabase.EntityModel/Model.csdl|res://Mediaportal.TV.Server.TVDatabase.EntityModel/Mediaportal.TV.Server.TVDatabase.EntityModel.Model.MySQL.ssdl|res://Mediaportal.TV.Server.TVDatabase.EntityModel/Model.msl;provider=MySql.Data.MySqlClient;provider connection string=&amp;quot;server=localhost;User Id=root;database=TVE35;password=MediaPortal;Persist Security Info=True&amp;quot;&quot; providerName=&quot;System.Data.EntityClient&quot; /&gt;&nbsp; for MS SQL use:&nbsp; &lt;add name=&quot;Model&quot; connectionString=&quot;metadata=res://Mediaportal.TV.Server.TVDatabase.EntityModel/Model.csdl|res://Mediaportal.TV.Server.TVDatabase.EntityModel/Mediaportal.TV.Server.TVDatabase.EntityModel.Model.MSSQL.ssdl|res://Mediaportal.TV.Server.TVDatabase.EntityModel/Model.msl;provider=MySql.Data.MySqlClient;provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=localhost\SQLEXPRESS;Initial Catalog=TVE35;User ID=sa;Password=MediaPortal;MultipleActiveResultSets=True&amp;quot;&quot; providerName=&quot;System.Data.EntityClient&quot; /&gt;&nbsp; for MS SQL CE (MP2) use:&nbsp; &lt;add name=&quot;Model&quot; connectionString=&quot;metadata=res://Mediaportal.TV.Server.TVDatabase.EntityModel/Model.csdl|res://Mediaportal.TV.Server.TVDatabase.EntityModel/Mediaportal.TV.Server.TVDatabase.EntityModel.Model.MSSQLCE.ssdl|res://Mediaportal.TV.Server.TVDatabase.EntityModel/Model.msl;provider=System.Data.SqlServerCe;provider connection string=&amp;quot;Data Source='C:\ProgramData\Team MediaPortal\MP2-Server\TVE35.sdf'; Default Lock Timeout=30000; Max Buffer Size = 2048; Max Database Size = 1024;&amp;quot;&quot; providerName=&quot;System.Data.EntityClient&quot; /&gt;&nbsp; --&gt;[/collapse]I had assumed (maybe wrongly?) that when TVE 3.5 gets a standalone installer it would be desirable to make it possible to select SQLite as one of the DB options like we have with MySQL and SQL Server for TVE 3. In other words, it might not only be MP2 that uses SQLite. Therefore we would need SQLite in the packages.config.On that note, I don't know if you saw already: I've now removed the ExternalBinaries directory and replaced it with the official NuGet packages for EF and MySQL. They're included in the EntityModel project packages.config... and I'd do the same with SQLite... and SQL Server CE if binaries are/were also required for that....or have I misunderstood something?</blockquote>

[QUOTE="mm1352000, post: 1096645, member: 82144"] Merged, thanks. :) I think the "preferred connection" you mention is just [USER=25430]@gibman[/USER]'s connection string, because I certainly have to modify app.config to connect to my database. IMHO there is nothing really special to protect there. Either way, surely it would be good to have an example SQLite connection string like we already have for MySQL, SQL Server and SQL Server CE? [collapse] <connectionStrings> [/collapse] I had assumed (maybe wrongly?) that when TVE 3.5 gets a standalone installer it would be desirable to make it possible to select SQLite as one of the DB options like we have with MySQL and SQL Server for TVE 3. In other words, it might not only be MP2 that uses SQLite. Therefore we would need SQLite in the packages.config. On that note, I don't know if you saw already: I've now removed the ExternalBinaries directory and replaced it with the official NuGet packages for EF and MySQL. They're included in the EntityModel project packages.config... and I'd do the same with SQLite... and SQL Server CE if binaries are/were also required for that. ...or have I misunderstood something? [/QUOTE]

Verification