Lombiq Helpful Libraries - LINQ to DB Libraries for Orchard Core

December 15, 2022 ยท View on GitHub

About

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.

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.