All Questions
Tagged with stored-procedures entity-framework
961 questions
0
votes
0
answers
56
views
Transport-level error when sending the request to the server(provider: Session Provider, error: 19 - Physical connection is not usable)in ASP.NET MVC5
I am encountering an intermittent issue in my ASP.NET MVC 5 application, where the following error occurs only in production, but not in my development environment (localhost):
A transport-level ...
0
votes
0
answers
67
views
No complex type created after updating the stored procedure
I have 1 stored procedure returning a complex type that was showing earlier with a suffix _Result. Then I updated the procedure and went to my .edmx file and deleted that procedure from these 3 places:...
- 409
0
votes
1
answer
40
views
Capture all queries running within a timeframe
My application is inserting duplicate records and I'm trying to figure out what causes that. It could be coming from the UI application, some stored proc or a nightly SQL job. I have looked into ...
- 339
1
vote
1
answer
206
views
Stored procedure output parameter value is null (entity framework)
I am trying to call a stored procedure from entity framework but I am unable to get the output parameter value. It is always returning null.
Here is my code
object[] parameters = {
new ...
- 11
0
votes
1
answer
527
views
Convert SQL stored procedure to Linq
I created the following stored procedure:
PROCEDURE [dbo].[LeadScoring_CountClosedActions]
(@UserId INT,
@StartDate INT,
@EndDate INT)
AS
BEGIN
SET NOCOUNT ON
SELECT TOP 1
...
- 58.5k
0
votes
2
answers
494
views
Getting error 'ExecuteFunction only supports stored procedures that have a return type' when calling a stored procedure using EntityFramework
In my .Net application using Entity Framework I have added a SP to my entity schema. I call my SP like so
ObjectContext.ExecuteFunction<ReturnTypeObject>("StoredProcedure",
param1,...
- 29
0
votes
0
answers
29
views
How to call an Oracle system stored proc from a c# EF API?
I need to call two system stored procedures in an Oracle database to refresh materialised views when a C# API executes a related process. My code attempts to do so get the following error:
ORA-06512: ...
- 1,960
0
votes
0
answers
120
views
C# DataTables from stored procedure using dbContext
I have a very complex stored procedure that is definitely returning values when I run ExecuteReader but when I try to load the data, it seems to disappear.
using (var dbContext = new ...
0
votes
0
answers
97
views
Getting error while running stored procedure from DbContext in C#
I am trying to run the SQL Server procedure from C#:
try
{
ExecWithStoredProcedure("storedprocName @Message, @ProviderCode", message, providecode);
}
catch(Exception ex)
{
}
public int ...
- 3
0
votes
0
answers
209
views
Can't drop or alter a PROCEDURE from within another stored routine - EF Core Migrations
I'm trying to run a SP in MySQL to apply an EF Core Migration conditionally.
In my script I do the following:
DROP PROCEDURE IF EXISTS MigrationsScript;
DELIMITER //
CREATE PROCEDURE MigrationsScript()...
- 18
0
votes
0
answers
244
views
EF fill a list using a Select Stored procedure
I have a DB first project approach in my project. Tables are created in the DB and their is no DBset reference to them in the code. All operations are via a stored procedure. I need to create a C# ...
- 351
1
vote
0
answers
238
views
Multiple selects in an SQL Server stored procedure called inside .NET Core
I have a working SQL Server stored procedure executed in .NET Core that yields some results.
The procedure is called in this way:
var point = new SqlParameter("postCodePointBinary", System....
- 443
0
votes
0
answers
108
views
How do I create a method binding a stored procedure in Entity Framework 6?
How do I create a function mapping a SQL stored procedure?
I have tried
var order = context.CustomerDetails.SqlQuery("DisplayTotalOrders @CustomerID", new SqlParameter("CustomerID",...
- 1,670
0
votes
0
answers
733
views
Passing a Data table to stored procedure - C#
I am constructing a data table and passing it as a parameter to the stored procedure. After execution, the stored procedure will provide a result set.
@RefData is the Table parameter name.
CREATE TYPE ...
- 27
0
votes
0
answers
27
views
Print an SQL message in a C# WPF Application [duplicate]
i wrote a stored procedure in SQL server Management Studio like this :
Then I'm using it in a C# WPF Application with an Entity Framework DataModel :
public static void AdressagePalettesEntr(int ...
