Reply to thread

Message

<blockquote data-quote="regeszter" data-source="post: 1124919" data-attributes="member: 15874">If Trakt uses the <a href="https://github.com/MediaPortal/MediaPortal-1/blob/master/mediaportal/Databases/Video/VideoDatabase.cs#L702" target="_blank">ExecuteSql() </a>or the <a href="https://github.com/MediaPortal/MediaPortal-1/blob/master/mediaportal/Databases/Video/VideoDatabase.cs#L707" target="_blank">ExecuteRuleSql() </a>it won't work because the EF can not run sql without declare the return type.If the Trakt uses API where the method run a &quot;free hand sql&quot; likeGetMoviesByFilter(string sql, out ArrayList movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable)It will run but with strict conditions.A sample:original code[code]strSQL = String.Format(&quot;SELECT * FROM path WHERE strPath = '{0}'&quot;, strPath);SQLiteResultSet results = m_db.Execute(strSQL);if (results.Rows.Count &gt; 0){&nbsp; int lPathId;&nbsp; Int32.TryParse(DatabaseUtility.Get(results, 0, &quot;idPath&quot;), out lPathId);&nbsp; return lPathId;}[/code]with EF LINQ query:[code]var query = (from sql in _connection.paths&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; where sql.idPath == pathID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; select sql).FirstOrDefault&lt;&gt;();if (query == null){&nbsp; return;}string path = query.strPath;[/code]</blockquote>

[QUOTE="regeszter, post: 1124919, member: 15874"] If Trakt uses the [URL='https://github.com/MediaPortal/MediaPortal-1/blob/master/mediaportal/Databases/Video/VideoDatabase.cs#L702']ExecuteSql() [/URL]or the [URL='https://github.com/MediaPortal/MediaPortal-1/blob/master/mediaportal/Databases/Video/VideoDatabase.cs#L707']ExecuteRuleSql() [/URL]it won't work because the EF can not run sql without declare the return type. If the Trakt uses API where the method run a "free hand sql" like GetMoviesByFilter(string sql, out ArrayList movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable) It will run but with strict conditions. A sample: original code [code]strSQL = String.Format("SELECT * FROM path WHERE strPath = '{0}'", strPath); SQLiteResultSet results = m_db.Execute(strSQL); if (results.Rows.Count > 0) { int lPathId; Int32.TryParse(DatabaseUtility.Get(results, 0, "idPath"), out lPathId); return lPathId; }[/code] with EF LINQ query: [code]var query = (from sql in _connection.paths where sql.idPath == pathID select sql).FirstOrDefault<>(); if (query == null) { return; } string path = query.strPath;[/code] [/QUOTE]

Verification