Hi I have a entity called Student. I want to retrieve all the records by using EntityColection<Student> object. But I want the return type should be DataTable or DataView as it is necessary for me. How to achieve ?

Hi Saswat,

You can use in-memory projections for Entity collections. here is the link for the documentation about that topic, with an example.

You also could use the EntityView(2) object to create such projections. Read this.

I have found following from documentation

You can also use the entity collection's DefaultView property to create an EntityView<T>. This is similar to the DataTable's DefaultView property: every time you read the property, you'll get the same view object back. This is also true for the entity collection's DefaultView property.

I have tried also but it is not returning DataTable's DefaultView property.

Any suggestion ?

Hi daelmo,

If I will create a view in SQL and use TypedView for multiple data collection then ? 
Which is more efficient ? TypedView or Hierarchy Projection ? 

For fetching the data from the database, a flat view which requires one fetch is more efficient than multiple fetches.