Eager Loading
Posted: Tue 19 Nov 2013 04:25
Hi There,
I'm not sure why this works and the next piece of code doesn't.
This works ok so far, but if I change it to (Adding one more level)
I get the following exception:
I'd really appreciate your help. We've bought the DotConnect for SQLite license.
Thanks
I'm not sure why this works and the next piece of code doesn't.
Code: Select all
Dim LeftProducts = From c In context.Product.Include("Product").Include("Product.Category") _
Where c.x = id
Select cCode: Select all
Dim LeftProducts = From c In context.Product.Include("Product").Include("Product.Category").Include("Product.Suppliers") _
Where c.x = id
Select cI get the following exception:
error code: SQLiteErrorCode.Error
message: SQLite error near "(": syntax error
source: Devart.Data.SQLite
StackTrace:
at Devart.Data.SQLite.a8.a(String A_0, UInt32 A_1, String& A_2)
at Devart.Data.SQLite.bs.p()
at Devart.Data.SQLite.ag.e()
at Devart.Data.SQLite.SQLiteDataReader.c()
at Devart.Data.SQLite.SQLiteCommand.InternalExecute(CommandBehavior behavior, IDisposable statement, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.SQLite.Entity.t.a(CommandBehavior A_0)
at Devart.Common.Entity.v.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
TargetSite:
{System.Data.Common.DbDataReader ExecuteStoreCommands(System.Data.EntityClient.EntityCommand, System.Data.CommandBehavior)}
I'd really appreciate your help. We've bought the DotConnect for SQLite license.
Thanks