Geek asks and answers

In Entity framework 4.0, how can we get several recordsets from the database in one call and transfer all the data to the View

In Entity framework 4.0, how can we get several recordsets from a database in one call, as we do in dataset ado.net?

Suppose we have 3 tables T1, T2 and T3. We need to get data from the entire tree table and go to the view (ASP.NET MVC3). There is no JOIN , since they are all independent tables. Instead of making 3 calls to the database, we want the entire select statement in one SP to make only one call to the database and pass all the data for viewing.

In the case of a data set , if the stored procedure returns data from several data sets of the select query, fills each record set in another table.

How can we achieve this in EF? Please help me.

Thank,

Floor

+3
source share
1 answer

EF does not have batch functions for batch requests. But there are some efforts made by others to expand EF to support this.

+2
source

More articles:


All Articles