All Questions
97 questions
0
votes
0
answers
147
views
Stored procedures with Entity Framework, DataAcessLayer vs ModelController
I'm currently building an ASP.NET application using Entity Framework and stored procedures. My original idea was building the application with a data access layer where I call my stored procedures.
...
- 1
0
votes
1
answer
354
views
How to get data from a stored Procedure that joins 3 tables and takes 3 different Parameters asp.net MVC
I have to create something that executes a stored Procedure, and depending on the parameters passed it will show data from different Tables. I am using EF model.
The Parameters are @Username, @...
0
votes
2
answers
2k
views
Implicit conversion from data type datetime to int is not allowed
I have a problem with a stored procedure while running from Entity Framework, using Visual Studio 2014 and SQL Server 2015.
In C# I'm trying to execute it like this:
db.Database.ExecuteSqlCommand(...
- 81
2
votes
0
answers
250
views
C# ERROR CS7036 Entity Framework and stored procedures
I am trying to do a crud with Entity Framework and stored procedures in SQL Server, I have difficulties with the save method and the modify method.
I get the following error when I try to assign my ...
1
vote
1
answer
398
views
Run a SQL Server stored procedure directly from controller
I have this stored procedure in SQL Server:
CREATE PROCEDURE current_call
@call_id int
AS
BEGIN
SET NOCOUNT ON;
SELECT
dbo.Call.call_id, dbo.Call.city, dbo.Call.call_received,
...
- 4,674
0
votes
0
answers
55
views
Get stored procedure output value from SQL Server in ASP.NET with Entity Framework
I have a stored procedure that updates a record, before that check what name to enter does not have another record, in case it registers or will not return a message, which I can not catch in my ...
- 1
0
votes
2
answers
108
views
Entity Framework code-first or database-first when there are a lot of stored procedures
We have some ASP.NET webforms applications, and we want to migrate to ASP.NET MVC 5 and Entity Framework.
We have a lot of stored procedures in SQL Server, so we need to call them in from the ASP.NET ...
-1
votes
1
answer
1k
views
How to call stored procedure in for loop using c#
I want call a stored procedure in a loop, but command time out when use command query, but if use linq then call stored procedure causes a runtime error:
System.Data.Entity.Core.EntityException
...
user9364201
0
votes
1
answer
1k
views
How to call stored procedure with input parameter and fill textbox with output parameter? [closed]
I'm createing a simple ASP.NET MVC web app. I'm trying to call my stored procedure:
ALTER PROCEDURE [dbo].[sp_GetMesData]
@WONo varchar(20)
AS
BEGIN
SET NOCOUNT ON;
SELECT
[...
- 43
1
vote
2
answers
2k
views
Entity Framework - code first, call complex stored procedure
I am new to ASP.NET MVC and Entity Framework code first approach. I want to implement a complex [with INNER JOIN, FUNCTION etc.] stored procedure using this approach. I have gone through many question ...
- 141
-2
votes
1
answer
459
views
Exception when trying to execute a stored procedure in ASP.NET MVC with a Sql-Query
I'm working with Entity Framework but have a hierarchical datasource. It takes too long time to make db-queries and convert to json in the controller.
For that reason, I have a stored procedure.
...
- 1,315
0
votes
1
answer
222
views
How to access result of stored procedure in MVC
We have create stored procedures and imported using entity framework.
For access result of stored procedure there is option to that to create model for each and every property of stored procedure ...
- 168
0
votes
2
answers
1k
views
Entity Framework database first approach having string as return type for stored procedure
I working on an MVC product using Database first entity framework approach, I added a few stored procedure to the EDM, but some are returning string instead of the model type. I have deleted the model....
- 341
0
votes
1
answer
3k
views
Cascading dropdowns using MVC Razor Entity Framework and stored procedures
I am new to MVC and Razor and have looked at so many examples and tutorials of this but have not been able to get it working. It seems so simple but I think the fact that I am trying to use stored ...
- 647
1
vote
2
answers
1k
views
How I can retrieve data from stored procedure in multiple table?
I have a stored procedure in SQL as below:
CREATE PROCEDURE USP_Select
(@id INT)
AS
SELECT * FROM EMO;
SELECT * FROM student WHERE id = @id;
SELECT * FROM tbl1;
RETURN 0
I am ...
- 49