Ends in:
3 DAYS
21 HRS
31 MIN
28 SEC
Ends in:
3 D
21 H
31 M
28 S

Entity Framework Core Integration

This document explains how to integrate EF Core as an ORM provider to ABP based applications and how to configure it.

Installation

Volo.Abp.EntityFrameworkCore is the main nuget package for the EF Core integration. Install it to your project (for a layered application, to your data/infrastructure layer):

Install-Package Volo.Abp.EntityFrameworkCore

Then add AbpEntityFrameworkCoreModule module dependency (DependsOn attribute) to your module:

using Volo.Abp.EntityFrameworkCore;
using Volo.Abp.Modularity;

namespace MyCompany.MyProject
{
    [DependsOn(typeof(AbpEntityFrameworkCoreModule))]
    public class MyModule : AbpModule
    {
        //...
    }
}

Note: Instead, you can directly download a startup template with EF Core pre-installed.

Database Management System Selection

Entity Framework Core supports various database management systems (see all). ABP framework and this document doesn't depend on any specific DBMS.

If you are creating a reusable application module, avoid to depend on a specific DBMS package. However, in a final application you eventually will select a DBMS.

See Switch to Another DBMS for Entity Framework Core document to learn how to switch the DBMS.

Creating DbContext

You can create your DbContext as you normally do. It should be derived from AbpDbContext<T> as shown below:

using Microsoft.EntityFrameworkCore;
using Volo.Abp.EntityFrameworkCore;

namespace MyCompany.MyProject
{
    public class MyDbContext : AbpDbContext<MyDbContext>
    {
        //...your DbSet properties here

        public MyDbContext(DbContextOptions<MyDbContext> options)
            : base(options)
        {
        }
    }
}

About the EF Core Fluent Mapping

The application startup template has been configured to use the EF Core fluent configuration API to map your entities to your database tables.

You can still use the data annotation attributes (like [Required]) on the properties of your entity while the ABP documentation generally follows the fluent mapping API approach. It is up to you.

ABP Framework has some base entity classes and conventions (see the entities document) and it provides some useful extension methods to configure the properties inherited from the base entity classes.

ConfigureByConvention Method

ConfigureByConvention() is the main extension method that configures all the base properties and conventions for your entities. So, it is a best practice to call this method for all your entities, in your fluent mapping code.

Example: Assume that you've a Book entity derived from AggregateRoot<Guid> base class:

public class Book : AuditedAggregateRoot<Guid>
{
    public string Name { get; set; }
}

You can override the OnModelCreating method in your DbContext and configure the mapping as shown below:

protected override void OnModelCreating(ModelBuilder builder)
{
    //Always call the base method
    base.OnModelCreating(builder);

    builder.Entity<Book>(b =>
    {
        b.ToTable("Books");

        //Configure the base properties
        b.ConfigureByConvention(); 

        //Configure other properties (if you are using the fluent API)
        b.Property(x => x.Name).IsRequired().HasMaxLength(128);
    });
}
  • Calling b.ConfigureByConvention() is important here to properly configure the base properties.
  • You can configure the Name property here or you can use the data annotation attributes (see the EF Core document).

While there are many extension methods to configure your base properties, ConfigureByConvention() internally calls them if necessary. So, it is enough to call it.

Configure the Connection String Selection

If you have multiple databases in your application, you can configure the connection string name for your DbContext using the [ConnectionStringName] attribute. Example:

[ConnectionStringName("MySecondConnString")]
public class MyDbContext : AbpDbContext<MyDbContext>
{
    
}

If you don't configure, the Default connection string is used. If you configure a specific connection string name, but not define this connection string name in the application configuration then it fallbacks to the Default connection string (see the connection strings document for more information).

Registering DbContext To Dependency Injection

Use AddAbpDbContext method in your module to register your DbContext class for dependency injection system.

using Microsoft.Extensions.DependencyInjection;
using Volo.Abp.EntityFrameworkCore;
using Volo.Abp.Modularity;

namespace MyCompany.MyProject
{
    [DependsOn(typeof(AbpEntityFrameworkCoreModule))]
    public class MyModule : AbpModule
    {
        public override void ConfigureServices(ServiceConfigurationContext context)
        {
            context.Services.AddAbpDbContext<MyDbContext>();

            //...
        }
    }
}

Add Default Repositories

ABP can automatically create default generic repositories for the entities in your DbContext. Just use AddDefaultRepositories() option on the registration:

services.AddAbpDbContext<MyDbContext>(options =>
{
    options.AddDefaultRepositories();
});

This will create a repository for each aggregate root entity (classes derived from AggregateRoot) by default. If you want to create repositories for other entities too, then set includeAllEntities to true:

