Introduction

Suppose you define a temp table in a procedure and retrieve the data from the table through the entity framework. It will not be accessible due to the absence of the schema in the EF. Therefore, you should define the table in the database. Below is an example of the procedure:
  1. CREATE PROCEDURE dbo.Demo
  3. AS
  4. BEGIN
  5. SET NOCOUNT ON;
  6. IF 1=0 BEGIN
  7. SET FMTONLY OFF
  8. END
  10. CREATE TABLE #Temp
  11. (
  12. ProductID integer NOT NULL,
  13. Name nvarchar(50) COLLATE DATABASE_DEFAULT NOT NULL
  14. );
  16. INSERT INTO #Temp
  17. ([ProductID], [Name])
  18. SELECT
  19. p.[ProductID], p.[Name]
  20. FROM Production.Product AS p
  22. SELECT
  23. t.[Name], t.[ProductID]
  24. FROM #Temp AS t
  26. DROP TABLE #Temp;
  27. END;

Conclusion

In the above blog, we studied how to add temp table support in an entity framework.