/// <summary> /// Query a single article from a storehouse /// </summary> /// <param name="code">Publication code to query</param> /// <param name="meps">MEPS id to query</param> /// <param name="storehouse">Storehouse to query</param> /// <returns>A single article</returns> public static WOLArticle QueryArticle(string code, NavStruct meps, string storehouse) { string number = meps.ToString(); var db = new SQLiteConnection(storehouse); var query = (from a in db.Table <WOLArticle>() where (a.PublicationCode.Equals(code) && a.ArticleNumber.Equals(number)) select a).ToList(); return(query.FirstOrDefault()); }