SQL for Sqlite could not be generated

[jogibear9988]

Describe your issue

Try this code:

			var qryA = from infeed in db.GetTable<InfeedAdvicePositionDTO>()
					   select new
					   {
						   InfeedAdvicePosition = infeed,
						   CurrentQuantity = db.GetTable<InventoryResourceDTO>().Where(x => x.InfeedAdviceID == infeed.Id).Sum(x => x.Quantity),
					   };

			var qryB = from oto in qryA
					   select new
					   {
                                                         oto,
						   InfeedAddons =
							   (from ir in db.GetTable<MlogInfeedAddonsDTO>()
								where ir.Id == oto.InfeedAdvicePosition.Id
								select ir).DefaultIfEmpty().FirstOrDefault(),
					   };

			var l = qryB.First();

Exception message: System.InvalidOperationException: 'Operation is not valid due to the current state of the object.'

We get this, cause we use GetGenericMethod of a Non generic Method.

Steps to reproduce

Look at my pull request

[jogibear9988]

On our server the query works for mssql server

[jogibear9988]

[jogibear9988]

@sdanyliv seems to be an error with eager loading

[jogibear9988]

I could fix it by changeing

					if (mc.IsQueryable() && mc.Method.IsGenericMethod)

here:

linq2db/Source/LinqToDB/Linq/Builder/EagerLoading.cs

Line 1893 in b6d5f78

if (mc.IsQueryable())

with this change the test works and retrieves data

[jogibear9988]

but I don't know if it is the correct fix

[jogibear9988]

with my change it creates following sql:

SELECT
    [oto].[Id],
    (
	    SELECT
		    Sum([x].[Quantity])
	    FROM
		    [InventoryResourceDTO] [x]
	    WHERE
		    [x].[InfeedAdviceID] = [oto].[Id]
    )
FROM
    [InfeedAdvicePositionDTO] [oto]
LIMIT @take