Exemple #1
0
        /// <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());
        }