Skip to main content

Return to Question

Code formatting
Source Link
diiN__________
diiN__________
  • 7.7k
  • 7
  • 49
  • 74
var queryResult = CurrentSession.Set<SomeType_T>().Include(a => a.SomeType1_T)   .Include(a => a.SomeType1_T.Catalog_Type_T)   .Include(a => a.SomeType1_T.SomeType4_T)   .Include(a => a.SomeType1_T.SomeType2_T)   .Include("SomeType1_T.SomeType2_T.SomeType3_T")   .Include(a => a.SomeType1_T.SomeType4_T.SomeType5_T)   .Include(a => a.SomeType1_T.SomeType5_T)   .Include(a => a.SomeType1_T.Questions_T)   .Include(a => a.SomeType1_T.Questions_T.Question_Type_T)   .Include(a => a.SomeType1_T.Members_T)   .Include(b => b.SomeMasterType_T)   .Include(b => b.SomeMasterType_T.SomeMasterType1_T)   .Include(c => c.SomeType6_T)   .Include(d => d.SomeType7_T)   .Include(d => d.SomeType8_T)   .Include(d => d.SomeType8_T1)   .Where(t => t.SomeType9_T == _MatchThisKey); 
var queryResult = CurrentSession.Set<SomeType_T>().Include(a => a.SomeType1_T)   .Include(a => a.SomeType1_T.Catalog_Type_T)   .Include(a => a.SomeType1_T.SomeType4_T)   .Include(a => a.SomeType1_T.SomeType2_T)   .Include("SomeType1_T.SomeType2_T.SomeType3_T")   .Include(a => a.SomeType1_T.SomeType4_T.SomeType5_T)   .Include(a => a.SomeType1_T.SomeType5_T)   .Include(a => a.SomeType1_T.Questions_T)   .Include(a => a.SomeType1_T.Questions_T.Question_Type_T)   .Include(a => a.SomeType1_T.Members_T)   .Include(b => b.SomeMasterType_T)   .Include(b => b.SomeMasterType_T.SomeMasterType1_T)   .Include(c => c.SomeType6_T)   .Include(d => d.SomeType7_T)   .Include(d => d.SomeType8_T)   .Include(d => d.SomeType8_T1)   .Where(t => t.SomeType9_T == _MatchThisKey); 
var queryResult = CurrentSession.Set<SomeType_T>().Include(a => a.SomeType1_T) .Include(a => a.SomeType1_T.Catalog_Type_T) .Include(a => a.SomeType1_T.SomeType4_T) .Include(a => a.SomeType1_T.SomeType2_T) .Include("SomeType1_T.SomeType2_T.SomeType3_T") .Include(a => a.SomeType1_T.SomeType4_T.SomeType5_T) .Include(a => a.SomeType1_T.SomeType5_T) .Include(a => a.SomeType1_T.Questions_T) .Include(a => a.SomeType1_T.Questions_T.Question_Type_T) .Include(a => a.SomeType1_T.Members_T) .Include(b => b.SomeMasterType_T) .Include(b => b.SomeMasterType_T.SomeMasterType1_T) .Include(c => c.SomeType6_T) .Include(d => d.SomeType7_T) .Include(d => d.SomeType8_T) .Include(d => d.SomeType8_T1) .Where(t => t.SomeType9_T == _MatchThisKey);
Source Link
Kashif Khan
Kashif Khan
  • 693
  • 2
  • 12
  • 32

Entity Framework .include Performance Issue

I have the below query which is tremendously slow. I am new to Entity Framework and I believe it has got to do something with Eager Loading, Lazy Loading or Explicit Loading. Need help optimize the below C# statement.

var queryResult = CurrentSession.Set<SomeType_T>().Include(a => a.SomeType1_T) .Include(a => a.SomeType1_T.Catalog_Type_T) .Include(a => a.SomeType1_T.SomeType4_T) .Include(a => a.SomeType1_T.SomeType2_T) .Include("SomeType1_T.SomeType2_T.SomeType3_T") .Include(a => a.SomeType1_T.SomeType4_T.SomeType5_T) .Include(a => a.SomeType1_T.SomeType5_T) .Include(a => a.SomeType1_T.Questions_T) .Include(a => a.SomeType1_T.Questions_T.Question_Type_T) .Include(a => a.SomeType1_T.Members_T) .Include(b => b.SomeMasterType_T) .Include(b => b.SomeMasterType_T.SomeMasterType1_T) .Include(c => c.SomeType6_T) .Include(d => d.SomeType7_T) .Include(d => d.SomeType8_T) .Include(d => d.SomeType8_T1) .Where(t => t.SomeType9_T == _MatchThisKey);