SqlSugarCore 操作 SQLite
下載SQLite工具,點檢下載
第一步:安裝SqlSugarCore

第二步:初始化SqlSugarCore
public class DBUtil
{
public static SqlSugarScope Db = new SqlSugarScope(new ConnectionConfig()
{
ConnectionString = $"DataSource={AppDomain.CurrentDomain.SetupInformation.ApplicationBase?.TrimEnd('\\')}\\db\\microdb2.db",//連接符字串
DbType = DbType.Sqlite,//數(shù)據(jù)庫類型
IsAutoCloseConnection = true//不設(shè)成true要手動close
}, db => {
db.Aop.OnLogExecuting = (sql, pars) =>
{
};
});
}
第三步:創(chuàng)建關(guān)聯(lián)表格
[SugarTable("dt_article", "文章", IsDisabledDelete = false)]
public class Article
{
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
public int Id { get; set; }
public string Title { get; set; }
}
第四步:調(diào)用
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
Article s1 = new Article()
{
Title = "張三"
};
DBUtil.Db.Insertable(s1).ExecuteCommand();
List<Article> list = DBUtil.Db.Queryable<Article>().ToList();
}
}
示例下載:WpfSQLite.rar

浙公網(wǎng)安備 33010602011771號