Entity Framework Core Feature Suggestions

Welcome! Use this web site to submit ideas and vote for what features you want to see in future versions of Entity Framework Core.

Our team will only fix bugs, implement small improvements and accept community contributions in the EF6 codebase. Larger feature work and innovation will happen only in the EF Core codebase. If you have ideas for improving EF6, we recommend you submit them on the EF6 GitHub site listed below.

Please also consider these other options before submitting anything to this site:

  • If you want to learn how to use our products, visit our documentation pages.
  • If you want to report bugs, make contributions, or learn about our product roadmaps, visit our EF Core or EF6 project pages on GitHub.
  • If you have technical questions or need help, try StackOverflow’s EF Core or EF6 tags, or visit our MSDN forums. Note that roadmap questions, bug reports, feature requests or ideas are not appropriate for StackOverflow. Visit StackOverflow’s help center for guidance on appropriate usage.

How can we improve 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. Use names defined in linq query in generated sql

    Currently if you have something like

    select new { Year = c.DateEntered.Year }

    the generated sql uses C1 for the column name. I would find it very useful if the used Year.

    3 votes
    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 →
    • Isolate the migrations from EF

      The migrations in EF is great. I'd love to see it isolated, so it can be installed seperatly.

      Not every project needs the full EF (in DDD layer, Migrations isn't required, but my .Data or DAL layer needs it) and this would make it easier to use tools like Dapper (that doesn't have a Migrations included)

      3 votes
      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 →
      • Left Join

        Please iclude LeftJoin, now when I must to do LeftJoin, i must use GroupJoin instead. Writing GroupJoin code is very hard to see. So I prefer LeftJoin, like context.Join(...) so now is context.LeftJoin(...)

        3 votes
        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 →
        • Change Entity Framework behavior when constructing it(EF automatically fetches tables' structure from master.INFORMATION.SCHEMA.TABLES)

          EF automatically fetches tables by accessing the master.INFORMATION_SCHEMA.TABLES. It will cause problem when I have no permission to get access to the master database on a web server.
          A good solution could be the way how LINQ2SQL get tables(users have to drag tables they want into the O/R designer).

          Please let me know when are you going to update this behavior, coz I'm going to start a new project very soon and really want to use EF.

          Cheers,

          3 votes
          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 →
          • Model Browser Rename/Delete Options

            It would be great to have rename and delete options from the model browser, plus the ability to multi select for deleting.

            2 votes
            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 for working with databases with alot of models

              EF needs better support for working with large models. Our developers are having very hard times with merging models between projects that are concurrently executing. Our database has over 500 tables.

              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 →
              • Since EDMX will not be supported anymore.... How do use T4 templates in other projects in the same solution??

                I use the EDMX file geneated by EF to generate classes and code in other projects in the same solution..... I do this by using T4 templates that read the EDMX.... How will I be able to do this if no EDMX is available????

                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 →
                • Generate DbSet.FindByKey method taking typesafe primary key

                  The Find method on DbSet just take a "params object[] keyValues" parameter - not very typesafe.

                  I would suggest amending the standard templates to generate

                  public static class ExtendDbSet
                  {
                  public static MyEntity FindByKey(this DbSet<MyEntity> dbSet, Guid id)
                  {
                  return dbSet.Find(id);
                  }
                  }

                  where the id parameters are generated.

                  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 →
                  • sp_fkeys

                    Using code first, when you try to apply "update-database" and you receive the message: "Could not drop object 'dbo.Table1' because it is referenced by a FOREIGN KEY constraint."

                    The message should show the result of the command "sp_fkeys", then easily the developer can identify the keys to remove.

                    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 →
                    • Provide Designer Mapping support from a Conceptual Model to multiple Storage Models

                      Currently, when using Entity Framework tools from other vendors, a developer has to manually create and modify the mapping from a Conceptual Model to another Storage Model (such as from Oracle) in order to support persistence to multiple database platforms. Instead, it would be great if Visual Studio offered designer support to easily and readily map a .csdl to one or more storage models. This would eliminate much of the current tedium required to support multiple database platforms using Entity Framework.

                      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 →
                      • 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 →
                        • 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 →
                            • 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 →
                              • 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 →
                                • 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 →
                                  • Check linked tables

                                    https://social.msdn.microsoft.com/Forums/en-US/0ad264b8-d541-4abe-acbd-6e1178297b2a/linked-tables-and-sqltableexistencechecker?forum=adodotnetentityframework

                                    replace SQL-statement in SqlTableExistenceChecker

                                    command.CommandText = @"
                                    SELECT COUNT(*)
                                    FROM sys.objects t INNER JOIN
                                    sys.schemas s ON s.schema_id = t.schema_id
                                    WHERE s.name + '.' + t.name IN ("+ modelTablesListBuilder + @")
                                    OR t.name = '" + edmMetadataContextTableName + "'";

                                    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 →
                                    • Database First Schemas to Namespace

                                      I would like the option to separate Entities base on schema, e.g. I have a single database that has two sets of tables that have the same names but are in different Schemas it would be nice to create a single data model that does this. At the moment I have to create different models for each schema is separate folder to get what I want but then I cant have relationships between them.

                                      Thanks
                                      Steve

                                      0 votes
                                      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 →
                                      1 3 Next →
                                      • Don't see your idea?

                                      Entity Framework Core Feature Suggestions

                                      Feedback and Knowledge Base