EFCore Console Application
Creating the Data Model
There are two approaches that can be taken in creating the context and entity classes for your application. With the Code-First Approach approach, you can fine-tune your model by writing the classes manually. Alternatively, you can make use of Reverse Engineering (Scaffolding) to generate these classes automatically from your Act-On schema.
Perform LINQ Commands in Your Code
After Entity Framework Core is set up and the Act-On provider is registered, you can execute LINQ in your code.
using System.Linq;
using MySolutionName.Models;
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); // Include this if you would like to use code pages not bundled in .NET Standard.
ActOnContext ents = new ActOnContext();
var ImagesQuery = from Images in ents.Images
orderby Images.Name
select Images;