All Questions
13 questions
1
vote
0
answers
62
views
MVC 4, Entity Framework 5: Result set will return unfixed number of columns
I have a requirement to get payroll data from database and generate report in excel format.
The first 10 columns are employee data, no issue. The issue is starting from column 11, it's payroll data. ...
- 953
0
votes
1
answer
688
views
Passing formatted string and actual parameters to stored procedure from C#
I execute a stored procedure as follows:
exec SALESREPORTFORWEB
@StartDate = '03/20/2017', @EndDate = '03/21/2017'
Stored Procedure
CREATE proc [dbo].[SALESREPORTFORWEB]
--...
- 97
0
votes
0
answers
1k
views
calling stored procedure using entity framework database first approach
I have been stuck on executing a stored procedure through asp.net mvc. I'm using Entity Framework version 5, database first approach. I want to execute a stored parameters whose parameters are passed ...
- 173
1
vote
0
answers
286
views
why EF 6 stored procedure/Function Import cannot be programmed asynchronously?
I have made a ton of search more than 2 weeks but could not find an answer.
There are loads of scenario in stack overflow... but none has given a right answer.
So, in simple words, are stored ...
- 11
1
vote
1
answer
2k
views
How to pass optional parameters to stored procedure using Entity Framework?
I have the below stored procedure which returns 1000 rows.
ALTER PROC [dbo].[PROC_Insights_offinvoice_taxmaster]
@PROC_TYPE VARCHAR(50),@SEARCHBY VARCHAR(50) = NULL , @SEARCHVALUE VARCHAR(250) = ...
- 10.4k
0
votes
2
answers
745
views
Retrieve list/rows of values from "select" stored procedure , where stored procedure Function is auto generated from Entity Framework
How to retrieve list/rows of values from "select" stored procedure Function , where stored procedure Function is auto generated from Entity Framework
I can't retrieve list of values from Stored ...
user5047233
0
votes
1
answer
2k
views
Return the result of dynamic sql in stored procedure using entity framework
I want to return the result of sql dynamic in stored procedure. This Stored Procedure is used in entity framework, when I try to create a complex type the procedure returns no columns. Is there any ...
- 39
1
vote
0
answers
299
views
Storing results in var returned from stored procedure which uses temp table in mvc Entityframework showing error
I have Created Stored Procedure which uses Temp Table to store some fields and update those fields based on condition.
when i import this stored procedure in report data set fields are not displayed.....
- 26
0
votes
1
answer
4k
views
ASP.NET MVC 4 can't find stored procedure
I am working with ASP.NET MVC 4. I am using two databases, my database and the default database for the login and registration.
Everything was excellent and I could call my stored procedures, until I ...
- 7,719
0
votes
1
answer
476
views
How to save values in different tables from single view using MVC4
Hey I am new in MVC and I am trying to creat a demo application in mvc4 with below description
Create a view with five fields
(a) Student Name
(b)Student Father Name
(c)Student Mother Name
(d) ...
- 792
0
votes
3
answers
2k
views
Cobination of mvc 4,entity framework, stored procedures is the right way?
We are doing a new project, for all devices and browsers compatibility we have decided to use asp.net mvc 4, Html5, css 3, for communicating with Database Entity Framework we want to use.
Our senior ...
0
votes
2
answers
512
views
is it the right way to do the project with asp.net mvc 4 and stored procedures?
Can you please spend ur time 4 this and help me as it is a big project if we do mistakes noe we will repeat the same mistake in next 3 years.
we are starting a new big project in asp.net mvc4, Html5 ...
- 21
1
vote
2
answers
1k
views
MVC4 Stored Procedure returns results, but MVC shows the lookup field values are null
My proc returns all results but MVC is showing the lookups are null.
I have a VIEW where the "grid" for loop looks like this:
@foreach (var item in Model) {
<tr>
<td>@Html....
- 315