Tutorial :Loading partial entities with Linq to Entities



Question:

I am trying to load a partial entity with Linq to Entities:

Dim contacts = From c In My.Context.Contacts _       Select New Contact With { _           .ContactId = c.ContactId, _           .Name = c.Name       }  

I tried it and I get the following NotSupportedException: "The entity or complex type 'CompleteKitchenModel.Contact' cannot be constructed in a LINQ to Entities query."

Thanks


Solution:1

You'll have to use anonymous type:

Dim contacts = From c In My.Context.Contacts _   Select New With { _       .ContactId = c.ContactId, _       .Name = c.Name   }  

and then copy data to Contact list:

For Each contact In contacts           Dim c As New Contact With { .ContactId = c.ContactId, .Name = c.Name}       //Add to list  Next  

Your syntax, as error says, is not supported.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »