1 从NuGet包中添加
2.github源码地址
https://github.com/praeclarum/sqlite-net
C# 操作代码
private void Button_Click_3(object sender, RoutedEventArgs e)
{
string databasePath = System.AppDomain.CurrentDomain.BaseDirectory + “db/mydb.db”;
var db = new SQLiteConnection(databasePath);
db.CreateTable
AddStock(db, “aaa”);
AddStock(db, “Aaa”);
AddStock(db, “ABa”);
AddStock(db, “AaaC”);
var query = db.Table
foreach (var stock in query)
Debug.WriteLine(“Stock: ” + stock.Symbol);
}
public static void AddStock(SQLiteConnection db, string symbol)
{
var stock = new Stock()
{
Symbol = symbol
};
db.Insert(stock);
// Console.WriteLine(“{0} == {1}”, stock.Symbol, stock.Id);
}
3.默认查询的时候查不出来数据,最后发现是类中没有写{get;set;}
public class VisionTemplate
{
public int ID { get; set; }
public string TemplateName { get; set; }
public string Manufacturer { get; set; }
public string Description { get; set; }
}
注意VisionTemplate必须为属性类型,否则datagrid不显示内容。这个问题我查了好久才发现
List
DG_VisionTemplate.ItemsSource = query;Original: https://blog.csdn.net/easyboot/article/details/121028510
Author: easyboot
Title: C# 操作SQLite的工具SQLite-PCL
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/816645/
转载文章受原作者版权保护。转载请注明原作者出处!