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,//数据库类型
        IsAutoCloseConnection = true//不设成true要手动close
    }, db => {
        db.Aop.OnLogExecuting = (sql, pars) =>
        {

        };
    });
}

　　

第三步：创建关联表格

[SugarTable("dt_article", "文章", IsDisabledDelete = false)]
public class Article
{
    [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
    public int Id { get; set; }
    public string Title { get; set; }
}

　　

第四步：调用

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