{"repo":"zompinc/efcore-extensions","free":true,"listed":false,"github":"https://github.com/zompinc/efcore-extensions","clone":"git clone https://github.com/zompinc/efcore-extensions.git","description":"Provides window (analytics) functions and binary functions for EF Core. Providers: SQL Server, SQLite, Postgres.","language":"C#","stars":108,"topics":["efcore","linq","postgres","sql","sql-server","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"Zomp EF Core Extensions This repository is home to two packages which extend Entity Framework Core: - Zomp.EFCore.WindowFunctions - Zomp.EFCore.BinaryFunctions 📺 Watch the presentation for an overview of these extensions. Zomp.EFCore.WindowFunctions Provides Window functions or analytics functions for providers. Currently supported for: Provider Package ------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------ SQL Server PostgreSQL SQLite Window functions supported: - MIN - MAX - SUM - AVG - COUNT - ROW NUMBER - RANK - DENSE RANK - PERCENT RANK - LEAD - LAG Installation To add provider-specific library use: To add provider-agnostic library use: Set up your specific provider to use Window Functions with DbContextOptionsBuilder.UseWindowFunctions . For example here is the SQL Server syntax: Basic usage LINQ query translates into the following SQL on SQL Server: Advanced usage This example shows: - Partition clause (can be chained) - Order by clause - Can me chained - Used in ascending or descending order - Range or Rows clause Zomp.EFCore.BinaryFunctions Provides Window functions or analytics functions for providers. Currently supported for: Provider Package ---------- ---------------------------------------------------------------------------------------------------------------------------","default_branch":null,"files":null,"tree":[],"storefront":"/r/zompinc","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/zompinc/efcore-extensions/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}