HasNoKey and Constructor with Parameters about entityframework-classic HOT 5 CLOSED

Hello @LukeTOBrien ,

HasNoKey

We will look if that's possible for the HasNoKey. Obviously, the same restriction will happen (you can select but you cannot insert, update, or delete.

Parameterless Constructors

As for the second, it looks to be harder. What if there is more than one constructor with a parameter? Which one do we take?

We need a way to be able to create a new instance of this class. For example, a factory that you tell us how to create it. We will look at it and try to propose a solution if that's possible to support this.

from entityframework-classic.

from entityframework-classic.

Hello @LukeTOBrien ,

We tried for the HasNoKey but more we advance on this request, more we discover that we have more code to modify which might have some side impact. The core of EF6 was not been built to support entity without a key.

However, one easy solution on your side would be:

• Add a property ID of type Guid in your entity
• Return in your view a new column NEWID() AS ID

Is that a viable solution for you?

from entityframework-classic.

from entityframework-classic.

Depending on if you wish to go in some "hack" solution or not you can also use an interceptor and replace some part of the command text.

If the command text contains a SELECT and your view name, then you replace the first SELECT statement by "SELECT NEWID() AS ViewKeyID"

SELECT NEWID() AS ViewKeyID, Column1, Column2, Column3
FROM ...
WHERE ...

Might not be a good long term solution however, it really depends on your requirement.

from entityframework-classic.