Accelergreat.EntityFramework
3.1.0-beta
Prefix Reserved
See the version list below for details.
dotnet add package Accelergreat.EntityFramework --version 3.1.0-beta
NuGet\Install-Package Accelergreat.EntityFramework -Version 3.1.0-beta
<PackageReference Include="Accelergreat.EntityFramework" Version="3.1.0-beta" />
paket add Accelergreat.EntityFramework --version 3.1.0-beta
#r "nuget: Accelergreat.EntityFramework, 3.1.0-beta"
// Install Accelergreat.EntityFramework as a Cake Addin #addin nuget:?package=Accelergreat.EntityFramework&version=3.1.0-beta&prerelease // Install Accelergreat.EntityFramework as a Cake Tool #tool nuget:?package=Accelergreat.EntityFramework&version=3.1.0-beta&prerelease
uid: DeveloperDocumentation.Index
Ultra Fast Integration Tests
Accelergreat your tests.
Write and execute efficient and high-performance integration tests with ease. Accelergreat is a powerful .NET integration testing solution that automatically provisions and manages external dependencies for your tests, such as databases and APIs. Simplify your integration testing development process today.
Overview
Accelergreat is a new and innovative testing platform designed to make integration testing easier.
Integration tests are essential to ensuring your code works and stays working. However, they have been challenging to write and run quickly in the past, earning a reputation as a problem area in the development world.
With Accelergreat we intend to make this a problem of the past by doing all the hard work for you.
Accelergreat currently supports xUnit and plans to support other test runners in the future.
NuGet Packages
Accelergreat has a range of nuget packages for different feature sets:
Core packages
Package | |
---|---|
Accelergreat |
Referenced by all other Accelergreat packages. You can also reference this package to make your own custom Accelergreat components. |
Accelergreat.EntityFramework |
Core Entity Framework package referenced by Accelergreat's Entity Framework packages. |
Test framework packages
The test framework packages contain Accelergreat's test framework specific code. All other packages can be used interchangeably with each test framework package.
Framework | Package |
---|---|
xUnit | Accelergreat.Xunit |
Application packages
Accelergreat can run instances of your application.
Application type | Package |
---|---|
Web API | Accelergreat.Web |
Entity Framework packages
Accelergreat supports different database providers with the following entity framework packages. Accelergreat fully manages databse creation, reset between tests and cleanup at the end of the test run.
Provider | Package |
---|---|
Sql Server | Accelergreat.EntityFramework.SqlServer |
Postgre SQL | Accelergreat.EntityFramework.PostgreSql |
Sqlite | Accelergreat.EntityFramework.Sqlite |
In Memory | Accelergreat.EntityFramework.InMemory |
Future packages
Accelergreat is growing and open to requests. See Community & Support for how to get in touch.
Version Compatibility
Accelergreat follows Semantic Versioning 2.0.0 for releases.
Accelergreat keeps up-to date with dotnet releases and each major version will support all currently in-support versions of dotnet at the time of release.
Accelergreat will not introduce amy breaking public API changes for minor and patch versions.
Getting started (xUnit)
Getting startes is easy, whether you are starting a new test project, or want to migrate an existing one.
High level steps
Install
Accelergreat.Xunit
in your test project.dotnet add package Accelergreat.Xunit
Define components needed.
One of the core features of Accelergreat is the concept of components. A component represents a dependency for your tests. For example a database or a web API.
Accelergreat offers a range of pre-built components that can be extended for your specific needs. Or, you can build your own components by implementing the
IAccelergreatComponent
interface.To further understand components beyond what the getting started guide explains, the different components Accelergreat offers and to understand how to build your own components. See the dedicated guide on components.
Configure the environment
Configure the environment by registering components in a startup class that implements the
IAccelergreatStartup
interface. Just like how you setup dependency injection for your application, Accelergreat uses dependency injection for environment and component resolution for your tests.Write your tests! 🚀
Detailed steps (example use case)
Accelergreat has been designed with modularity and flexibility in mind. Whilst the example we have provided below may not match your specific use case, this example was chosen to best show the capabilities of Accelergreat. It should be an effective reference point for your own implementations.
Use case example: Database (Entity Framework SQL Server) + Web API integration test
To see other examples, you can look on our GitHub examples repo.
1. Install the required packages
Accelergreat.EntityFramework.SqlServer
dotnet add package Accelergreat.EntityFramework.SqlServer
Accelergreat.Web
dotnet add package Accelergreat.Web
2. Create the Accelergreat Components
In our example we only need two components. One for our SQL Server database, and one for our Web API.
Database component
Create a class that inherits from SqlServerEntityFrameworkDatabaseComponent
.
If you need to override any of the configuration values, see SqlServerEntityFrameworkConfiguration
for the defaults.
using Accelergreat.EntityFramework.SqlServer;
using Microsoft.Extensions.Configuration;
namespace ExampleTestProject.Components;
public class ExampleDatabaseComponent : SqlServerEntityFrameworkDatabaseComponent<ExampleDbContext>
{
public ExampleDatabaseComponent(IConfiguration configuration) : base(configuration)
{
}
}
Web API component
To interact with a .NET Web API in our integration tests, we need to create a Web App Component.
Web app components run an instance of the API defined by the Web API startup class passed into the generic type parameter. The following steps will set up a component for you:
- Create a class derived from
WebAppComponent
. - Inject the database connection string(s).
- [Optional] overriding appsettings.
Create the class derived from WebAppComponent
To create a Web App Component, create a class that inherits from WebAppComponent
and pass in your Web API startup class as the generic type parameter.
Using an API startup class
using System.Collections.Generic;
using Accelergreat.Web;
using Accelergreat.Web.Extensions;
using Microsoft.Extensions.Configuration;
namespace ExampleTestProject.Components;
public class ExampleApiComponent : WebAppComponent<ExampleApi.Startup>
{
protected override void BuildConfiguration(
IConfigurationBuilder configurationBuilder,
IReadOnlyAccelergreatEnvironmentPipelineData accelergreatEnvironmentPipelineData)
{
configurationBuilder.AddEntityFrameworkDatabaseConnectionString<ExampleDbContext>(
"ExampleConnectionStringName", accelergreatEnvironmentPipelineData);
}
}
Using an API program class
With the recent introduction of using the program.cs file to replace the startup class, you can now configure your application entirely in Program.cs . The Progam class is now in the global
App Domain as an internal class of the Api assembly. If you are using miniminal apis then you will have to expose InternalsVisibleTo
to the Test Assembly by editing the csproj file of the Api project:
<Project Sdk="Microsoft.NET.Sdk.Web">
...
<ItemGroup>
<InternalsVisibleTo Include="ExampleTestProject" />
</ItemGroup>
...
using System;
using System.Collections.Generic;
using Accelergreat.EntityFramework.Extensions;
using Accelergreat.Environments;
using Accelergreat.Web;
using GuestAndActivities.Data.Contexts;
using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.Configuration;
namespace ExampleTestProject.Components;
internal class ExampleApiComponent : WebAppComponent<Program>
{
protected override void BuildConfiguration(
IConfigurationBuilder configurationBuilder,
IReadOnlyAccelergreatEnvironmentPipelineData accelergreatEnvironmentPipelineData)
{
configurationBuilder.AddEntityFrameworkDatabaseConnectionString<ExampleDbContext>(
"ExampleConnectionStringName", accelergreatEnvironmentPipelineData);
}
}
Inject the database connection string(s)
In the examples above, we need to provide the database connection string to the Web API configuration a database connection string. We do this by overriding > BuildConfiguration
and calling configurationBuilder.AddEntityFrameworkDatabaseConnectionString
.
3. Create a Startup
class
Create a Startup
class in your test project that implements IAccelergreatStartup
.
we need to register our components. In the Configure
implementation, call builder.AddAccelergreatComponent
for each component as the type parameter.
Important The order in which components are initialized is defined by the order they are registered.
In our example, we need to initialize the database before the web API so that it can access the database connection string.
using Accelergreat.Xunit;
using ExampleTestProject.Components;
namespace ExampleTestProject;
public class Startup : IAccelergreatStartup
{
public void Configure(IAccelergreatBuilder builder)
{
builder.AddAccelergreatComponent<ExampleDatabaseComponent>();
builder.AddAccelergreatComponent<ExampleApiComponent>();
}
}
4. Write your first Accelegreat Integration Test
Now that we've got everything set up, we're going to write our first test.
For this example, we'll also be using FluentAssertions to keep our assertion code clean and easy to read. We'll also follow the Arrange Act Assert (AAA) pattern:
Arrange Set up and insert our test data
Act Call the API endpoint
Assert Validate that the response data is correct
Create a test that that inherits from AccelergreatXunitTest
.
using System.Threading.Tasks;
using Accelergreat.Environments.Pooling;
using Accelergreat.Xunit;
using ExampleTestProject.Components;
using FluentAssertions;
using Newtonsoft.Json;
using Xunit;
namespace ExampleTestProject.Tests;
public class ExampleTests : AccelergreatXunitTest
{
public ExampleTests(IAccelergreatEnvironmentPool environmentPool) : base(environmentPool)
{
}
[Fact]
public async Task Examples_GetById_ReturnsCorrectExample()
{
// Arrange
var exampleEntity = new ExampleEntity();
var dbContextFactory = GetComponent<ExampleDatabaseComponent>().DbContextFactory;
await using (var context = dbContextFactory.NewDbContext())
{
context.Set<ExampleEntity>().Add(exampleEntity);
await context.SaveChangesAsync();
}
var httpClient = GetComponent<ExampleApiComponent>().CreateClient();
// Act
var httpResponseMessage = await httpClient.GetAsync($"examples/{exampleEntity.Id}");
// Assert
httpResponseMessage.IsSuccessStatusCode.Should().BeTrue();
var body = await httpResponseMessage.Content.ReadAsStringAsync();
var result = JsonConvert.DeserializeObject<ExampleEntity>(body)!;
result.Id.Should().Be(exampleEntity.Id);
}
}
Extensibility
To further understand components beyond what the below getting started guide shows, read about all the different components Accelergreat offers and to understand how to build your own components. Please follow this guide.
Configuration
Accelergreat supports the overriding of configuration for managed external dependencies such as databases.
Accelergreat will read the following files in the root level of your test projects that have the CopyToOutputDirectory
setting set to Always
or PreserveNewest
:
accelergreat.json
accelergreat.{environment}.json
accelergreat.{environment}.json
is supported to allow you to have different configurations for your local machine and CI pipeline.
{environment}
is defined by setting an environment variable called ACCELERGREAT_ENVIRONMENT
.
A schema has been provided for the configuration files:
{
"$schema": "https://cdn.accelergreat.net/configuration/3.1.0-beta/schema.json#"
}
Example
The following configuration example shows how a premium developer has set their client ID and client secret, the developer is using the SQL Server Entity Framework component, the developer needs this to work slightly differently in their development and CI environments.
accelergreat.json
{ "$schema": "https://cdn.accelergreat.net/configuration/3.1.0-beta/schema.json", "License": { "ClientId": "YourClientId", "ClientSecret": "YourClientSecret } }
In the development environment, the developer wants to run their application in memory to be able to make use of Visual Studio debugging tools, and also make use of faster database reset speed by using the Transactions reset strategy.
accelergreat.development.json
{ "$schema": "https://cdn.accelergreat.net/configuration/3.1.0-beta/schema.json#", "Infrastructure": { // Custom config "Setup": "InMemory" }, "SqlServerEntityFramework": { "ResetStrategy": "Transactions" } }
In the CI environment, the developer wants to run their tests against the docker container that will be deployed to the hosted environments. In this case, the developer is using IL-trimming in the dotnet publish step of their Dockerfile.
accelergreat.CI.json
{ "$schema": "https://cdn.accelergreat.net/configuration/3.1.0-beta/schema.json#", "Infrastructure": { // Custom config "Setup": "Containers" }, "SqlServerEntityFramework": { "ResetStrategy": "SnapshotRollback" } }
On their local machine, the developer would set the ACCELERGREAT_ENVIRONMENT
environment variable with value development
, in the CI environment, the value would be CI
.
To see other examples, you can look on our GitHub examples repo.
Premium features
Parallel execution
One of the best features of Accelergreat is the ability to have your integration tests run in parallel, gaining massive performance improvements on multi-threaded machines.
It's as easy as config change. In your accelergreat configuration, make sure to add your client id and client secret:
{
"$schema": "https://cdn.accelergreat.net/configuration/3.1.0-beta/schema.json#",
"License": {
"ClientId": "YourClientId",
"ClientSecret": "YourClientSecret"
}
}
Given credentials are provided and authentication is successful, Accelergreat will automatically execute in parallel when the following criteria is met:
- More than 1 test collection is queued for execution.
parallelizeTestCollections
has not been set to false in yourxunit.runner.json
.maxParallelThreads
has not been set to 1 in yourxunit.runner.json
.
By default, Accelergreat uses the max threads allowed from the number of logical processors on the machine. You can override this by setting the maxParallelThreads
property in your xunit.runner.json
configuration file.
Database transactions
Resetting a databse between tests takes time. By default, Accelergreat uses the SnapshotRollback
reset strategy that creates a snapshot of the database before the tests run, and performs a rollback on the database between each test.
The time it takes to reset a database will greatly impact how long it takes the entire test suite to run.
With the premium Transactions
reset strategy, Accelergreat performs magic transaction management and all of your test database changes are made within a single transaction.
If your application uses transactions that is covered by your tests, you can enable TransactionOveriding
and Accelergreat will do even more magic behind the scenes to nest your transactions within Accelergreats transaction.
This paired with the Parallel execution feature will let your tests 'make the jump to light speed' - Han Solo.
Licensing / Pricing
Accelergreat is free to use.
A paid subscription is available for those that want to use premium features.
You can see the plans and pricing here.
Debugging Best Practices
Important When debugging tests in Visual Studio, do not click the stop button. Even if an exception occurs, click continue and let the test run through. If you click the stop button xunit will not run cleanup operations and dependencies will not be disposed of. This is especially important when debugging tests that use database dependencies.
Community & support
Email mail@accelergreat.net for direct communication and support requests.
Join our Discord channel.
See our GitHub.
See our FAQs.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 is compatible. |
-
net6.0
- Accelergreat (>= 3.1.0-beta)
- Microsoft.EntityFrameworkCore (>= 6.0.0)
- Microsoft.EntityFrameworkCore.Analyzers (>= 6.0.0)
-
net7.0
- Accelergreat (>= 3.1.0-beta)
- Microsoft.EntityFrameworkCore (>= 7.0.0)
- Microsoft.EntityFrameworkCore.Analyzers (>= 7.0.0)
-
net8.0
- Accelergreat (>= 3.1.0-beta)
- Microsoft.EntityFrameworkCore (>= 8.0.0)
- Microsoft.EntityFrameworkCore.Analyzers (>= 8.0.0)
-
net9.0
- Accelergreat (>= 3.1.0-beta)
- Microsoft.EntityFrameworkCore (>= 9.0.0-rc.2.24474.1)
- Microsoft.EntityFrameworkCore.Analyzers (>= 9.0.0-rc.2.24474.1)
NuGet packages (4)
Showing the top 4 NuGet packages that depend on Accelergreat.EntityFramework:
Package | Downloads |
---|---|
Accelergreat.EntityFramework.SqlServer
Accelergreat Sql Server Entity Framework testing tools. Accelergreat is an integration testing package that helps to simplify and speed up the writing of integration tests, as well as taking away the challenging task of managing external dependencies. |
|
Accelergreat.EntityFramework.PostgreSql
Accelergreat PostgreSql (Npsql) Entity Framework testing tools. Accelergreat is an integration testing package that helps to simplify and speed up the writing of integration tests, as well as taking away the challenging task of managing external dependencies. |
|
Accelergreat.EntityFramework.InMemory
Accelergreat In-Memory Entity Framework testing tools. Accelergreat is an integration testing package that helps to simplify and speed up the writing of integration tests, as well as taking away the challenging task of managing external dependencies. |
|
Accelergreat.EntityFramework.Sqlite
Accelergreat Sqlite Entity Framework testing tools. Accelergreat is an integration testing package that helps to simplify and speed up the writing of integration tests, as well as taking away the challenging task of managing external dependencies. |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
3.1.1-beta | 147 | 11/6/2024 |
3.1.0-beta | 75 | 11/6/2024 |
3.0.0 | 780 | 7/13/2024 |
3.0.0-beta.2 | 599 | 2/12/2024 |
3.0.0-beta.1 | 70 | 2/9/2024 |
2.3.0-beta | 590 | 1/23/2024 |
2.2.7 | 3,203 | 9/1/2023 |
2.2.6-beta | 339 | 9/1/2023 |
2.2.5-beta | 333 | 9/1/2023 |
2.2.4 | 400 | 9/1/2023 |
2.2.3-beta | 1,148 | 3/26/2023 |
2.2.2-beta | 430 | 3/26/2023 |
2.2.1-beta | 420 | 3/25/2023 |
2.2.0-beta | 405 | 3/25/2023 |
2.1.0-beta | 389 | 3/24/2023 |
2.0.0 | 3,462 | 3/8/2023 |
2.0.0-beta02 | 429 | 3/1/2023 |
2.0.0-beta01 | 445 | 2/1/2023 |
1.7.2-beta | 615 | 10/21/2022 |
1.7.1 | 3,195 | 10/18/2022 |
1.7.0 | 1,498 | 10/18/2022 |
1.7.0-beta | 595 | 8/28/2022 |
1.6.4 | 1,844 | 8/27/2022 |
1.6.3-beta | 1,367 | 8/14/2022 |
1.6.1-beta | 678 | 8/12/2022 |
1.6.0-beta | 580 | 7/18/2022 |
1.5.6-beta | 734 | 7/4/2022 |
1.5.4-beta | 668 | 6/25/2022 |
1.5.3-beta | 572 | 6/24/2022 |
1.5.2-beta | 594 | 6/23/2022 |
1.5.1-beta | 563 | 6/20/2022 |
1.5.0-beta | 565 | 6/20/2022 |
1.4.6 | 9,654 | 6/8/2022 |
1.4.5-beta | 581 | 5/30/2022 |
1.4.4-beta | 551 | 4/24/2022 |
1.4.3-beta | 594 | 4/23/2022 |
1.4.2 | 4,239 | 3/15/2022 |
1.4.1-beta | 713 | 3/2/2022 |
1.4.0-beta | 582 | 2/17/2022 |
1.3.6 | 1,907 | 1/30/2022 |
1.3.5 | 1,748 | 1/30/2022 |
1.3.2-beta | 608 | 1/27/2022 |
1.3.1-alpha | 614 | 1/25/2022 |
1.3.0-alpha | 612 | 1/25/2022 |
1.2.0 | 1,733 | 1/23/2022 |