sqlite efcore

最新推荐文章于 2025-03-20 10:42:24 发布

寒冰最强

最新推荐文章于 2025-03-20 10:42:24 发布

阅读量550

点赞数

本文链接：https://blog.youkuaiyun.com/adc_god/article/details/78245779

版权

本文介绍了一个使用SQLite数据库的应用实例，包括如何配置SQLite作为数据存储、定义数据模型以及基本的数据库操作，如添加新记录和查询现有记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using Microsoft.Data.Entity;

namespace UnicornClicker.UWP.Models
{
class UnicornClickerContext : DbContext
{
public DbSet<GameScore> GameScores { get; set; }

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlite("Filename=UnicornClicker.db");
}
}
}

using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;

namespace ConsoleApp.SQLite
{
public class BloggingContext : DbContext
{
public DbSet<Blog> Blogs { get; set; }
public DbSet<Post> Posts { get; set; }

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseSqlite("Data Source=blogging.db");
}
}

public class Blog
{
public int BlogId { get; set; }
public string Url { get; set; }

public List<Post> Posts { get; set; }
}

public class Post
{
public int PostId { get; set; }
public string Title { get; set; }
public string Content { get; set; }

public int BlogId { get; set; }
public Blog Blog { get; set; }
}

}

<Grid Background="{ThemeResource ApplicationPageBackgroundThemeBrush}">
<StackPanel>
<TextBox Name="NewBlogUrl"></TextBox>
<Button Click="Add_Click">Add</Button>
<ListView Name="Blogs">
<ListView.ItemTemplate>
<DataTemplate>
<TextBlock Text="{Binding Url}" />
</DataTemplate>
</ListView.ItemTemplate>
</ListView>
</StackPanel>
</Grid>
</Page>

public sealed partial class MainPage : Page
{
public MainPage()
{
this.InitializeComponent();
}

private void Page_Loaded(object sender, RoutedEventArgs e)
{
using (var db = new BloggingContext())
{
Blogs.ItemsSource = db.Blogs.ToList();
}
}

private void Add_Click(object sender, RoutedEventArgs e)
{
using (var db = new BloggingContext())
{
var blog = new Blog { Url = NewBlogUrl.Text };
db.Blogs.Add(blog);
db.SaveChanges();

Blogs.ItemsSource = db.Blogs.ToList();
}
}
}