How to use SQL stored procedures with MVC Entity Framework

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

Per @CodeNotFound suggestion.... The return from the TestInsert stored procedure must return the entire result set and not just the SCOPE_IDENTITY()... Not only that but the stored procedure must contain a parameter for each "mapped" field in the entity model. ...My last line it the InsertTest stored procedure looks something like this. ...SELECT...

Calling Oracle stored procedure using Entity Framework with output parameter?

In this case, you shouldn't be calling:...var query = ctx.Database.SqlQuery<CmdRegisterAssetDto>(sql, projectNameParam, countryCodeParam, locationParam, assetRegisteredParam); ...But instead be calling:...var result = ctx.Database.ExecuteSqlCommand(sql, projectNameParam, countryCodeParam, locationParam, assetRegisteredParam); ...Notice that the onl...

Use stored procedures in MVC 5 & Entity Framework 6 code-first

You can do that as shown below....Note:... This is just an example. ...SP...CREATE procedure [dbo].[CountOfOrders] @ProductId int AS SELECT Count(*) From Orders o INNER JOIN OrderDetails od ON od.OrderID = o.OrderID WHERE od.ProductID = @ProductId ...How to call it :...SqlParameter param1 = new SqlParameter("@ProductID", 72); var totalOrders...

Error trying to execute update stored procedure using entity framework core

Here is a method that should meet your requirements:...var parameters = new List<SqlParameter> { new SqlParameter("@PracticeId", assignmentsPracticeId), new SqlParameter("@UserId", assignmentsUserId), new SqlParameter("@AdmissionId", AdmissionId) }; awa...

Generating and accessing stored procedures using Entity framework core

The above examples work fine when executing a Stored Procedure if you are expecting the result set to be the same as any object already defined. But what if you want a resultset that is not supported? According to the developers of EF Core 2, this is a feature that will come, but there is already today an easy solution....Create the model you want ...

Entity Framework Core - Using Stored Procedure with output parameters

Full example of the solution as described above by @Nkosi and partially by @Whistler for the ease of future readers!...In my example, I was trying to execute a stored procedure existed in my database to get specific path....string tableName = "DocumentStore"; string path; var in1 = new SqlParameter { ParameterName = "Ta...

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

I don't' have access to your whole code, but nothing ever gets executed against your queryable source until you try to enumerate it. So, probably it didn't run the Stored Procedure when you tried to get the OUTPUT....To force immediate query evaluation you can do it:... IQueryable<T> foo = _context.Set<T>().FromSql("Sp_Todo @totalItems OUTPUT", new...

Secure way of accessing SQL Stored Procedures from Entity Framework Core

Following comments, I thought I should add a conclusion (Thank you @AlexK via comment). ...If a stored procedure is written using non-parameterized dynamic sql, it is not possible for Entity Framework to protect it. This is not a fault of Entity Framework (which is, in general, very good at sql protection)....Should you find yourself in a similar s...

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

I found the solution using @matt-g suggestion based on this ...Question.... I had to use ADO.net for this as...var technicians = new List<TechnicianModel>(); using (MySqlConnection lconn = new MySqlConnection(_context.Database.GetDbConnection().ConnectionString)) { lconn.Open(); using (MySqlCommand cmd = new MySqlCommand()) { c...

Using Entity Framework and Raw SQL for stored procedures and exception handling

Jeroen's solution is correct. I removed the error handling from the stored procedure and of course I now get an SqlException in my C# code which is want I wanted to see.