How to return multiple result set in Entity Framework?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

One can use the following pattern to return multiple result sets:

  • One can make the database in the SQL Server or Local DB and occupy the tables by implementing the comprising script file, STOREDB.sql, utilizing SQL Server Management Studio or SSMS or Visual Studio.
  • Implementation of the script will add 2 collected processes into the database. Choose those procedures from the functions list in the Add tab.
  • Right-click on any blank portion on the Entity Framework developer and choose the Model browser. Now alter the GetProductCM_Result to Product_SprocResult. Save the StoreDBModel.edmx file. Discover the FunctionImportMapping nodes within edmx:Mapping/../En

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Entity framework interview questions

    Explain what is Entity Framework?

    Entity Framework happens to be an open-source ORM or object-relational mapping framework utilized for ADO.Net. It is a set of mechanization that assists in the improvement of data-oriented software ad...

    Entity framework interview questions

    What is new in entity framework 7?

    The new features in entity framework 7 include the following:New platforms: .NET along with the other distinct technologies like WPF, ASP.NET, WinForms is supported by Entity Framework 7.  E...

    Entity framework interview questions

    How to check installed version of Entity Framework?

    To check, If you open up the reference file and detect system.entity.data, click the module and then inspect the runtime version numerical in the Properties explorer and you can witness the subversion...