Firebend.AutoCrud.EntityFramework

Firebend Auto Crud extension pack for Entity Framework CRUD operations


Keywords
autocrud, crud, ef, entity, firebend, framework
License
MIT
Install
Install-Package Firebend.AutoCrud.EntityFramework -Version 13.0.1

Documentation

Build, Test, and Release

Firebend.AutoCrud

A framework that provides Create Read Update Delete (CRUD) dotnet core services!

"Extension Packs" are provided to support:

  • Entity Framework
  • Mongo DB
  • Sharded entity framework sql server contexts
  • ASP.NET core controllers
    • HTTP GET, PUT, POST, PATCH RESTFul service endpoints
  • Domain Events
  • Change Tracking ( Entity Change Audits )
    • Ability to persist entity changes to mongo db or an entity framework context
  • Exporting entities to csv and spreadsheets

Firebend Nuget Page

https://nuget.org/profiles/firebend

Getting Started

The following lessons walk you through configuring a basic version of autocrud for your app, then progressively adding more advanced features. We'll build off of the dotnet WeatherForecast sample project from the dotnet documentation.

Project Setup

  1. Install dotnet core
    brew install dotnet
  2. Create a new webapi project
    dotnet new webapi -o AutoCrudSampleApi
    cd AutoCrudSampleApi
    
    dotnet dev-certs https --trust # i had to run this (and check "Disable HTTPS verification" in Postman) to get `dotnet watch run` to work

This creates a new dotnet core sample project, based on the WeatherForcast sample by Microsoft.

You should have a model in WeatherForcast.cs and a controller in Controllers/WeatherForcastController.cs

At this point, you should be able to run the project

dotnet watch run

and hit the api at http://localhost:5000/weatherforecast to see a list of forecasts

[
    {
        "date": "2020-12-22T14:12:33.703633-06:00",
        "temperatureC": 31,
        "temperatureF": 87,
        "summary": "Freezing"
    },
    {
        "date": "2020-12-23T14:12:33.703653-06:00",
        "temperatureC": 20,
        "temperatureF": 67,
        "summary": "Warm"
    },
    {
        "date": "2020-12-24T14:12:33.703653-06:00",
        "temperatureC": -9,
        "temperatureF": 16,
        "summary": "Balmy"
    },
    {
        "date": "2020-12-25T14:12:33.703654-06:00",
        "temperatureC": 49,
        "temperatureF": 120,
        "summary": "Warm"
    },
    {
        "date": "2020-12-26T14:12:33.703654-06:00",
        "temperatureC": 13,
        "temperatureF": 55,
        "summary": "Mild"
    }
]

Quickstart

You can follow one or both of the following sections to set up AutoCrud for your choice of storage backend

Entity Framework

Install Firebend.AutoCrud.Entity by adding the following to AutoCrudSampleApi.csproj

<ItemGroup>
  <ProjectReference Include="Firebend.AutoCrud.Core" />
  <ProjectReference Include="Firebend.AutoCrud.EntityFramework" />
  <ProjectReference Include="Firebend.AutoCrud.EntityFramework.Elastic" />
  <ProjectReference Include="Firebend.AutoCrud.Web" />
</ItemGroup>

or install packages via the dotnet cli

dotnet add package Firebend.AutoCrud.Core
dotnet add package Firebend.AutoCrud.EntityFramework
dotnet add package Firebend.AutoCrud.EntityFramework.Elastic
dotnet add package Firebend.AutoCrud.Web
dotnet add package Microsoft.EntityFrameworkCore.Design

Create a new folder called DbContexts in your project and add a file called AppDbContext.cs with the following contents

using Firebend.AutoCrud.EntityFramework.Interfaces;
using Microsoft.EntityFrameworkCore;

namespace AutoCrudSampleApi.DbContexts;

public class AppDbContext : DbContext, IDbContext
{
    public AppDbContext(DbContextOptions options) : base(options)
    {
    }

    // define a DbSet for each of your models
    public DbSet<WeatherForecast> WeatherForecasts { get; set; }
}

In WeatherForecast.cs, modify the model to extend IEntity

using System;
using Firebend.AutoCrud.Core.Interfaces.Models;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace AutoCrudSampleApi;

