TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abhilash J A
535
2.4k
596.3k
Why .EDMX file does not update a Stored procedure?
Oct 21 2016 3:30 AM
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
Reply
Answers (
11
)
How do I add projects of vss to Tfs?
How to add web.config file in Azure?