Can Entity Framework Core 2 return array or List of int from stored procedure

Stored Procedure returns incorrect scalar value of -1, instead of return value

I am trying to return a scalar value from a stored procedure. I actually want to return the ID of a newly created record, but I have simplified my problem down to a stored procedure that takes an ...int... and attempts to return that same ...int.... This always returns -1. Thank you very much for your help....Web API Controller call ...var idtest ...

How to execute a stored procedure without returning results in Entity Framework 6?

I have a stored procedure like this:...CREATE PROCEDURE InsertTest(@p1 NVARCHAR(50) , @p2 INT) AS BEGIN INSERT INTO dbo.Test(Name, Code) VALUES ( N'', 0) END ...or other ...I try with this code:...context.Database.SqlQuery<int>("InsertTest @p1 , @p2", "a",1); ...But this leads to error....How can I run it using ...DbContext... ?

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

I have a stored procedure written a few years ago that has output parameters and returns a result set. I'm trying to use it in EntityFramework. Initially, when I imported it, the generated code was using ...ExecuteFunction()... to execute the procedure. Using this method, the ...ObjectParameter... objects had the output parameter values. I then...

Entity Framework 7 FromSql stored procedure return value

I am trying to return a value using the new ...FromSql... command in Entity Framework 7. My stored procedure returns a value of 0 if all goes well and 1 if an error occurs. ...Using ...FromSql... with ...DbSet... we can for example do ..._dbContext.ExampleEntity.FromSql('someSproc', 'param') ...How will you get the scalar return value of 0 or 1 fro...

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....

Entity Framework (Database first) has incorrect return result from stored procedure

Environment:...Visual Studio 2017...SQL Server 2016...EF v6 with a database-first approach...Background: the stored procedure is in the EDMX. My stored procedure sets the return value to 0 if nothing happened, 1 if something affected and value of @@ERROR if errors....BACKGROUND 1:... my stored procedure, ...LTM_Lease_DeleteSubFiles..., does ...SET ...

How to call stored procedure with table valued parameter from .net core Entity Framework

I have a stored procedure with table valued parameter. I have to call it from Entity framework in .net core....I couldn't find any API on context object....I have tried with ADO.net API's and it worked but now I have to call it from EF in .net core. Stored procedure which I have to call returning result which I have to catch....My sample SP as belo...

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

I am using ASP.net Core 2.2 with Entity Framework core 2.2.6 and Pomelo.EntityFrameworkCore.MySql 2.2.0 for connectivity with MySQL, I have a stored procedure which takes 3 input parameters and 1 output parameter. I am able to call it in MySQL workbench like...CALL GetTechniciansByTrade('Automobile', 1, 10, @total); select @total; ...Now I want to ...

Execute stored procedure and return List<T> in Entity Framework Core

New to .NET Core. My goal is to return list of employees from my database (as a list or dbset):...public class MyDataContext : DbContext { public MyDataContext(DbContextOptions<MyDataContext> options) : base(options) { } public List<Employee> GetEmployeeList(int EmpId, int DeptId) { // here I want to call my stored p...

Entity Framework Core stored procedure with input parameter and return custom model

I am trying to return a list of students from the stored procedure. I am using ASP.NET boilerplate which uses Entity Framework Core 2.2.x....I am not sure how to execute stored procedure here. I tried to follow ...How to use DbContext.Database.SqlQuery<TElement>(sql, params) with stored procedure? EF Code First CTP5...but I get an error:...Database...