[Table("WeatherForecasts")] // define a table
public class WeatherForecast : IEntity<Guid> // implement the `IEntity` interface
{
    [Key] // define a Guid with the `Key` annotation to complete the IEntity implementation
    public Guid Id { get; set; }

    public DateTime Date { get; set; }

    [Required]
    public int TemperatureC { get; set; }

    [StringLength(250)]
    public string Summary { get; set; }
}

Finally, open Program.cs; you should see some code resembling the following

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddControllers();
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();
app.UseAuthorization();
app.MapControllers();

app.Run();

Add the following using directives

using Firebend.AutoCrud.Core.Extensions.EntityBuilderExtensions;
using Firebend.AutoCrud.Core.Interfaces.Services.Entities;
using Firebend.AutoCrud.Core.Models.Searching;
using Firebend.AutoCrud.EntityFramework;
using Firebend.AutoCrud.Web;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;

And add the DB context object to the IOC container

builder.Services.AddDbContext<AppDbContext>(
    options => { options.UseSqlServer(builder.Configuration.GetConnectionString("AppSettingsSqlConnection") ?? throw new InvalidOperationException()); },
    ServiceLifetime.Singleton);

Register the AutoCrud configuration for the WeatherForecast entity

builder.Services.UsingEfCrud(ef =>
    {
        ef.AddEntity<Guid, WeatherForecast>(forecast =>
            forecast.WithDbContext<AppDbContext>()
                .WithConnectionString(builder.Configuration.GetConnectionString("AppSettingsSqlConnection"))
                .WithDbOptionsProvider<AppDbContextOptionsProvider<Guid, WeatherForecast>>()
                .AddCrud(crud =>
                    crud.WithCrud()
                        .WithSearchHandler<EntitySearchRequest>((forecasts, request) =>
                            {
                                if (!string.IsNullOrWhiteSpace(request?.Search))
                                    forecasts = forecasts.Where(wf =>
                                        wf.Summary!.ToUpper()
                                            .Contains(request.Search.ToUpper()));

                                return forecasts;
                            }
                        ))
                    .AddControllers(c => c
                        .WithAllControllers(true)
                        .WithOpenApiGroupName("WeatherForecasts"))
                .WithRegistration<IEntityReadService<Guid, WeatherForecast>, ForecastReadRepository>()
        );
    }
);

// this prevents having to wrap POST bodies with `entity`
// like `{ "entity": { "key": "value" } }`
builder.Services.Configure<ApiBehaviorOptions>(o => o.SuppressInferBindingSourcesForParameters = true);

An example of DB Context Options Provider

public class AppDbContextOptionsProvider<TKey, TEntity> : IDbContextOptionsProvider<TKey, TEntity>
    where TKey : struct
    where TEntity : IEntity<TKey>
{
    public DbContextOptions<TContext> GetDbContextOptions<TContext>(string connectionString)
        where TContext : DbContext => new DbContextOptionsBuilder<TContext>().UseSqlServer(connectionString).AddFirebendFunctions().Options;

    public DbContextOptions<TContext> GetDbContextOptions<TContext>(DbConnection connection)
        where TContext : DbContext => new DbContextOptionsBuilder<TContext>().UseSqlServer(connection).AddFirebendFunctions().Options;
}

In the Program.cs file, we need to register the AutoCrud controllers as below;

builder.Services.AddControllers().AddFirebendAutoCrudWeb(builder.Services);

We need to define a connection secret in appsettings.json or we need to create a secret.json file. In this example, we will continue with the appsettings.json definition.

{
  "ConnectionStrings": {
      "AppSettingsSqlConnection": "Data Source=localhost;Initial Catalog=auto-crud-api;Persist Security Info=False;User ID=sa;Password=Password0#@!;Encrypt=True;TrustServerCertificate=True;Connection Timeout=30;MultipleActiveResultSets=True;Max Pool Size=200;"
  }
}

Now, we need to create and apply some migrations. From the command line, run

dotnet ef migrations add CreateTable_WeatherForecasts
dotnet ef database update

Now you should be able to run the application and hit the endpoints defined below.

dotnet watch run

