Entity Framework Feature Suggestions

Welcome! You can use this site to tell the Entity Framework Team what features you want to see in future versions of our products.

Note that moving forward our team will be only fixing bugs, implementing small improvements, and accepting community contributions in the EF6 codebase. Larger feature work and innovation will happen in the EF Core codebase.

Please consider other options besides this site!

  • If you have technical questions or need help, try StackOverflow (EF6 and EF Core) or visit our forums.
  • If you want to learn how to use our products, visit our documentation pages.
  • If you want to report bugs or make contributions, visit our project pages on GitHub: EF6 and EF Core.

How can we improve Entity Framework or Entity Framework Core?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Events for Insert and Update

    Some sort of hook to allow for custom managed code to be run when inserts and updates happen. Usage Scenarios:
    1) allow for SignalR updates of data realtime.
    2) complex validation rules.
    3) awesome cache invalidation
    4) additional logging techniques

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
    • Be able to define transient (not mapped) properties in designer

      Be able to specify that a property in an entity should not be stored in the database.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  tools  ·  Flag idea as inappropriate…  ·  Admin →
      • ConvertTo and ConvertFrom support on DbModelBuilder

        It would be great to have more flexibility and not be forced to use the same data types on entities as in database tables. Specially if the database is shared with other projects.

        In order to support this a ConvertTo and ConvertFrom property could be added on the DbModelBuilder object hierarchy, and the EF runtime could use it when materializing objects and saving changes.

        This feature could also be used to work around other limitations in EF.

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
        • Replication at the EntityFramework SaveChanges level

          Implement Replication to other databases in SaveChanges.
          I've tried to do it, but I can't save autogenerated IDENTITY values in replicated db's.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
          • ToTable without arguments

            With Entity Framework 4.1 code first, allow me to specify ToTable on an entity configuration and let the underlying database pick the appropriate table table, while still having the effect ToTable has for TPH or TPC in the physical model of the database.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
            • Formulas in properties / calculated properties

              Allow having properties that contain the result of formulas. The formula should be specified in a new attribute or fluently.

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
              • A code-generated clone() method for EntityObject

                It is often useful to be able to deep-copy an entity. Currently, some lifting is required to get this done; most suggestions on how to copy entities require serialization and/or reflection and therefore are performance hogs.

                The EF has what it takes to offer a really efficient clone() method: the framework could provide generated code that simply copies the required properties. As for referenced data, I suggest that that can be copied optionally and that it can stay in memory even if the clone is detached.

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to "Update Model from Database" and "Generate Database from Model"

                  Ability to "Update Model from Database" and "Generate Database from Model" without Stored Procedures list disappearing in the Model Browser.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  tools  ·  Flag idea as inappropriate…  ·  Admin →
                  • The EF data model does not recognize clustered Foreign Key relationships

                    There are numerous instances wher a clustered index is propogated as a foreign key. This should be recognized by EF.

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  tools  ·  Flag idea as inappropriate…  ·  Admin →
                    • Hook to modify LINQ tree

                      This is similar to the idea of modifying a generated SQL. Except that it applies to an earlier stage. I can imagine a scenario where a third party may come up with a really good LINQ optimizer.

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
                      • Runtime query builder and auto mapper without database schema

                        can create query on each database with query string that schema not defined for entity framework and auto map to object

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
                        • Right click on design area to have 'templates' for database/tables

                          I wish to have right click of empty design area to have templates of database/tables like "Employee", "Students", "Family Hierarchy", etc.

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  tools  ·  Flag idea as inappropriate…  ·  Admin →
                          • sequence

                            support sequence, not only for key, but as a common field/column/property. This should be mapped, in sql server case, to CREATE SEQUENCE.

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
                            • Ability to hook into ValidationContext creation and set ServiceContainer

                              I'd like to set the IServiceProvider in the ValidationContext constructor, so that I can access validation logic outside the IValidatableObject.Validate() method (and within custom data annotations) in a loosely coupled manner.

                              As far as I can see, ValidationProvider.GetEntityValidationContext() passes a null for the IServiceProvider and there is no way to override/"hook into" this method or InternalEntityEntry.GetValidationResult() from the public API.

                              Something like what ASP.NET MVC or Web API does with DataAnnotationsModelValidatorProvider or ValidatableObjectAdapter might be nice.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
                              • Query only columns that needed

                                Now days speed and resource usage became crucial in application development. This in mind I would like to see a future in EF where you can query only the fields you need not the entire object(table). Similarly having ability to choose table columns at the design time for database first approach.

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  runtime  ·  Flag idea as inappropriate…  ·  Admin →
                                • Conditions on association mappings

                                  This can be useful in many-to-many associations, in cases when the mapped table to the association contains columns different to the key columns, i would like to map the association only for relations that accomplish a condition based on this extra columns

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Ability to exclude prefixes/patterns from model entity names

                                    It would be great if a model could be created from an existing database (database first) without including certain SQL naming conventions that may be in place. E.G. Rather than creating a POCO class named tbl_Person, I can tell the tool to exclude the "tbl_" prefix and the class is simply named Person. This would be useful for column/property mapping as well. Being able to use regular expressions for the replacement would probably be helpful. This would be useful when generating 10s to 100s of entities from tables so that they don't have to be renamed individually.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  tools  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Support SQL UDF invocation in LINQ to Entities

                                      When you write a LINQ to Entities query, there are functions like CLR Method to Canonical Function Mapping, (http://msdn.microsoft.com/en-us/library/vstudio/bb738681(v=vs.100).aspx) which can be used and are transalated to their DB (T-SQL) equivalents.
                                      If you want to invoke a custom function created in the DB (or a function which exists in the DB, and is not mapped to anything on the .NET side) you have no way to do it.

                                      It would be interesting to have a functionality that allows to do this, for example:

                                      * define custom mappings in the .NET side that convey enough information to be mapped…

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • table splitting with more than two tables without one2one navigation of each object

                                        table splitting is fine if you want to splitt one table to two object. If you want to splitt it to more than two objects you need to provide one to one relationship between each object at the moment.

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Setting for code generation to set to default instead of none

                                          When generating the EF model from the SQL database, it sets the code generation property to none and generates two tt files automatically.
                                          Could there please be an option for the code generation to set to default instead?
                                          I know there is a work-around by deleting the tt files and manually setting code generation to default, it would just make life a little easier if there was a setting to do this.
                                          We are working on a fledgling project with many aspects that are not decided yet and therefore we make a lot of DB changes and the workaround gets…

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  tools  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          Entity Framework Feature Suggestions

                                          Feedback and Knowledge Base