将Abp的UnitTest中的InMemory改为SQLite in memory

最新推荐文章于 2023-03-17 09:26:51 发布

weixin_30483495

最新推荐文章于 2023-03-17 09:26:51 发布

阅读量184

点赞数

CC 4.0 BY-SA版权

文章标签：数据库测试

原文链接：http://www.cnblogs.com/hahaxi/p/11135280.html

本文详细介绍如何在项目中集成SQLite数据库与Entity Framework Core，并通过示例代码展示如何配置及使用，实现数据库的创建与基本操作。

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

添加nuget包

Microsoft.EntityFrameworkCore.Sqlite

添加ServiceCollectionRegistrarSqlite

 public static class ServiceCollectionRegistrarSqlite
    {
        public static void Register(IIocManager iocManager)
        {
            var services = new ServiceCollection();

            IdentityRegistrar.Register(services);

            services.AddEntityFrameworkSqlite();

            var serviceProvider = WindsorRegistrationHelper.CreateServiceProvider(iocManager.IocContainer, services);

            var builder = new DbContextOptionsBuilder<DeviceManageSystemDbContext>();


            var inMemorySqlite = new SqliteConnection("Data Source=:memory:");
            builder.UseSqlite(inMemorySqlite);

            iocManager.IocContainer.Register(
                Component
                    .For<DbContextOptions<DeviceManageSystemDbContext>>()
                    .Instance(builder.Options)
                    .LifestyleSingleton()
            );

            inMemorySqlite.Open();
            new DeviceManageSystemDbContext(builder.Options).Database.EnsureCreated();
        }
    }

添加DeviceManageSystemTestModuleSqlite

复制DeviceManageSystemTestModule，修改

 [DependsOn(
        typeof(DeviceManageSystemApplicationModule),
        typeof(DeviceManageSystemEntityFrameworkModule),
        typeof(AbpTestBaseModule)
        )]
    public class DeviceManageSystemTestModuleSqlite : AbpModule
    {
     public override void Initialize()
        {
            ServiceCollectionRegistrarSqlite.Register(IocManager);
        }
    }

修改DeviceManageSystemTestBase

public abstract class DeviceManageSystemTestBase : AbpIntegratedTestBase<DeviceManageSystemTestModuleSqlite>
{

}

转载于:https://www.cnblogs.com/hahaxi/p/11135280.html