The table/view 'TABLE1' does not have a primary key defined and no valid primary key could be inferr

Posted by Nickson on Stack Overflow See other posts from Stack Overflow or by Nickson
Published on 2010-03-17T14:36:58Z Indexed on 2010/03/17 14:41 UTC
Read the original article Hit count: 2077

Filed under:

linq-to-entities

I get the following error message

The table/view 'TABLE1' does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity you will need to review your schema, add the correct keys and uncomment it

when I try to add a view to an Entity Data Model. For testing, I have created a very simple view and I still get the error. below is the view definition

SELECT 
   DISTINCT TOP (100) PERCENT 
   MIN(id) AS Expr4, MIN(EmpNo) AS Expr1, 
   MIN(Name) AS Expr2, MIN(Category) AS Expr3
FROM  dbo.MYView1
GROUP BY id

does any one know of a simple work around.

I have looked at this thread http://stackoverflow.com/questions/745341/can-ms-sql-views-have-primary-and-foriegn-keys but in my scenario, what is recommended is not applicable.

If I could only have the view added to the Model.

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
Linq to Entities : using ToLower() on NText fields

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database.. In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules : The comparison is a "Contains" mode, not strict compare : easy as… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Developer IT

The table/view 'TABLE1' does not have a primary key defined and no valid primary key could be inferr - Developer IT

The table/view 'TABLE1' does not have a primary key defined and no valid primary key could be inferr

linq-to-entities

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

Linq to Entities : using ToLower() on NText fields

LiNQ to Entities, Include less

deploying applications that use LINQ to Entities.

LINQ To Entities - Items, ItemCategories & Tags

Categories cloud