Calling a stored procedure with nothing to return using Entity Framework

entity-framework

Question

I understand this is the way we call a stored procedure using Entity Framework.

context.Database.SqlQuery<myEntityType>(
    "mySpName @param1, @param2, @param3",
    new SqlParameter("param1", param1),
    new SqlParameter("param2", param2),
    new SqlParameter("param3", param3)
);

But, what if my stored procedure only a has couple of update statements and does not return anything, what should I put instead of myEntityType?

1
20
6/7/2013 6:30:23 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You want context.Database.ExecuteSqlCommand instead of SqlQuery

context.Database.ExecuteSqlCommand(
    "mySpName @param1, @param2, @param3",
    new SqlParameter("param1", param1),
    new SqlParameter("param2", param2),
    new SqlParameter("param3", param3)
);
51
6/7/2013 6:31:11 PM

Related Questions

Why is Entity Framework calling my stored procedure but returning an incorrect value?

I have a stored procedure that simply returns the total number of records divided by whatever value is passed in. This is to aid in pagination on a website....However, I am using the entity framework to bind to that stored procedure and it's returning ...-1... for all calls to it. When I interrogate the stored procedure using SQL Management Studio,...
asp.net c# entity-framework sql-server
asked by Michael J. Gray

Call stored procedure inside transaction using Entity Framework

You can't commit the outer transaction (SaveChanges) before you commit the inner transaction (Complete). I suspect the call to ...SaveChanges... internally commits the inner transaction as well. (Not verified.)
c# entity-framework stored-procedures transactionscope
asked by tne

How to call a stored procedure that returns dynamic columns in Entity Framework?

There is a stored procedure that executes ...exec... command and returns some columns. Columns and number of them are varied. How can I call this stored procedure from Entity Framework?
asp.net c# entity-framework linq sql
asked by sosha

Entity framework and stored procedure with output parameter returning row (EF will receive complex type)

I am using entity framework 6 with stored procedures. Currently I deal with this problem:...Ideally I need to get data from one stored procedure. This data includes: One Conversation (basic info) + multiple Clients (which are engaged in this conversation) + Messages from Conversation....I think that output parameters is right way to do, but i am st...
complextype entity-framework-6 output-parameter row stored-procedures
asked by Richard

Executing a stored procedure that returns a result set and has output parameters with Entity Framework

I apologize, as I am a little bit confused by your problem. ...Let's say you do this before executing your stored procedures.... SqlCommandBuilder.DeriveParameters(_sqlCommand); ...This would put all of the parameters in you sql command object. After executing,... _sqlCommand.ExecuteNonQuery(); ...Any parameter in you stored procedure that had ...
c# entity-framework entity-framework-6 stored-procedures
asked by KonB

How show the return data from stored procedure in MVC using Entity Framework

I am new to MVC and Entity Framework so excuse me if it is simple question. ...I am developing simple project(MVC5-EF6) that query the customer table based on First-name and last-name and return the customer info. I am using Entity Framework to call a stored procedure to return data. ...I have imported the database and everything seems to be workin...
asp.net-mvc asp.net-mvc-5 c# entity-framework-6
asked by Alma

Get return value from stored procedure using ExecuteSqlCommand (using Entity Framework)

I have code that looks like this:...int retval = databaseContext.Database.ExecuteSqlCommand(command, sqlParameters.ToArray()); ...Where databaseContext is of type System.Data.Entity.DbContext...I want to use the return value to know whether or not the stored procedure ran successfuly. Based on ...the documentation...ExecuteSqlCommand... should ret...
azure-sql-database c# entity-framework sql-server stored-procedures
asked by Zain Rizvi

Calling Oracle stored procedure using Entity Framework with output parameter?

I have a simple Oracle stored procedure that gets three parameters passed in, and has one output parameter:...CREATE OR REPLACE PROCEDURE RA.RA_REGISTERASSET ( INPROJECTNAME IN VARCHAR2 ,INCOUNTRYCODE IN VARCHAR2 ,INLOCATION IN VARCHAR2 ,OUTASSETREGISTERED OUT VARCHAR2 ) AS BEGIN SELECT INPROJECTNAME || ', ' || INLOCATION |...
c# entity-framework entity-framework-6 oracle oracle-manageddataaccess
asked by Donny

Calling insert stored procedure using entity framework that has return parameter

I am writing a logic for inserting record using Entity Framework store procedure that will return an int parameter that is TeamId. I have created the function import for the store procedure. Please see the screenshot below...I am not sure how to return the int parameter. Please see the code below...DataAccess layer...public int InsertTeam(string co...
asp.net-web-api entity-framework-6
asked by Tom

Calling existing Stored procedure using Entity Framework 6 with C#

One thing I can tell an issue with is in your method where you call the procedure. You are setting all elements of the array equal to ...param... but you are constantly changing ...param.... All of your elements will be equal to the final state of ...param.... Try this instead:...public void GetEmployeeDataUsingProcedure() { object[] parameters...
.net asp.net-mvc c# entity-framework-6
asked by interesting-name-here

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow