dotnet-data/README.md

# Goal 
The goal of this project is to help, fill the gap of supporting multiple ORM's in DynamicQuery, and possibly more projects in the future.

One of the most obvious reason is to be able to execute async/await operations on the context without, the executing library to be dependant on the ORM Framework such as (EF Core, EF6).

## Getting Started

> Install nuget package to your awesome project.

Full Version                  | NuGet                                                                                                                                                                                                                                                                 |                                           NuGet Install
------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------------------------------------------------------:
PoweredSoft.Data.Core      | <a href="https://www.nuget.org/packages/PoweredSoft.Data.Core/" target="_blank">[![NuGet](https://img.shields.io/nuget/v/PoweredSoft.Data.Core.svg?style=flat-square&label=nuget)](https://www.nuget.org/packages/PoweredSoft.Data.Core/)</a>                |      ```PM> Install-Package PoweredSoft.Data.Core```
PoweredSoft.Data      | <a href="https://www.nuget.org/packages/PoweredSoft.Data/" target="_blank">[![NuGet](https://img.shields.io/nuget/v/PoweredSoft.Data.svg?style=flat-square&label=nuget)](https://www.nuget.org/packages/PoweredSoft.Data/)</a>                |      ```PM> Install-Package PoweredSoft.Data```
PoweredSoft.Data.EntityFramework | <a href="https://www.nuget.org/packages/PoweredSoft.Data.EntityFramework/" target="_blank">[![NuGet](https://img.shields.io/nuget/v/PoweredSoft.Data.EntityFramework.svg?style=flat-square&label=nuget)](https://www.nuget.org/packages/PoweredSoft.Data.EntityFramework/)</a> | ```PM> Install-Package PoweredSoft.Data.EntityFramework```
PoweredSoft.Data.EntityFrameworkCore | <a href="https://www.nuget.org/packages/PoweredSoft.Data.EntityFrameworkCore/" target="_blank">[![NuGet](https://img.shields.io/nuget/v/PoweredSoft.Data.EntityFrameworkCore.svg?style=flat-square&label=nuget)](https://www.nuget.org/packages/PoweredSoft.Data.EntityFrameworkCore/)</a> | ```PM> Install-Package PoweredSoft.Data.EntityFrameworkCore```
PoweredSoft.Data.MongoDB | <a href="https://www.nuget.org/packages/PoweredSoft.Data.MongoDB/" target="_blank">[![NuGet](https://img.shields.io/nuget/v/PoweredSoft.Data.MongoDB.svg?style=flat-square&label=nuget)](https://www.nuget.org/packages/PoweredSoft.Data.MongoDB/)</a> | ```PM> Install-Package PoweredSoft.Data.MongoDB```
PoweredSoft.Data.InMemory | <a href="https://www.nuget.org/packages/PoweredSoft.Data.InMemory/" target="_blank">[![NuGet](https://img.shields.io/nuget/v/PoweredSoft.Data.InMemory.svg?style=flat-square&label=nuget)](https://www.nuget.org/packages/PoweredSoft.Data.InMemory/)</a> | ```PM> Install-Package PoweredSoft.Data.InMemory```


# In your application you may do the following

```csharp
public class Startup
{
    public void ConfigureServices(IServiceCollection services) 
    {
        // for mongo.
        services.AddPoweredSoftMongoDBDataServices();

        // for ef core
        services.AddPoweredSoftEntityFrameworkCoreDataServices();
        
        // for in memory 
        services.AddPoweredSoftInMemoryDataServices();
    }
}
```

## AsyncQueryableService

Also as the same kind of goal, will slowly add support for a non dependant to orm/drivers async method.

```csharp
public interface IAsyncQueryableHandlerService
{
    Task<T> FirstOrDefaultAsync<T>(IQueryable<T> queryable, CancellationToken cancellationToken = default(CancellationToken));
    Task<T> FirstOrDefaultAsync<T>(IQueryable<T> queryable, Expression<Func<T, bool>> predicate, CancellationToken cancellationToken = default(CancellationToken));
    Task<List<T>> ToListAsync<T>(IQueryable<T> queryable, CancellationToken cancellationToken = default(CancellationToken));
    Task<int> CountAsync<T>(IQueryable<T> queryable, CancellationToken cancellationToken = default(CancellationToken));
    Task<long> LongCountAsync<T>(IQueryable<T> queryable, CancellationToken cancellationToken = default(CancellationToken));
    Task<bool> AnyAsync<T>(IQueryable<T> queryable, Expression<Func<T, bool>> predicate, CancellationToken cancellationToken = default(CancellationToken));
    Task<bool> AnyAsync<T>(IQueryable<T> queryable, CancellationToken cancellationToken = default(CancellationToken));
    bool CanHandle<T>(IQueryable<T> queryable);
}
```

How to use

```csharp
public class SomeClass
{
    private readonly IAsyncQueryableService asyncQueryableService;
    public SomeClass(IAsyncQueryableService asyncQueryableService)
    {
        this.asyncQueryableService = asyncQueryableService;
    }

    public async Task<T> GetFirstAsync(IQueryable<T> query) {
        return await this.asyncQueryableService.FirstOrDefaultAsync(query);
    }
}

```