Selecting Many with join

ServiceStack.OrmLite MySql
1

I have

public class PersonEntity {
    [AutoIncrement]
    [PrimaryKey]
    public long Id { get; set; }
    [Reference]
    public List<CarEntity> Cars { get; set; } = new List<CarEntity>();

    //...other relations 
}

public class CarEntity{
    [AutoIncrement]
    [PrimaryKey]
    public long Id { get; set; }

    [References(typeof(PersonEntity ))]
    public long PersonId { get ; set ; }

    [Reference]
    public PersonEntity Person { get; set; }

    public string Description {get;set;}
}

I want to select from PersonEntity where Cars.Description contains some string.
I want to get the PersonEntity with all the other relations it has.

Can you please suggest the most efficient approach for that?

Thannks

2

The general approach is to workout how you’d want to do it in SQL then try to replicate the query in OrmLite. How would you do this with SQL?