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.
Use the LinqQueryAsync ISession extension method for running LINQ syntax-based DB queries. Check out its documentation inline.
See LinqToDbSamplesController for an example.
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.