// NMemory

// Doc: https://nmemory.net/stored-procedures

​

// @nuget: NMemory

​

using System;

using System.Linq;

using NMemory;

using NMemory.Indexes;

using NMemory.Tables;

using NMemory.StoredProcedures;

using System.Collections.Concurrent;

public class Program

{

    public static void Main()

    {

        MyDatabase myDatabase = new MyDatabase();

​

        myDatabase.Groups.Insert(new Group() { Id = 1, Name = "Group_1"});

​

        myDatabase.Groups.Insert(new Group() { Id = 2, Name = "Group_2"});

​

        myDatabase.Members.Insert(new Member() { Id = 1, GroupId = 1, Name = "It's Member_1" });

​

        myDatabase.Members.Insert(new Member() { Id = 2, Name = "It's Member_2" });

​

        IQueryable<Group> query = 

            myDatabase.Groups.Where(g => g.Id > new Parameter<int>("param1") + new Parameter<long?>("param2"));

​

        var procedure = myDatabase.StoredProcedures.Create(query);

​

        var parameters = new ConcurrentDictionary<string, object>();

        parameters.GetOrAdd("param1", 1);

        parameters.GetOrAdd("param2", (long?)0);

​

​

        FiddleHelper.WriteTable("All Members", procedure.Execute(parameters).ToList());

    }

    public class MyDatabase : Database

    {

        public MyDatabase()

        {

            var members = this.Tables.Create<Member, int>(x => x.Id);

            var groups = base.Tables.Create<Group, int>(g => g.Id);

​

            this.Members = members;

            this.Groups = groups;

​

            RelationOptions options = new RelationOptions(

                cascadedDeletion: true);

​

            var peopleGroupIdIndex = members.CreateIndex(

                new RedBlackTreeIndexFactory(),

                p => p.GroupId);

​

            this.Tables.CreateRelation(

                groups.PrimaryKeyIndex,

                peopleGroupIdIndex,

                x =>  x ?? -1,

                x => x,

                options);

        }

​

        public ITable<Member> Members { get; private set; }

​

        public ITable<Group> Groups { get; private set; }

    }

​

    public class Member

    {

        public int Id { get; set; }

​

        public string Name { get; set; }

​

        public int? GroupId { get; set; } 

    }

​

    public class Group

    {

        public int Id { get; set; } 

​

        public string Name { get; set; }

​

    }

}