BlazingPizza Blazor应用程序使用Entity Framework Core和SQLite本地数据库。可以通过在appsettings.json文件中查找'DefaultConnection”字段来确认使用的数据库。以下是在Blazor应用程序中使用SQLite本地数据库的示例:
Microsoft.EntityFrameworkCore.Sqlite
Microsoft.EntityFrameworkCore.Tools
Microsoft.EntityFrameworkCore.Design
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
public void ConfigureServices(IServiceCollection services)
{
// 添加配置选项
services.AddOptions();
// 引入配置选项
IConfiguration configuration = services.BuildServiceProvider().GetService();
// 添加DbContext
services.AddDbContext(options =>
options.UseSqlite(configuration.GetConnectionString("DefaultConnection")));
// ...
}
using Microsoft.EntityFrameworkCore;
public class AppDbContext : DbContext
{
public AppDbContext(DbContextOptions options) : base(options) { }
public DbSet Pizzas { get; set; }
// 其他DbSet...
}
public class Pizza
{
public int Id { get; set; }
public string Name { get; set; }
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity()
.HasKey(p => p.Id);
modelBuilder.Entity()
.Property(p => p.Name)
.IsRequired()
.HasMaxLength(50);
// 其他配置...
}
@inject AppDbContext db
@code {
private List pizzas;
protected override async Task OnInitializedAsync()
{
pizzas = await db.Pizzas.ToListAsync();
}
}
这就是在Blazor中使用SQLite本地数据库的简单示例。