Getting Started

The Raiqub Expressions was split into 5 packages to better integrate with layered projects:

• Raiqub.Expressions
• Raiqub.Expressions.Reading
• Raiqub.Expressions.Writing
• Raiqub.Expressions.EntityFrameworkCore
• Raiqub.Expressions.Marten

Entity Framework Core

For projects going to use EF Core you need to follow these steps:

1. Add the required NuGet package(s) for the database provider you'll be using, such as Microsoft.EntityFrameworkCore.SqlServer:

.NET CLI

dotnet add package Microsoft.EntityFrameworkCore.SqlServer

Powershell

PM> Install-Package Microsoft.EntityFrameworkCore.SqlServer

Paket

paket add nuget Microsoft.EntityFrameworkCore.SqlServer

2. Add the Raiqub.Expressions.EntityFrameworkCore library from NuGet:

.NET CLI

dotnet add package Raiqub.Expressions.EntityFrameworkCore

Powershell

PM> Install-Package Raiqub.Expressions.EntityFrameworkCore

Paket

paket add nuget Raiqub.Expressions.EntityFrameworkCore

3. Register your DbContext by using AddDbContextFactory extension method (more details on EF Core documentation):

services.AddDbContextFactory<YourDbContext>();

1. Register the session and session factories using the following extension method:

services.AddEntityFrameworkExpressions()
    .AddSingleContext<YourDbContext>();

Marten

For projects going to use Marten you need to follow these steps:

1. Add the Raiqub.Expressions.Marten library from NuGet:

.NET CLI

dotnet add package Raiqub.Expressions.Marten

Powershell

PM> Install-Package Raiqub.Expressions.Marten

Paket

paket add nuget Raiqub.Expressions.Marten

2. Register the session and session factories using the following extension method:

services.AddMartenExpressions()
    .AddSingleContext();

Using

Inject the appropriate session interface (IDbQuerySession for read sessions, IDbSession for read and write sessions) into your services, and use it read and write from/to database.

C# classic

public class YourService
{
    private readonly IDbSession _dbSession;

    public YourService(IDbSession dbSession)
    {
        _dbSession = dbSession;
    }

    // ...
}

C# 12

public class YourService(IDbSession dbSession)
{
    // ...
}

You can also create specifications and query strategies. Here's an example of how to create a simple specification:

public class CustomerIsActive : Specification<Customer>
{
    public override Expression<Func<Customer, bool>> ToExpression()
    {
        return customer => customer.IsActive;
    }
}

And here's an example of how to use the specification with database session:

// Assuming 'session' is of type IDbSession or IDbQuerySession and has been injected
var query = session.Query(new CustomerIsActive());
var customers = await query.ToListAsync();