On updating model from database I don't get SPName_Result.cs file generated automatically.

See more:

ASP.NET

LINQ

MVC

, +

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

/****** Object:  StoredProcedure [dbo].[getsdetails3]    Script Date: 08/16/2014 10:41:28 ******/
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

/****** Object:  StoredProcedure [dbo].[getsdetails3]    Script Date: 08/16/2014 10:41:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

/****** Object:  StoredProcedure [dbo].[getsdetails]    Script Date: 02/06/2014 00:42:43 ******/
-- 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 &lt;&gt; 0
BEGIN
GOTO Error_Handle
END

--- open cursor
OPEN Curtmpcat 
FETCH Curtmpcat INTO @CategoryId
SET @Error=@@ERROR
IF @Error &lt;&gt; 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 &gt;@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 &lt;&gt; 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 &gt; CategoryId THEN 1
--WHEN catRank=@visitcount THEN @visitcount 
--ELSE 0 END

SET @Error=@@ERROR
IF @Error &lt;&gt; 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 &lt;&gt; 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 &lt;&gt; 0
BEGIN

ROLLBACK TRAN;
--RAISERROR ('An error occured updating the NonFatal table',10,1)
END


--RETURN @Error;


end
GO
</pre>