Eager Loading for Lazy Blobs

[Silber_Felix]

Is it possible to eager load lazy Blobs, like it's possible for Associations?

For normal, there is no need to load these Blobs immediatly. But there is one part, where I could load them directly without using a second SQL-Statement...

[wlandgraf (Wagner Landgraf)]

That is unfortunately not possible yet.

[Weetch_Russell (Russell Weetch)]

would be a nice addition

[Silber_Felix]

I created this Feature Request
@Weetch_Russell just vote

[Silber_Felix]

I did the following as an efficient workaround:

// Getting Datas:
ObjManager.Find<TEntity>
  .Where(Linq['Active'] = True).List;

// Getting Blobs:
hBlobs := ObjManager.Find<TEntity>
    .Select(TProjections.ProjectionList
      .Add(Linq['Id'])
      .Add(Linq['BlobField'])
    .Where((Linq['Active'] = True) 
      and (Linq['BlobField'].IsNotNull)).ListValues;

  for hBlob in hBlobs do
  begin
    hEntity := ObjManager.Find<TEntity>(hBlob.Values[0]); // this uses the ObjManagers cache, so no SQL is fired...
    hEntity.BlobField:= hBlob.Values[1];
  end;

but this needs 2 selects and I have to check hEntity.BlobField.Available every time I want to only get the loaded Blobs...