Hi, Naveen
Would you want to get the number of records in a particular SQLite table. If so, you can refer to the code below:
Create simple table by linq to sqlite:
public class person
{
[MaxLength(5), PrimaryKey]
public String name { get; set; }
[MaxLength(255)]
public String address { get; set; }
[MaxLength(11)]
public Double phone { get; set; }
}
Get the number of records:
var db = new SQLite.SQLiteConnection(dbPath);
var count = (from x in db.Table<person>() select x.name).Count();
You can see the link to get more information:
http://code.msdn.microsoft.com/windowsapps/Sqlite-For-Windows-8-Metro-2ec7a882
Best Wises!
<THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
Thanks
MSDN Community Support
Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.