Entity Framework Projections

Question

We are exploring the Entity Framework to make sure it meets our specific needs. Here is a script that interests me:

I have a large table (let it be called VeryWideRecord) that has many columns and has a corresponding business object (it is also called VeryWideRecord). I would like to be able to query my database for the VeryWideRecord business object, but it only has values ​​for specific columns returned by base SQL. Can I do this using Entity Framework?

I'm not sure if this can be done with the Entity Framework table split function, because the application should be able (at runtime) to modify the requested columns. The reason for this is because we are trying to minimize the amount of information passing through the wire.

I see how this can be done using NHibernate ( example ), but how can I do this using the Entity Framework?

Answer 1

It looks like you can achieve what you are looking for with the SQL entity. Below is the link:

http://msdn.microsoft.com/en-us/library/bb738683.aspx

Answer 2

Something like this (in VB.NET:

Dim pl As New List(Of VeryWideRecord)(
     (From p In db.VeryWideRecords 
      Select New With {.RecID = p.RecID}
     ).ToList().Select(
       Function(r)
         Return New VeryWideRecord With {.RecID = r.RecID}
       End Function))

. , eSQL, , . , Entity Framework, , .