On updating model from database I don't get _Result.cs file generated automatically.
Hi I have below stored procedure. When I update my model I don’t get _Result.cs file auto generated can anyone please help why I am not getting auto generated file?
I tried with selecting the temp table with
'cast(null as int) as ID' but that also didn't help me
Below is the Sp :
<pre>USE [abcFinal]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[getsdetails3]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[getsdetails3]
GO
USE [abcFinal]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- exec [dbo].[getsdetails3] '',7,14,1,850
CREATE procedure [dbo].[getsdetails3]
(
@cityname nvarchar(200),
@cityid int,
@stateid int,
@catsubcatid int,
@visitcount int
)as
begin
Declare @Error int
--SELECT 38 / 5 AS Integer, 38 % 5 AS Remainder ;
--vsd.srid,vsd.Logoimg,vsd.Skinimg,vsd.title,vsd.statename,
--,vsd.cityid,vsd.cityname,vsd.stateid,vsd.countryid,vsd.countryname,vsd.street
--- Lets Start The Transaction
BEGIN TRAN
select
vsd.Logoimg,
REPLACE(vsd.Skinimg,'../','/') Skinimg,
vsd.title,vsd.statename,vsd.cityid,vsd.cityname,vsd.stateid,vsd.countryid,vsd.countryname,vsd.street,
vsd.SID srid,
vsd.CategoryId,
RANK() OVER
(
PARTITION BY vsd.CategoryId
ORDER BY vsd.CategoryId,vsd.SID,@visitcount DESC) AS catRank
,vsd.CatOrSubCatName,0 AS Isselected
INTO #tmp
from
VwSellerDetails vsd
where
CASE
WHEN @CityId IS NOT NULL
THEN vsd.cityid ELSE vsd.stateid END=
CASE
WHEN @CityId IS NOT NULL
THEN @CityId ELSE @StateId END
AND vsd.categoryid=CASE WHEN @catsubcatid IS NOT NULL THEN @catsubcatid ELSE vsd.categoryid END
--SELECT * from #tmp
select DISTINCT CategoryId INTO #tmpcat FROM #tmp
--select * from #tmpcat
--- create Cursor For #tmpFieldDetails
DECLARE @CategoryId int
DECLARE @maxcatrank int
DECLARE @IsselectedId int
DECLARE Curtmpcat CURSOR FOR
SELECT CategoryId FROM #tmpcat
SET @Error=@@ERROR
IF @Error <> 0
BEGIN
GOTO Error_Handle
END
--- open cursor
OPEN Curtmpcat
FETCH Curtmpcat INTO @CategoryId
SET @Error=@@ERROR
IF @Error <> 0
BEGIN
GOTO Error_Handle
END
-- Strat The loop
WHILE (@@FETCH_STATUS=0)
BEGIN
select @maxcatrank=MAX(catrank) from #tmp where CategoryId=@CategoryId
IF(@visitcount >@maxcatrank)
BEGIN
--UPDATE #tmp
--SET Isselected=1
--WHERE CategoryId=@CategoryId
--AND catrank=1
SET @IsselectedId=@visitcount%@maxcatrank
--SELECT @IsselectedId
UPDATE #tmp
SET Isselected=1
WHERE CategoryId=@CategoryId
AND catrank=
CASE WHEN @IsselectedId <> 0 THEN @IsselectedId
ELSE @maxcatrank END
END
ELSE
BEGIN
UPDATE #tmp
SET Isselected=1
WHERE CategoryId=@CategoryId
AND catrank=@visitcount
END
--select @maxcatrank
--UPDATE #tmp
--SET Isselected=1
--WHERE CategoryId=@CategoryId
--AND catrank=
--CASE WHEN
--catRank=1 AND @visitcount > CategoryId THEN 1
--WHEN catRank=@visitcount THEN @visitcount
--ELSE 0 END
SET @Error=@@ERROR
IF @Error <> 0
BEGIN
GOTO Error_Handle
END
---- Else Update Field Details using old field id
-- Fetch New Values using Cursor
FETCH Curtmpcat INTO @CategoryId
SET @Error=@@ERROR
IF @Error <> 0
BEGIN
GOTO Error_Handle
END
END
--- End Of the Cursor Loop
-- Close cursor
CLOSE Curtmpcat
DEALLOCATE Curtmpcat
SELECT * from #tmp
--WHERE Isselected=1
---- Commit The Transaction
IF @Error = 0
BEGIN
COMMIT TRAN
END
---- Start The Go To Error Handle for Transaction error
Error_Handle:
IF @Error <> 0
BEGIN
ROLLBACK TRAN;
--RAISERROR ('An error occured updating the NonFatal table',10,1)
END
--RETURN @Error;
end
GO
</pre>