How can I create temporary table by entity framework code first

Question

0.00/5 (No votes)

See more:

I want run stored procedure in sql server by EF for example

public IList<Charts> GetDataChart(int id)
        {
            var cmd = "[dbo].[getdatechart] @id";
            var sendId = new SqlParameter("@id", id);
            var result = DataContext.Database.SqlQuery<Charts>(cmd, sendId).ToList();

            return result;


        }

There is error at run time.because Charts is not table and not defined dbcontext.it is only one class that contain proertis.

What I have tried:

how can i create temporary table by Entity framework code first

Posted 21-Oct-18 4:55am

mzandi

Updated 6-Dec-19 23:49pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2018-10-21T09:58:00

Solution 2

Read Entity Framework 6 - Dynamically creating temporary tables from IQueryable (Part 1 of 2)[^]

It's not simple, and requires a lot of extra work.

You might be better off using a stored procedure to do this and modifying your EF code to use the stored procedure instead.

Posted 21-Oct-18 9:58am

Dave Kreskowiak

MadMyche · Answer 2 · 2018-10-21T06:14:00

As I do not use Entity Framework this may be completely wrong- and this answer is based on my experiences with ADO which shares its underpinnings with EF.

What the problem may be is that your database context is assuming that your command is "text", which is the default type and expects the command to be a "SELECT" statement. If you change the definition of your command and define it as a Stored Procedure you may have some success. You may have some success with something akin to this

C#

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "[dbo].[getdatechart]";
cmd.CommandType = CommandType.StoredProcedure;

sharkdevZ · Answer 3 · 2019-12-06T23:49:00

Solution 3

Here is a bit delayed answer.

NuGet Gallery | EF6TempTableKit 1.0.0[^]

There is a code (source & unit tests) on GitHub with a detailed explanation of how to integrate and run EF6TempTableKit extension.

Posted 6-Dec-19 23:49pm

sharkdevZ

Updated 6-Dec-19 23:51pm

v2