ThrottlingTroll.CounterStores.EfCore 7.2.0

ThrottlingTroll.CounterStores.EfCore

ICounterStore implementation based on Entity Framework Core. Intended to work with any relational database supported by it.

Uses transactions, and therefore is subjected to locks. Use with caution, especially under high loads.

How to use

1. Create a table for storing counters:

    CREATE TABLE ThrottlingTrollCounters
    (
      [Id] [nvarchar](255) PRIMARY KEY,
      [Count] [bigint] NOT NULL,
      [ExpiresAt] [datetimeoffset] NOT NULL
    )    
   

2. Install package from NuGet:

     dotnet add package ThrottlingTroll.CounterStores.EfCore
   

3. Install the desired database provider. E.g. for SQL Server:

     dotnet add package Microsoft.EntityFrameworkCore.SqlServer --version 6.0.31
   

4. EITHER put EfCoreCounterStore instance into your DI container:

     builder.Services.AddSingleton<ICounterStore>(
         new EfCoreCounterStore(efConfig =>
         {
             efConfig.UseSqlServer("my-sql-server-connection-string");
         })
     );
   

   OR provide an instance of it via .UseThrottlingTroll() method:

     app.UseThrottlingTroll(options =>
     {
         options.CounterStore = new EfCoreCounterStore(efConfig =>
         {
             efConfig.UseSqlServer("my-sql-server-connection-string");
         });
     });
   

EfCoreCounterStore's ctor takes a routine for configuring Entity Framework Core with the desired database provider. The above sample code uses SQL Server, so change it accordingly, if needed.