AdaloExtensionPack

Helpers to connect C# Web app to Adalo tables API

Usage

Classic table

In the Startup.cs file add in the method ConfigureServices() :

services.AddAdalo(x => { x.AddApplication("[your Adalo App Id]", "[your API token here]") .AddTable<SomeEntity>("[table Id]", cached: false) .AddTable<SomeEntity>("[table Id 2]", cached: true); });

Then inject IAdaloTableService<SomeEntity> in your controller/services to connect directly to Adalo tables API, or IAdaloTableCacheService<SomeEntity> to add a cache layer between Adalo and your app.

Note: SomeEntity need to inherit from AdaloExtensionPack.Core.Adalo.AdaloEntity

Cached table

If the cached parameter is set to the true value in the call to AddTable, a controller with methods to create, read, update and delete this type of entities will be generated:

These controllers can be used as external collections in Adalo to improve performances of your tables.

You can also access theses cached tables from your code with the class AdaloTableCacheService<SomeEntity>

Views

Views are filtered and mapped collections available through a controller GET action.

You can create a view by add this line inside the AddAdalo() call:

x.AddApplication("[your Adalo App Id]", "[your API token here]") .AddView<SomeContext, SomeEntity, SomeProjection>( serviceProvider => new SomeContext(serviceProvider), //Build a context which be reused in predicate and mapping (ctx, entity) => true, // Predicate (ctx, entity) => new SomeProjection(entity)); // Mapping

This will generate this method: