FirestoreLINQ 1.0.1

FirestoreLINQ

Gives LINQ support to Firestore database.

Getting started

Define your C# Poco that matches the firestore document

[FirestoreData, FirestoreCollection("Students")]
public class Student
{
    [FirestoreProperty]
    public List<string> Skills { get; set; }

    [FirestoreProperty]
    public string FirstName { get; set; }

    [FirestoreProperty]
    public string LastName { get; set; }

    [FirestoreProperty]
    public int Age { get; set; }
}

Add AsQuerable to Collection Reference

public class QueryTest
{
    FirestoreDb db;
    QueryTest()
    {
        db = new FirestoreDbBuilder
        {
            ProjectId = <<Project ID>>,
            JsonCredentials = "<<Path to JSON>>"
        }.Build();
    }

    public void GetYoungers()
    {
        var youngers = db.AsQuerable<Student>()
                         .Where(s => s.Age >= 15 && s.Age <= 25).ToList();
        
        //Above LINQ Expression will be executed in form of following firestore query
        var youngersTranslated = db.Collection("Students")
                                   .WhereGreaterThanOrEqualTo("Age", 15)
                                   .WhereLessThanOrEqualTo("Age", 25)
                                   .Select(x=> x.ConvertTo<Student>())
                                   .ToList();
    }
}

Here are supported Query Methods

Any, Avg, Count, First, FirstOrDefault, Last, LastOrDefault, Max, MaxBy, Min, MinBy, OrderBy, OrderByDescending, Select, Single, SingleOrDefault, Skip, Sum, Take, Where

Note: Where predicate with OR clause not yet supported.

More features coming soon.