Devaof.DataAccess.Core.SqlBuilder 2.0.0

Example !

Create

public class ExampleProcess : TemplateProcess<ExampleModelInput, List<ExampleModelOutput>>
{
    protected override void CreateOutput(ExampleModelInput input, IDatabaseContext context)
    {
        this.Output = context
         .Select<ExampleModelInput1, ExampleModelInput2>()
         .From<ExampleModelInput1>("T1")
         .LeftJoin<ExampleModelInput2, ExampleModelInput1>((T2, T1) => T2.ID== T1.ID)
         .Where<ExampleModelInput1>(T1 => T1.CODE== "TEST")
         .ExecuteObject<ExampleModelOutput>();            
    }
}

Call

ManagerProcess manager = new ManagerProcess([ConnectString]);
var data = manager.Process<ExampleProcess >().Execute();