本文整理汇总了C#中SQLite.SQLiteConnection.GetTableInfo方法的典型用法代码示例。如果您正苦于以下问题：C# SQLite.SQLiteConnection.GetTableInfo方法的具体用法？C# SQLite.SQLiteConnection.GetTableInfo怎么用？C# SQLite.SQLiteConnection.GetTableInfo使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLite.SQLiteConnection的用法示例。
在下文中一共展示了SQLite.SQLiteConnection.GetTableInfo方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ViewDidLoad
public override void ViewDidLoad()
{
base.ViewDidLoad ();
//TODO:: Fetch and display data.
var docsFolder = System.Environment.GetFolderPath (System.Environment.SpecialFolder.MyDocuments);
var pathToDatabase = System.IO.Path.Combine (docsFolder, "db_sqlnet.db");
//Check if the table exists.
try {
var connection = new SQLite.SQLiteConnection (pathToDatabase);
var info = connection.GetTableInfo ("GcmMessage");
if (!info.Any ()) {
//Fetch data from the GCM Table
List<GcmMessage> gcmMessageList = connection.Table<GcmMessage> ().ToList ();
foreach (GcmMessage gcmMessage in gcmMessageList) {
//Add Items to the list
messagesList.Add (new GcmMessage () {
TextFrom = gcmMessage.TextFrom,
BundleString = gcmMessage.BundleString,
DateString = gcmMessage.DateString,
TextMessage = gcmMessage.TextMessage
});
Console.Write("PushNotification", " Bundle String " + gcmMessage.BundleString);
}
}else{
Console.Write ("DB data is null ...");
}
} catch (SQLite.SQLiteException ex) {
Console.Write ("Error fetching data ..." + ex.Message);
}
this.NavigationItem.SetRightBarButtonItem(
new UIBarButtonItem(UIImage.FromFile("icon.png")
, UIBarButtonItemStyle.Plain
, (sender,args) => {
// button was clicked
})
, true);
}示例2: initializeDatabase
protected void initializeDatabase()
{
var docsFolder = System.Environment.GetFolderPath (System.Environment.SpecialFolder.MyDocuments);
var pathToDatabase = System.IO.Path.Combine (docsFolder, "db_sqlnet.db");
using (var connection= new SQLite.SQLiteConnection(pathToDatabase))
{
var info = connection.GetTableInfo ("GcmMessage");
if (!info.Any ()) {
connection.CreateTable<GcmMessage> ();
Console.WriteLine ("Creating database ....");
} else {
Console.WriteLine ("Database exists");
}
}
}