CODEWITHSUNDEEP
c#linq-to-sql
newbieThreePointOH
newbieThreePointOH

Reputation: 25

LINQ select table without any references

Is there a way to only select one table with any references?

Because with my current code the DataContext returns a Types object. But LINQ adds a property on it called campaign and in that property there are all other references. So i takes forever when i am requesting data from my restapi controller, cause it needs to load all references. But i only want the Table i was asking for.

Current code:

[HttpGet]
[Route("Typs")]
public IHttpActionResult Typs()
{
   crmDataContext crmDC = new crmDataContext();
   jsSettings = ReferenceLoopHandling.Ignore;

   return Json(crmDC.Typs), jsSettings);
}

Typs propertys that i have defined in my database

public class Typs 
{
   public int id;
   public string text;
}

Typs propertys that linq made for my c# code

public class Typs 
{
   public int id;
   public string text;
   public campaign campaign;
}

Upvotes: 2

Views: 682

Answers (1)

Derviş Kayımbaşıoğlu
Derviş Kayımbaşıoğlu

Reputation: 30545

It does'nt make sense. You must used Include() or explicit loading .Collection(p => p.Posts).Load(); otherwise related entities are not loaded.

Futhermore you dont need to add ReferenceLoopHandling.Ignore; if you are not goind to load related entities which in turns references the table itself.

Upvotes: 1

Related Questions