Stored procedure has to many arguments specified entity framework

entity-framework entity-framework-6 stored-procedures

Question

I'm using Entity Framework 6 with Stored Procedures mapping. I have an insert sp with 6 parameters for the insert. The entity that I insert has 8 properties where one property is the Id.

The problem is that I get this error:

Procedure or function sp has too many arguments specified

The reason why I won't insert the last property is because this would have a default value of 0 (bit) and another system would change that bit.

When I use NotMapped as attribute above the property the sp is succeeding but then I'm unable to query the data out of the system.

So is there someway I could ignore a parameter?

1
1
1/17/2014 7:55:01 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Ok, you say you have a Stored Procedures with 6 parameters for the insert and that the entity that you are inserting has 8 properties where one property is the Id.

So that leaves you with 7 properties, right? but the Stored Procedure has 6 parameters!, so clearly the Procedure or function sp has too many arguments specified

Ok may be you could have a look at this http://hammadk.wordpress.com/2012/01/27/solved-procedure-xxx-has-too-many-arguments-specified-asp-net/

1
1/17/2014 9:01:52 AM

Related Questions

Add stored procedure to entity framework model (.edmx) without refreshing existing entities

I have a stored procedure in development environment that I want to add to EF data model (.edmx) and call it in my code through a method wrapper that EF creates. ...Our development environment is not 100% in sync with production one so when I try adding the stored procedure deployed to development environment using "Update Model From Database" menu...
c# entity-framework entity-framework-6
asked by Art

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

Stored procedure whose result set lacks a primary key won't execute with Entity Framework 6

I'm calling a stored procedure whose result set has no primary key, and no candidate keys. I created an entity called ...Foo... to represent a record in the results set, so the stored procedure will result in a ...List<Foo>.... The entity looks something like this:...public class Foo { public Guid FooID { get; set; } public Guid AnotherFoo...
c# entity-framework entity-framework-6 stored-procedures
asked by alex

Entity Framework code-first error when using stored procedure with fields that have default value

I need to insert an entity by calling a stored procedure. The table in the database has a column called ...CreateDateTime... that has a default value of ...GetDate().... ...I do not let the stored procedure set / update the ...CreateDateTime... column. ...When I call the ...dbcontext.SaveChanges()... it does indeed call my stored procedure and it ...
c# entity-framework entity-framework-6 sql-server stored-procedures
asked by goroth

how to include stored procedures with Entity Framework Reverse POCO Generator version 2.14.3

I am using the Entity Framework Reverse POCO Generator version 2.14.3 and I would like to include only stored procedures with name starts "usp_CMT_update*" in Apps schema. I used default settings for stored proocedure in the .tt file but only some of them were generated. I also tried regex pattern but still didn't get the stored proc generated. P...
entity-framework entity-framework-6 poco sql-server stored-procedures
asked by user266909

Migrations in Entity Framework Core 2.0 - How to specify environment or pass arguments

I'm playing with EF Core 2.0 and have 3 env in my app: dev, staging and prod. Now I want to apply db schema to specific database. However I faced with a problem. When I executing ...dotnet ef database drop (update)... for example, it's trying to get production env by default....How could I specify what environment should be used? My DbContextFactor...
asp.net-core c# entity-framework entity-framework-core
asked by silent_coder

Entity framework core Output parameter not working in store procedure using FromSql method (Linq)

I am trying to get output value from the ...dbcontext... using the method ...FromSql(...).......If i execute it on SSMS, it works but not working in EF core....My SP param:... @totalItems VARCHAR(MAX) OUTPUT ...I've removed other params for readable and point out the issue. The records are coming but the ...OUTPUT... parameter is always ...null....
c# entity-framework-core linq sql sql-server
asked by Robin

Procedure Or Function SpAddDepartment Has Too Many Arguments Specified

Problem...I get an error ...Procedure or function spAddDepartment has too many arguments specified...How to solve it?...Details: when inserting data into table ...department... using stored procedure ...spAddDepartment... using fluent api in ASP.NET MVC 5, I get that error mentioned above....Table ...Departments...:...CREATE TABLE [dbo].[Department...
asp.net-mvc c# ef-fluent-api entity-framework entity-framework-6
asked by ahmed salah

Why stored procedure out parameter is not getting read by entity framework's ExecuteSqlCommand method?

I am trying to read the OUT parameters value returned by stored procedure but it throws error ...DBNULL.... Even the procedure is returning the value....Code:... int? outParam= 0; SqlParameter sqlParam= new SqlParameter("@model", user.Name+" Model"); SqlParameter sqlParamOut = new SqlParameter("out", outParam); sqlParamOut.DbType = Syst...
c# entity-framework entity-framework-6 sql sql-server
asked by azure boy

How to call stored procedure in Entity Framework Core with input and output parameters using mysql

Can you try below things....Use exec instead of call...var results = await _context.GetTechnicians.FromSql("EXEC GetTechniciansByTrade(@MyTrade, @PageIndex, @PageSize, @PageCount OUTPUT)"...Select PageCount in stored procedure...I got information from this github ...issue....
entity-framework-core input-parameters mysql output-parameter stored-procedures
asked by cdev

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