Execute procedure with CodeFirst

Navigation
1

I'm trying to run a procedure in ASP.NET MVC with CodeFirst. I saw some examples on the internet but they are not working, can anyone help me? 

    public void Copiadados(int Cod_Cli, int Cod_Obra)
    {
        SqlParameter p1 = new SqlParameter("@Cod_Cli", SqlDbType.Int);
        SqlParameter p2 = new SqlParameter("@Cod_Obra", SqlDbType.Int);

        p1.Value = Cod_Cli;
        p2.Value = Cod_Obra;

        Database.ExecuteSqlCommand("ProcName @Cod_Cli, @Cod_Obra", p1, p2);
    }
    
asked by anonymous 13.08.2014 / 19:55

1 answer

2
  

Warning : Running Stored Procedures on projects that use Entity Framework Code First can be considered a bad practice, since the logic that should be in the application will be in the database, causing inconsistencies and bad system.

Your code is almost right. The word 'context' was missing before Database . 

public void Copiadados(int Cod_Cli, int Cod_Obra)
{
    SqlParameter p1 = new SqlParameter("@Cod_Cli", SqlDbType.Int);
    SqlParameter p2 = new SqlParameter("@Cod_Obra", SqlDbType.Int);

    p1.Value = Cod_Cli;
    p2.Value = Cod_Obra;

    context.Database.ExecuteSqlCommand("ProcName @Cod_Cli, @Cod_Obra", p1, p2);
}
    
13.08.2014 / 22:00
After clicking on any ListActivity item, the first record is always loaded ___ ___ erkimt Improves performance - Ruby on Rails ______ qstntxt ___

I have 3 tables:

[users] 1 ----------- n [evaluations] n --------- 1 [items]

Where evaluation can be positive (valuation: true ) or negative (valuation: false ), I need a method that returns all items that the user liked and did not like ... For this I did the following method in the user model:

%pre%

The same principle was adopted for the method for the dislike method

The idea is to do this with many users, the problem is that it is taking a long time to return the data. Is there any way to improve the performance of this code snippet? Any structure that I can keep on the server, because this query is executed many times more than once per user ...

    
______ azszpr28800 ___

I had the idea of trying to do directly in the bank to simplify the process and modified the function to:

%pre%

I've had an improvement of 0.2 seconds in the average ... I'm putting it as an answer because I do not think it will improve more than that, but if someone wants to prove me to the contrary the answer will be very welcome!     

______ azszpr36666 ___

Would not it be less expensive if you paginated? You can use the library link so it will return the paged items I believe will shorten the search time.

    
___