Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
11
Reply
Why .EDMX file does not update a Stored procedure?
Mani Kandan
Oct 21 2016 3:30 AM
1.1k
Reply
Hello Everyone,
1) After updating .EDMX fill in mvc4 by the way Entity Framework, this procedure name not getting like Model.
SP_FinalExposureMonitor_Final_Result,
model class.
Why this?
2) After executing this procedure I want list of items, but now db.
SP_FinalExposureMonitor();
return type is
int
How can I return this procedure with list items?
CREATE
PROCEDURE
SP_FinalExposureMonitor_Final
@SortColumn
varchar
(100)
AS
BEGIN
declare
@dynamicSQL nvarchar(
max
) =
''
;
select
@dynamicSQL = '
select
tempID,ProgramId,ChannelId,
convert
(
date
,Date_DL)asDate_DL,StartTime,EndTime,Viewers,
Tx,TVR,CVR,DVR,
Details_Id,
MastersId,BrandsId,ItemsId,Note,PaidForOrProp,Verbal,Indexes,Seconds,
GradesId,ChannelName,CountryName,WebSiteName,ProductionName,BrandName,ItemName,
Product_company_id,CompanyName,ProductGroupsId,
SectorsId,SubSectoresId,AgenciesId,GroupName,SectorName,SubsectoreName,
AgencyName,agencyID,QualityGrade,CPH_DL,CPH_UN,Country_CPH,Country_UN,
Web_CPH,Web_UN,
AdFactor,Duration_Factor,DaypartName,DaypartId,DaypartFactor,CinemaFactor,DigitalFactor,MediaValue,ROW_NUMBER() over (
order
by
'+ @SortColumn +'
)
AS
RowNum
from
MonitorExposureFinal2;'
execute
sp_executeSQL @dynamicSQL
print @dynamicSQL
END
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
11
)
Next Recommended Forum
How do I add projects of vss to Tfs?
How to add web.config file in Azure?