CODEWITHSUNDEEP
sqlvisual-studio-2010entity-frameworkentity-framework-4.1
Jeff
Jeff

Reputation: 14279

Database computed column not generating 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 aggregates and filters data from another table. The computed value is not persisted in the database (because it is non-deterministic, I am told).

When I update the entity framework model from the database the computer column PersonalityType never shows up. What is wrong? Can EF 4.1 model computed columns in this situation?

Upvotes: 3

Views: 386

Answers (1)

Nathan DeWitt
Nathan DeWitt

Reputation: 6591

I'm not sure how you can get this to work, but try playing with a lot of properties and then regenerating it a lot. ;-)

Upvotes: 1

Related Questions