services.AddAbpDbContext<MyDbContext>(options =>
{
    options.AddDefaultRepositories(includeAllEntities: true);
});

Then you can inject and use IRepository<TEntity, TPrimaryKey> in your services. Assume that you have a Book entity with Guid primary key:

public class Book : AggregateRoot<Guid>
{
    public string Name { get; set; }

    public BookType Type { get; set; }
}

(BookType is a simple enum here) And you want to create a new Book entity in a domain service:

public class BookManager : DomainService
{
    private readonly IRepository<Book, Guid> _bookRepository;

    //inject default repository to the constructor
    public BookManager(IRepository<Book, Guid> bookRepository)
    {
        _bookRepository = bookRepository;
    }

    public async Task<Book> CreateBook(string name, BookType type)
    {
        Check.NotNullOrWhiteSpace(name, nameof(name));

        var book = new Book
        {
            Id = GuidGenerator.Create(),
            Name = name,
            Type = type
        };

        //Use a standard repository method
        await _bookRepository.InsertAsync(book);

        return book;
    }
}

This sample uses InsertAsync method to insert a new entity to the database.

Add Custom Repositories

Default generic repositories are powerful enough in most cases (since they implement IQueryable). However, you may need to create a custom repository to add your own repository methods. Assume that you want to delete all books by type.

It's suggested to define an interface for your custom repository:

public interface IBookRepository : IRepository<Book, Guid>
{
    Task DeleteBooksByType(BookType type);
}

You generally want to derive from the IRepository to inherit standard repository methods. However, you don't have to. Repository interfaces are defined in the domain layer of a layered application. They are implemented in the data/infrastructure layer (EntityFrameworkCore project in a startup template).

Example implementation of the IBookRepository interface:

public class BookRepository : EfCoreRepository<BookStoreDbContext, Book, Guid>, IBookRepository
{
    public BookRepository(IDbContextProvider<BookStoreDbContext> dbContextProvider)
        : base(dbContextProvider)
    {
    }

    public async Task DeleteBooksByType(BookType type)
    {
        await DbContext.Database.ExecuteSqlRawAsync(
            $"DELETE FROM Books WHERE Type = {(int)type}"
        );
    }
}

Now, it's possible to inject the IBookRepository and use the DeleteBooksByType method when needed.

Override the Default Generic Repository

Even if you create a custom repository, you can still inject the default generic repository (IRepository<Book, Guid> for this example). Default repository implementation will not use the class you have created.

If you want to replace default repository implementation with your custom repository, do it inside the AddAbpDbContext options:

context.Services.AddAbpDbContext<BookStoreDbContext>(options =>
{
    options.AddDefaultRepositories();
    
    //Replaces IRepository<Book, Guid>
    options.AddRepository<Book, BookRepository>();
});

This is especially important when you want to override a base repository method to customize it. For instance, you may want to override DeleteAsync method to delete a specific entity in a more efficient way:

public override async Task DeleteAsync(
    Guid id,
    bool autoSave = false,
    CancellationToken cancellationToken = default)
{
    //TODO: Custom implementation of the delete method
}

Access to the EF Core API

In most cases, you want to hide EF Core APIs behind a repository (this is the main purpose of the repository pattern). However, if you want to access the DbContext instance over the repository, you can use GetDbContext() or GetDbSet() extension methods. Example:

public class BookService
{
    private readonly IRepository<Book, Guid> _bookRepository;

    public BookService(IRepository<Book, Guid> bookRepository)
    {
        _bookRepository = bookRepository;
    }

    public void Foo()
    {
        DbContext dbContext = _bookRepository.GetDbContext();
        DbSet<Book> books = _bookRepository.GetDbSet();
    }
}
  • GetDbContext returns a DbContext reference instead of BookStoreDbContext. You can cast it, however in most cases you don't need it.

Important: You must reference to the Volo.Abp.EntityFrameworkCore package from the project you want to access to the DbContext. This breaks encapsulation, but this is what you want in that case.

Extra Properties & Object Extension Manager

Extra Properties system allows you to set/get dynamic properties to entities those implement the IHasExtraProperties interface. It is especially useful when you want to add custom properties to the entities defined in an application module, when you use the module as package reference.

By default, all the extra properties of an entity are stored as a single JSON object in the database.

Entity extension system allows you to to store desired extra properties in separate fields in the related database table. For more information about the extra properties & the entity extension system, see the following documents:

This section only explains the EF Core related usage of the ObjectExtensionManager.

ObjectExtensionManager.Instance

ObjectExtensionManager implements the singleton pattern, so you need to use the static ObjectExtensionManager.Instance to perform all the operations.

MapEfCoreProperty

