Problem with adding MS-SQL view in Entity Data Model

Question

Hi All,

I have a problem with adding a MS-SQL view to my Entity Data Model. The view is so simple and I added the table related with this view. Below T-SQL script about view.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[HFL_VWPrcListSrchRslt]
AS
  SELECT sfiyat_fiyati, 
         sfiyat_stokkod 
  FROM STOK_SATIS_FIYAT_LISTELERI 
  WHERE sfiyat_listesirano = 1 
    AND sfiyat_deposirano = 0 
    AND sfiyat_odemeplan <= 0

Why can't I see the View in my .edmx designer?

Answer 1

Such a view should be visible in the edmx designer - however, you have to add it explicitly, it doesn't just magically show up when you create it on the database.

So, a few things to check:

• did you create the EDMX from scratch or did you use "Update Model from Database..." after you've created the view in the database?
• are you connecting to the right database?
• does the user that you use to connect to the database have permissions to see that view? E.g. can this user see the view and select from it in SQL Server Mgmt Studio?

Marc

Answer 2

Hello , I deleted some views then I want to add them again but although I use "Update Model from Database..." , they didn't appears . Any help please..

Answer 3

The solution : that happen because I deleted the entity from the designer but it is still at the XML so to solve it go to XML file , delete the entity definition and the entity mapping. May it helps