/// <summary>
/// Obtains the object from the database and fetches all the properties annotated with
/// any subclass of <c>RelationshipAttribute</c>. If the object with the specified primary key doesn't
/// exist in the database, an exception will be raised.
/// </summary>
/// <returns>The object with all the children loaded</returns>
/// <param name="conn">SQLite Net connection object</param>
/// <param name="pk">Primary key for the object to search in the database</param>
/// <param name="recursive">If set to <c>true</c> all the relationships with
/// <c>CascadeOperation.CascadeRead</c> will be loaded recusively.</param>
/// <typeparam name="T">Entity type where the object should be fetched from</typeparam>
public static T GetWithChildren <T>(this SQLiteConnection conn, object pk, bool recursive = false) where T : new()
{
var element = conn.Get <T>(pk);
conn.GetChildren(element, recursive);
return(element);
}
/// <summary>
/// The behavior is the same that <c>GetWithChildren</c> but it returns null if the object doesn't
/// exist in the database instead of throwing an exception
/// Obtains the object from the database and fetch all the properties annotated with
/// any subclass of <c>RelationshipAttribute</c>. If the object with the specified primary key doesn't
/// exist in the database, it will return null
/// </summary>
/// <returns>The object with all the children loaded or null if it doesn't exist</returns>
/// <param name="conn">SQLite Net connection object</param>
/// <param name="pk">Primary key for the object to search in the database</param>
/// <param name="recursive">If set to <c>true</c> all the relationships with
/// <c>CascadeOperation.CascadeRead</c> will be loaded recusively.</param>
/// <typeparam name="T">Entity type where the object should be fetched from</typeparam>
public static T FindWithChildren <T>(this SQLiteConnection conn, object pk, bool recursive = false) where T : new()
{
var element = conn.Find <T>(pk);
if (!EqualityComparer <T> .Default.Equals(element, default(T)))
{
conn.GetChildren(element, recursive);
}
return(element);
}
/// <summary>
/// Fetches all the entities of the specified type with the filter and fetches all the relationship
/// properties of all the returned elements.
/// </summary>
/// <returns>List of all the elements of the type T that matches the filter with the children already loaded</returns>
/// <param name="conn">SQLite Net connection object</param>
/// <param name="filter">Filter that will be passed to the <c>Where</c> clause when fetching
/// objects from the database. No relationship properties are allowed in this filter as they
/// are loaded afterwards</param>
/// <param name="recursive">If set to <c>true</c> all the relationships with
/// <c>CascadeOperation.CascadeRead</c> will be loaded recusively.</param>
/// <typeparam name="T">Entity type where the object should be fetched from</typeparam>
public static List <T> GetAllWithChildren <T>(this SQLiteConnection conn, Expression <Func <T, bool> > filter = null, bool recursive = false) where T : new()
{
var elements = conn.Table <T>();
if (filter != null)
{
elements = elements.Where(filter);
}
var list = elements.ToList();
foreach (T element in list)
{
conn.GetChildren(element, recursive);
}
return(list);
}