How to retrieve result from sqlite view in windows app 8
-
I have created a view using sqlite manager (add-on in firefox) and the view result is more than 6,000 records. I have used this database in wp8 app, when I retrieve data from tables, It works but when I query from view within wp8 app it doesn't retrieve any result. I don't know if its possible to have views / or retrieve result set from view. I have below code for retrieving data from view.
public List<ArabicTextWithTranslation> getArabicTextWithTranslation(Chapter chapter)
{
List<ArabicTextWithTranslation> list = dbConn.Query<ArabicTextWithTranslation>("select * from ArabicTextWithTranslation ").ToList();//where ChapterID = " + chapter.SuraID).ToList();
foreach (ArabicTextWithTranslation li in list)
{
li.AyaID = ConvertToArabicIndicString(Convert.ToInt16(li.AyaID));
}
return list;
}"ArabicTextWithTranslation" is view in sqlite. Everything works in SQlite, but it doesn't retrieve data in windows app 8. Thanks!
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan