All Questions
10 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 ...
-1
votes
1
answer
2k
views
C# & ASP.NET MVC 5 - execute stored procedure from button click with no return values
I'm trying (I'm in need to) to create small web application to manage some ETL processes giving my users few buttons to view SQL Server data and run few SSIS Packages.
I was able to handle the ...
- 31
2
votes
1
answer
4k
views
Executing a SQL Server stored procedure with c# linq without a DBSet
I am working on a project at the moment and for this part that I am working on I am required to call a stored procedure that returns a TicketNumber string in the format TodaysDate.Number (e.g. ...
- 69
0
votes
0
answers
282
views
Asp.net MVC 5 stored procedure resulting in empty complex type
I'm using asp.net mvc 5 with mysql. I have a stored procedure that takes 3 parameters and returns 3 columns given below
DELIMITER //
CREATE PROCEDURE ReportUsProjectWorkHours(IN userID INT(11), ...
- 45
0
votes
5
answers
241
views
Stored procedure way or Entity Framework way to connect to database [duplicate]
Which way should I use to create a scalable system in C# ASP.NET MVC 5 ?
Should I use stored procedure way or Entity Framework way to connect to database?
One of our head is insisting to use stored ...
- 23
7
votes
4
answers
7k
views
MVC 5, EF 6, and "Code First from Database" Stored Procedures
In searching for an answer, even with the keywords "Code First from Database" in quotes, I found that the answers did not address the specific terms, so I'm asking the question with a specific ...
user4864716
0
votes
0
answers
71
views
SqlException expecting parameter when passed
I am getting a SqlException
Procedure or function 'GetDashboardData' expects parameter '@userID', which was not supplied.
I have been trying to follow this post, however does not seem to cater for ...
- 1,320
0
votes
1
answer
977
views
Calling Stored Procedure with Parameter and Multiple Result Set Entity Framework 6
I have a stored procedure uspGetProductAndCategory which is accepting a parameter @SupplierID and returns the products, categories and suppliers [these tables from the NorthWindDatabase].
My problem ...
- 952
0
votes
1
answer
267
views
Return data from stored procedure that contains multiple queries in EF6/MVC5
If I have a stored procedure with multiple queries called using different “actions” it seems like EF can’t find all the queries and make a complex type that reflects them. It looks like it just took ...
- 57
2
votes
0
answers
918
views
Create new stored procedure using code first
I want to be able to create a new stored procedure with code first using MVC5 EF6.
All resources I've found are for mapping existing stored procedures.
I have found this article that generates ...
user3954235