Geek asks and answers

Computed database column not generated in EF 4.1

I have a database table with a computed column

CREATE TABLE [dbo].[User]
(
    [UserId] [uniqueidentifier] NOT NULL,
    [PersonalityType]  AS ([dbo].[GetPersonalityType]([UserId]))
)

And a scalar function [dbo].[GetPersonalityType]that combines and filters data from another table. The calculated value is not stored in the database (because it is not deterministic, as I was told).

When I update the entity framework model from the database, the computer column PersonalityTypenever appears. What's wrong? Can EF 4.1 compute columns in this situation?

+3
source share
1 answer

I'm not sure how you can make this work, but try playing with a lot of properties and then regenerate it many times .; -)

+1

More articles:


All Articles