MapEfCoreProperty is a shortcut extension method to define an extension property for an entity and map to the database.

Example: Add Title property (database field) to the IdentityRole entity:

ObjectExtensionManager.Instance
    .MapEfCoreProperty<IdentityRole, string>(
        "Title",
        builder => { builder.HasMaxLength(64); }
    );

If the related module has implemented this feature (by using the ConfigureEfCoreEntity explained below), then the new property is added to the model. Then you need to run the standard Add-Migration and Update-Database commands to update your database to add the new field.

MapEfCoreProperty method must be called before using the related DbContext. It is a static method. The best way is to use it in your application as earlier as possible. The application startup template has a YourProjectNameEntityExtensions class that is safe to use this method inside.

ConfigureEfCoreEntity

If you are building a reusable module and want to allow application developers to add properties to your entities, you can use the ConfigureEfCoreEntity extension method in your entity mapping. However, there is a shortcut extension method ConfigureObjectExtensions that can be used while configuring the entity mapping:

builder.Entity<YourEntity>(b =>
{
    b.ConfigureObjectExtensions();
    //...
});

If you call ConfigureByConvention() extension method (like b.ConfigureByConvention() for this example), ABP Framework internally calls the ConfigureObjectExtensions method. It is a best practice to use the ConfigureByConvention() method since it also configures database mapping for base properties by convention.

See the "ConfigureByConvention Method" section above for more information.

Advanced Topics

Set Default Repository Classes

Default generic repositories are implemented by EfCoreRepository class by default. You can create your own implementation and use it for all the default repository implementations.

First, define your default repository classes like that:

public class MyRepositoryBase<TEntity>
    : EfCoreRepository<BookStoreDbContext, TEntity>
      where TEntity : class, IEntity
{
    public MyRepositoryBase(IDbContextProvider<BookStoreDbContext> dbContextProvider) 
        : base(dbContextProvider)
    {
    }
}

public class MyRepositoryBase<TEntity, TKey>
    : EfCoreRepository<BookStoreDbContext, TEntity, TKey>
    where TEntity : class, IEntity<TKey>
{
    public MyRepositoryBase(IDbContextProvider<BookStoreDbContext> dbContextProvider)
        : base(dbContextProvider)
    {
    }
}

First one is for entities with composite keys, second one is for entities with single primary key.

It's suggested to inherit from the EfCoreRepository class and override methods if needed. Otherwise, you will have to implement all the standard repository methods manually.

Now, you can use SetDefaultRepositoryClasses option:

context.Services.AddAbpDbContext<BookStoreDbContext>(options =>
{
    options.SetDefaultRepositoryClasses(
        typeof(MyRepositoryBase<,>),
        typeof(MyRepositoryBase<>)
    );
    
    //...
});

Set Base DbContext Class or Interface for Default Repositories

If your DbContext inherits from another DbContext or implements an interface, you can use that base class or interface as DbContext for default repositories. Example:

public interface IBookStoreDbContext : IEfCoreDbContext
{
    DbSet<Book> Books { get; }
}

IBookStoreDbContext is implemented by the BookStoreDbContext class. Then you can use generic overload of the AddDefaultRepositories:

context.Services.AddAbpDbContext<BookStoreDbContext>(options =>
{
    options.AddDefaultRepositories<IBookStoreDbContext>();
    //...
});

Now, your custom BookRepository can also use the IBookStoreDbContext interface:

public class BookRepository : EfCoreRepository<IBookStoreDbContext, Book, Guid>, IBookRepository
{
    //...
}

One advantage of using an interface for a DbContext is then it will be replaceable by another implementation.

Replace Other DbContextes

Once you properly define and use an interface for DbContext, then any other implementation can replace it using the ReplaceDbContext option:

context.Services.AddAbpDbContext<OtherDbContext>(options =>
{
    //...
    options.ReplaceDbContext<IBookStoreDbContext>();
});

In this example, OtherDbContext implements IBookStoreDbContext. This feature allows you to have multiple DbContext (one per module) on development, but single DbContext (implements all interfaces of all DbContexts) on runtime.

See Also

Contributors


Last updated: March 28, 2020 Edit this page on GitHub

Was this page helpful?

Please make a selection.

To help us improve, please share your reason for the negative feedback in the field below.

Please enter a note.

Thank you for your valuable feedback!

Please note that although we cannot respond to feedback, our team will use your comments to improve the experience.

In this document
Community Talks

What’s New with .NET 9 & ABP 9?

21 Nov, 17:00
Online
Watch the Event
Mastering ABP Framework Book
Mastering ABP Framework

This book will help you gain a complete understanding of the framework and modern web application development techniques.

Learn More