Here, we've configured Entity Framework by adding AutoCrud to the WeatherForecast model that Microsoft provided us. This will

  • Create a new Entity Framework table for WeatherForecasts model
  • Create the following endpoints to interact with our model
    • DELETE /api/v1/weather-forecast/{id}
    • GET /api/v1/weather-forecast/{id}
    • PUT /api/v1/weather-forecast/{id}
    • PATCH /api/v1/weather-forecast/{id}
    • POST /api/v1/weather-forecast
    • GET /api/v1/weather-forecast
    • GET /api/v1/weather-forecast/all
    • GET /api/v1/weather-forecast/multiple

To enable searching objects in GET requests, include the following in the program.cs in the WithDbContext callback; return a function returning a boolean value for whether to include the item in the search results

// ... previous setup
 ef.AddEntity<Guid, WeatherForecast>(forecast =>
            forecast.WithDbContext<AppDbContext>()
                .WithConnectionString(builder.Configuration.GetConnectionString("AppSettingsSqlConnection"))
                .WithDbOptionsProvider<AppDbContextOptionsProvider<Guid, WeatherForecast>>()
                .AddCrud(crud =>
                    crud.WithCrud()
                        .WithSearchHandler<EntitySearchRequest>((forecasts, request) =>
                            {
                                if (!string.IsNullOrWhiteSpace(request?.Search))
                                    forecasts = forecasts.Where(wf =>
                                        wf.Summary!.ToUpper()
                                            .Contains(request.Search.ToUpper()));

                                return forecasts;
                            }
                        ))
                .AddControllers(c => c

// ... rest of your setup

Now, when appending the query param Search={your search} to your url, you'll only get results with '{your search}' in the Summary.

Mongo

Install Firebend.AutoCrud.Mongo by adding the following to AutoCrudSampleApi.csproj

<ItemGroup>
  <ProjectReference Include="Firebend.AutoCrud.Core" />
  <ProjectReference Include="Firebend.AutoCrud.Mongo" />
  <ProjectReference Include="Firebend.AutoCrud.Web" />
</ItemGroup>

or install packages via the dotnet cli

dotnet add package Firebend.AutoCrud.Core
dotnet add package Firebend.AutoCrud.Mongo
dotnet add package Firebend.AutoCrud.Web

Finally, open Program.cs; you should see some code resembling the following

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddControllers();
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();
app.UseAuthorization();
app.MapControllers();

app.Run();

Add the following using directives

using Firebend.AutoCrud.Core.Extensions.EntityBuilderExtensions;
using Firebend.AutoCrud.Core.Models.Searching;
using Firebend.AutoCrud.Mongo;
using Firebend.AutoCrud.Web;
using Microsoft.AspNetCore.Mvc;

In WeatherForecast.cs, modify the model to extend IEntity

using System;
using Firebend.AutoCrud.Core.Interfaces.Models;

namespace AutoCrudSampleApi;

public class WeatherForecast : IEntity<Guid> // use the `IEntity` interface
{
    public Guid Id { get; set; } // complete the interface implementation
    
    public DateTime Date { get; set; }

    public int TemperatureC { get; set; }

    public string Summary { get; set; }
}

We need to define a connection secret in appsettings.json or we need to create a secret.json file. In this example, we will continue with the appsettings.json definition.

{
  "ConnectionStrings": {
      "AppSettingsMongoConnection": "mongodb://localhost:27017/autocrudapi"
  }
}

Register the AutoCrud configuration for the WeatherForecast entity

builder.Services.UsingMongoCrud(builder.Configuration.GetConnectionString("AppSettingsMongoConnection"),
    true, mongo =>
    {
        mongo.AddEntity<Guid, WeatherForecast>(forecast =>
            forecast.WithDefaultDatabase("Samples")
                .WithCollection("WeatherForecasts")
                .AddCrud(crud =>
                    crud.WithCrud()
                        .WithSearchHandler<EntitySearchRequest>((forecasts, request) =>
                            {
                                if (!string.IsNullOrWhiteSpace(request?.Search))
                                    forecasts = forecasts.Where(wf =>
                                        wf.Summary != null && wf.Summary.ToUpper()
                                            .Contains(request.Search.ToUpper()));

                                return forecasts;
                            }
                        ))
                .AddControllers(c =>
                {
                    c.WithAllControllers(true) // `true` activates the `/all` endpoint
                        .WithOpenApiGroupName("WeatherForecasts");
                }));
    });
    

// this prevents having to wrap POST bodies with `entity`
// like `{ "entity": { "key": "value" } }`
builder.Services.Configure<ApiBehaviorOptions>(o => o.SuppressInferBindingSourcesForParameters = true);

In the Program.cs file, we need to register the AutoCrud controllers as below;

builder.Services.AddControllers().AddFirebendAutoCrudWeb(builder.Services);

You can delete Controllers/WeatherForecastController.cs.

Here, we've configured Mongo by adding AutoCrud to the WeatherForecast model that Microsoft provided us. This will

  • Create a new Mongo collection called Samples with a new collection called WeatherForecasts
  • Create the following endpoints to interact with our model
    • GET /api/v1/weather-forecast/{id}
    • DELETE /api/v1/weather-forecast/{id}
    • PUT /api/v1/weather-forecast/{id}
    • PATCH /api/v1/weather-forecast/{id}
    • POST /api/v1/weather-forecast
    • GET /api/v1/weather-forecast
    • GET /api/v1/weather-forecast/all
    • GET /api/v1/weather-forecast/multiple

To enable searching via GET endpoints, add .WithFullTextSearch() after WithCollection in the program.cs AddEntity callback

// ... previous setup
mongo.AddEntity<Guid, WeatherForecast>(forecast =>
   forecast.WithDefaultDatabase("Samples")
       .WithCollection("WeatherForecasts")
       .WithFullTextSearch()
       .AddCrud()
       .AddControllers(controllers => {
           controllers
               .WithAllControllers(true) // `true` turns on the `/all` endpoint
               .WithOpenApiGroupName("WeatherForecasts");
       })
// ... rest of your setup

Now, when appending the query param Search={your search} to your url, you'll only get results with '{your search}' in any text field.

Custom Ordering and Search

To enable ordering of results, include the following in the program.cs in the AddEntity callback

// ... previous setup
forecast.WithDbContext<AppDbContext>()
    .AddCrud(crud => 
        crud
            .WithCrud()
            .WithOrderBy(f => f.TemperatureC)
            .WithSearchHandler<EntitySearchRequest>((query, parameters) =>
            {
                if (!string.IsNullOrWhiteSpace(parameters?.Summary))
                {
                    query = query.Where(x => x.Summary.Contains(parameters.Summary));
                }
    
                return query;
            })
// ... rest of your setup

This will sort results by the TemperatureC member, in ascending order. To sort in descending order, pass false as the second parameter to WithOrderby: .WithOrderBy(f => f.TemperatureC, false)

To include custom search parameters for an entity, include the following in the program.cs in the AddEntity callback; return a function returning a boolean value for whether to include the item in the search results, or null to skip the search.

// ... previous setup
ef.AddEntity<Guid, WeatherForecast>(forecast => 
    forecast.WithDbContext<AppDbContext>()
        .AddCrud(crud => crud
            .WithCrud()
            .WithSearch<EntitySearchRequest>(search => {
                if (!string.IsNullOrWhiteSpace(search?.CustomField))
                {
                    return f => f.Summary.Contains(search.CustomField);
                }

                return null;
            })
        )
// ... rest of your setup

Create a new class CustomSearchParameters that extends EntitySearchRequest and has your custom fields as members

using Firebend.AutoCrud.Core.Models.Searching;

namespace AutoCrudSampleApi;

public class CustomSearchParameters : EntitySearchRequest
{
    public string CustomField { get; set; }
}

Now, you can append the CustomField={your search} query parameter to your url and filter results by a custom parameter.

Entity Export

To create an endpoint that exports your results to xlxs or csv

Install the Firebend.AutoCrud.Io and Firebend.AutoCrud.Io.Web packages

<ItemGroup>
<!-- ... rest of the PackageReferences -->
    <PackageReference Include="Firebend.AutoCrud.Io" />
    <PackageReference Include="Firebend.AutoCrud.Io.Web" />
</ItemGroup>

or

dotnet add package Firebend.AutoCrud.Io
dotnet add package Firebend.AutoCrud.Io.Web

Create a new class WeatherForecastExport like the following

using Firebend.AutoCrud.Core.Extensions;

namespace AutoCrudSampleApi;

public class WeatherForecastExport
{
    public WeatherForecastExport()
    {
    }

    public WeatherForecastExport(WeatherForecast forecast)
    {
        forecast.CopyPropertiesTo(this);
    }

    public Guid Id { get; set; }
    public DateTime Date { get; set; }
    public int TemperatureC { get; set; }
    public string Summary { get; set; }
}

Then, add the AddIo() before AddControllers in the the program.cs AddEntity callback and WithIoControllers() to the AddControllers

// ... previous setup
ef.AddEntity<Guid, WeatherForecast>(forecast => 
    forecast.WithDbContext<AppDbContext>()
        .AddCrud()
        .AddIo(io => io.WithMapper(x => new WeatherForecastExport(x)))
        .AddControllers(controllers => controllers
            .WithAllControllers(true)
            .WithOpenApiGroupName("WeatherForecasts")
            .WithIoControllers()
        )
  );
// ... rest of your setup

Now, you can make a GET request to the /weather-forecast/export/{csv|excel}?filename=test.csv endpoint, with either csv or excel requested. A file name is required. All search fields and custom parameters that work on the GET / and GET /all endpoints work here too.

Change Tracking

Install the Firebend.AutoCrud.ChangeTracking and Firebend.AutoCrud.DomainEvents packages

<!-- other packages -->
<PackageReference Include="MassTransit.AspNetCore" />
<PackageReference Include="MassTransit.RabbitMQ" />
<PackageReference Include="Firebend.AutoCrud.ChangeTracking" />
<PackageReference Include="Firebend.AutoCrud.ChangeTracking.EntityFramework" />
<PackageReference Include="Firebend.AutoCrud.ChangeTracking.Mongo" />
<PackageReference Include="Firebend.AutoCrud.ChangeTracking.Web" />
<PackageReference Include="Firebend.AutoCrud.DomainEvents.MassTransit" />

or

dotnet add package MassTransit.AspNetCore
dotnet add package MassTransit.RabbitMQ
dotnet add package Firebend.AutoCrud.ChangeTracking
dotnet add package Firebend.AutoCrud.ChangeTracking.EntityFramework # or Firebend.AutoCrud.ChangeTracking.Mongo
dotnet add package Firebend.AutoCrud.ChangeTracking.Web
dotnet add package Firebend.AutoCrud.DomainEvents.MassTransit

Create a DomainEventContextProvider class like below

using Firebend.AutoCrud.Core.Interfaces.Services.DomainEvents;
using Firebend.AutoCrud.Core.Models.DomainEvents;

namespace AutoCrudSampleApi;

public class CatchPhraseModel
{
    public string CatchPhrase { get; set; }
}

public class DomainEventContextProvider : IDomainEventContextProvider
{
    public DomainEventContext GetContext() => new DomainEventContext
    {
        Source = "My Sample",
        UserEmail = "sample@firebend.com",
        CustomContext = new CatchPhraseModel { CatchPhrase = "I Like Turtles" }
    };
}

Create a class MassTransitExtensions with the following

using System;
using System.Text.RegularExpressions;
using Firebend.AutoCrud.DomainEvents.MassTransit.Extensions;
using MassTransit;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;

namespace AutoCrudSampleApi;

public static class MassTransitExtensions
{
    private static readonly Regex ConStringParser = new Regex(
        "^rabbitmq://([^:]+):(.+)@([^@]+)$",
        RegexOptions.Compiled | RegexOptions.IgnoreCase);

    public static IServiceCollection AddMassTransit(this IServiceCollection serviceCollection, IConfiguration configuration)
    {
        var connString = "rabbitmq://guest:guest@localhost/"; // replace with your connection string

        if (string.IsNullOrWhiteSpace(connString))
        {
            throw new Exception("Please configure a service bus connection string for Rabbit MQ");
        }

        return serviceCollection.AddMassTransit(bus =>
            {
                bus.RegisterFirebendAutoCrudDomainEventHandlers(serviceCollection);

                bus.UsingRabbitMq((context, configurator) =>
                {
                    var match = ConStringParser.Match(connString);

                    var domain = match.Groups[3].Value;
                    var uri = $"rabbitmq://{domain}";

                    configurator.Host(new Uri(uri), h =>
                    {
                        h.PublisherConfirmation = true;
                        h.Username(match.Groups[1].Value);
                        h.Password(match.Groups[2].Value);
                    });

                    configurator.Lazy = true;
                    configurator.AutoDelete = true;
                    configurator.PurgeOnStartup = true;

                    context.RegisterFirebendAutoCrudDomainEventHandlerEndPoints(configurator, serviceCollection, AutoCrudMassTransitQueueMode.OneQueue);
                });
            })
            .AddMassTransitHostedService();
    }
}

Finally, modify the ConfigureServices callback in the program.cs like so

builder.services
    .UsingEfCrud(ef =>
    {
        ef.AddEntity<Guid, WeatherForecast>(forecast => 
            forecast.WithDbContext<AppDbContext>()
                .AddCrud()
                .AddDomainEvents(events => events // add this
                    .WithEfChangeTracking()
                    .WithMassTransit()
                )
                .AddControllers(controllers => controllers
                    .WithAllControllers(true)
                    .WithOpenApiGroupName("WeatherForecasts")
                    .WithChangeTrackingControllers() // and this
                )
        )
        .WithDomainEventContextProvider<DomainEventContextProvider>(); // and this
    })
    .AddMassTransit(builder.Configuration) // and this
    .AddRouting()
    .AddSwaggerGen()
    .AddControllers()
    .AddNewtonsoftJson()
    .AddFirebendAutoCrudWeb(services);

Now, you should be able to hit the endpoint /weather-forecast/{id}/changes and get a list of modifications to the object. You can add new entries by PUTing to /weather-forecast/{id} to change some values.

Elastic Pool with Sharding

Install the Firebend.AutoCrud.EntityFramework.Elastic package

<PackageReference Include="Firebend.AutoCrud.EntityFramework.Elastic" />

or

dotnet add package Firebend.AutoCrud.EntityFramework.Elastic

Create a class KeyProvider that implements IShardKeyProvider (or IMongoShardKeyProvider for Mongo)

using Firebend.AutoCrud.EntityFramework.Elastic.Interfaces;
using Firebend.AutoCrud.Mongo.Interfaces;

namespace AutoCrudSampleApi;

public class KeyProvider : IShardKeyProvider // or IMongoShardKeyProvider
{
    public string GetShardKey() => "Firebend";
}

Create a class DbNameProvider that implements IShardNameProvider

using Firebend.AutoCrud.EntityFramework.Elastic.Interfaces;

namespace AutoCrudSampleApi;

public class DbNameProvider : IShardNameProvider
{
    public string GetShardName(string key) => $"{key}_CrudSample";
}

Modify ConfigureServices in the program.cs by removing the services.AddDbContext call (leaving WithDbContext on the entity) and adding AddElasticPool to the entity, like so

using Firebend.AutoCrud.EntityFramework.Elastic.Extensions;

// ...
  services
    // .AddDbContext<AppDbContext>(options => { options.UseSqlServer("connString")}, ServiceLifetime.Singleton) // delete
    .UsingEfCrud(ef =>
    {
        ef.AddEntity<Guid, WeatherForecast>(forecast => 
            forecast.WithDbContext<AppDbContext>()
                .AddElasticPool( // add
                    manager => {
                        manager.ConnectionString = "connString";
                        manager.MapName = "your-map-name";
                        manager.Server = ".";
                        manager.ElasticPoolName = "pool-name";
                    },
                    pool => pool
                        .WithShardKeyProvider<KeyProvider>()
                        .WithShardDbNameProvider<DbNameProvider>()
                )
    // ... rest of your setup

Rerun the project. You'll notice the first request takes a while to execute as the database is created.

Mongo Sharding

Create a class KeyProvider that implements IMongoShardKeyProvider

using Firebend.AutoCrud.EntityFramework.Elastic.Interfaces;
using Firebend.AutoCrud.Mongo.Interfaces;

namespace AutoCrudSampleApi;

public class KeyProvider : IShardKeyProvider // or IMongoShardKeyProvider
{
    public string GetShardKey() => "Firebend";
}

Modify ConfigureServices in the program.cs by adding WithShardKeyProvider and WithShardMode for each configured entity

using Firebend.AutoCrud.Mongo.Models;

// ...
  services
    .UsingMongoCrud("connString", mongo => {
        mongo.AddEntity<Guid, WeatherForecast>(forecast =>
            forecast.WithDefaultDatabase("Samples")
                .WithCollection("WeatherForecasts")
                .WithFullTextSearch()
                .WithShardKeyProvider<KeyProviderMongo>()
                .WithShardMode(MongoTenantShardMode.Database)
    // ... rest of your setup

Custom Fields

Auto Crud allows you to store key value pair custom fields for entities. In no sql data stores like MongoDB this will be an additional array added to the entity to house the key value pairs. For relational data stores like Sql Server using Entity Framework, the custom fields will be stored in an additional table.

Install the required package(s)

<PackageReference Include="Firebend.AutoCrud.CustomFields.EntityFramework" /> or <PackageReference Include="Firebend.AutoCrud.CustomFields.Mongo" /> 
<PackageReference Include="Firebend.AutoCrud.EntityFramework.Web" />

or

dotnet add package Firebend.AutoCrud.CustomFields.EntityFramework # or dotnet add package Firebend.AutoCrud.CustomFields.EntityFramework
dotnet add package Firebend.AutoCrud.CustomFields.Web

Implement ICustomFieldsEntity<Guid> to the model you are wanting to add Custom Fields to and add the CustomFields list of entities to store the custom fields. In this example, we'll be editing the WeatherForecast.cs file to be like below:

namespace AutoCrudSampleApi;

[Table("WeatherForecasts")] // define a table
public class WeatherForecast : IEntity<Guid>, ICustomFieldsEntity<Guid> // implement the `IEntity` interface
{
    [Key] // define a Guid with the `Key` annotation to complete the IEntity implementation
    public Guid Id { get; set; }

    public DateTime Date { get; set; }

    [Required]
    public int TemperatureC { get; set; }

    [StringLength(250)]
    public string Summary { get; set; }

    public List<CustomFieldsEntity<Guid>> CustomFields { get; set; }
}

Mongo

Add the .AddCustomFields() call right before .AddCrud() call.

// ...
  services
    .UsingMongoCrud("connString", mongo => {
        mongo.AddEntity<Guid, WeatherForecast>(forecast =>
            forecast.WithDefaultDatabase("Samples")
                .WithCollection("WeatherForecasts")
                .WithFullTextSearch()
                .WithShardKeyProvider<KeyProviderMongo>()
                .WithShardMode(MongoTenantShardMode.Database)
                .AddCustomFields()
    // ... rest of your setup

EF

Add the .AddCustomFields() call right before .AddCrud() call.

// ...
  .UsingEfCrud(ef =>
    {
        ef.AddEntity<Guid, WeatherForecast>(forecast => 
            forecast.WithDbContext<AppDbContext>()
            .AddCustomFields())
    // ... rest of your setup

The EF variant of .AddCustomFields also allows you to configure additional options. Since the EF Custom fields are stored in an additional table, you may want to configure them more fully. An example would be change tracking on custom fields. With EF custom fields we need to explicitly add that.

The below example configures custom fields for the Weather Forecast Tenant and:

  1. Adds change tracking to the custom fields
  2. Adds Controllers to view and search change tracking operations
  3. Adds a custom open api group name for the endpoints
// ...
  .UsingEfCrud(ef =>
    {
        ef.AddEntity<Guid, WeatherForecast>(forecast => 
            forecast.WithDbContext<AppDbContext>()
            .AddCustomFields(cf => 
                cf.AddCustomFieldsTenant<int>(c => 
                    c.AdddDomainEvents(de => de.WithEfChangeTracking().WithMassTransit)
                .AddControllers(controllers => controllers
                    .WithChangeTrackingControllers()
                    .WithRoute("/api/v1/forecasts/{forecastId}/custom-fields")
                    .WithOpenApiGroupName("Weather Forecast Custom Fields")
                    .WithOpenApiEntityName("Weather Forecast Custom Field", "Weather Forecast Custom Fields")))))
    // ... rest of your setup

Example Project

A "kitchen-sink" example can be found in Firebend.AutoCrud.Web.Sample that utilizes all the extension packs mentioned above. Sample .http files are also provided with example HTTP requests. Get the VS Code REST client

Contributing

Commits should be made using Conventional Commits

√√√