Entity Framework and SQL Server View

by

We had the same problem and this is the solution:

To force entity framework to use a column as a primary key, use ISNULL.

To force entity framework not to use a column as a primary key, use NULLIF.

An easy way to apply this is to wrap the select statement of your view in another select.

Example:

SELECT
  ISNULL(MyPrimaryID,-999) MyPrimaryID,
  NULLIF(AnotherProperty,'') AnotherProperty
  FROM ( ... ) AS temp

More Related Contents:

  1. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  2. Reset Entity-Framework Migrations
  3. How to mock the limitations of EntityFramework’s implementation of IQueryable
  4. Batch update/delete EF5
  5. Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93
  6. how to update an entity in Entity Framework 4 .NET
  7. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  8. Entity Framework 4 / POCO – Where to start? [closed]
  9. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  10. Entity Framework: Ignore Columns
  11. mapping private property entity framework code first [duplicate]
  12. MVC3 and Code First Migrations – “model backing the ‘blah’ context has changed since the database was created”
  13. Entity Framework 4: How to find the primary key?
  14. MetadataException when using Entity Framework Entity Connection [duplicate]
  15. How to create index in Entity Framework 6.2 with fluent configuration
  16. Working with SQL views in Entity Framework Core
  17. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  18. Map two different entities to the same table?
  19. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  20. EF Code First foreign key without navigation property
  21. Nullable property to entity field, Entity Framework through Code First
  22. LINQ to Entities for subtracting 2 dates
  23. Entity Framework Code First Using Guid as Identity with another Identity Column
  24. AutomaticMigrationsEnabled false or true?
  25. ADO.NET Entity Framework tutorials [closed]
  26. Entity Framework Code First Many to Many Setup For Existing Tables
  27. Compose queries across Entity Data Models
  28. Changing Inherited Types in Entity Framework
  29. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment