Return Multiple Result Sets or DataSet Using Entity Framework

Avoid multiple database round trips by executing a single SQL query in the database, filling DataSet from results, and mapping DataTable to entity list using custom mappers.

Extension methods in Entity Framework help in executing SQL queries and mapping result tables to entity lists, where the mapping depends on property and column names and data types.

Read at CodeProject