Lombiq/Lombiq.HelpfulLibraries.LinqToDbv0.0.5
✓ Verified.NET 10.0
Lombiq Helpful Libraries - LINQ to DB Libraries for Orchard Core: With the help of this project you can write LINQ expressions and run them with a YesSql ISession extension method to query from the DB instead of writing plain SQL queries. Uses the LINQ to DB project. See the project website for detailed documentation.
Get Started
$ dotnet add package Lombiq.HelpfulLibraries.LinqToDbReadme
LINQ to DB - Lombiq Helpful Libraries for Orchard Core
About
With the help of this project you can write LINQ expressions and run it with an ISession extension method to query from the DB instead of writing plain SQL queries. Uses the LINQ to DB project.
You can watch a demo video of the project here.
For general details about and on using the Helpful Libraries see the root Readme.
Documentation
Use the LinqQueryAsync ISession extension method for running LINQ syntax-based DB queries. Check out its documentation inline.
See LinqToDbSamplesController for an example.
Extensions
You can write custom SQL syntax extensions and functions as you can see it in Extensions/CustomSqlExtensions.cs.
For more examples check out this article.