.net8 blazor auto模式很爽（五）读取sqlite并显示（2）

在BlazorApp1增加文件夹data，里面增加类dbcont

using SharedLibrary.Models;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;
 
namespace BlazorApp1.data
{
    public class dbcont : DbContext
    {
 
        public dbcont(DbContextOptions options)
            : base(options)
        {
        }
 
        public virtual DbSet<employee> employee { get; set; }
 
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            // 配置主键
           // modelBuilder.Entity().HasKey(e => e.Id);
 
            // 或者对于没有主键的实体（仅适用于特定场景）
             modelBuilder.Entity().HasNoKey();
 
            base.OnModelCreating(modelBuilder);
        }
 
    }
}

在BlazorApp1的Program增加下面的代码：

//新增2 添加数据库连接
// 初始化 SQLite 提供程序
string connectionString = "Data Source=cellsmanage6.db3";
builder.Services.AddDbContext(options =>
    options.UseSqlite(connectionString, b => b.UseRelationalNulls(true)));
//新增2 结束
builder.Services.AddScoped();

在SharedLibrary的Repositories增加IEmployeeRepository

using SharedLibrary.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace SharedLibrary.Repositories
{
    public interface IEmployeeRepository
    {
        Task> GetEmployeesAsync();
 
    }
}

在Client的Services里增加EmployeeService

using SharedLibrary.Models;
using SharedLibrary.Repositories;
using System.Net.Http.Json;
 
namespace BlazorApp1.Client.Services
{
    public class EmployeeService: IEmployeeRepository
    {
        private readonly HttpClient _httpClient;
 
        public EmployeeService(HttpClient httpClient)
        {
            _httpClient = httpClient;
        }
 
        public async Task<List<employee>> GetEmployeesAsync()
        {
            return await _httpClient.GetFromJsonAsync>("api/Employee/Getemployee");
        }
    }
}

在Client的Program里面增加

builder.Services.AddScoped();

在Client的_Imports增加

@inject IEmployeeRepository EmployeeService

然后我们运行程序，得到了数据库中的数据