Share via

EF Core 8 Shadow Properties incur a 255 limit on columns

Bill Stamp 1 Reputation point
2024-10-01T15:21:02.83+00:00

We have an EF based WebApi, and the business logic includes the ability for end users to add user defined fields
To get that in EF, we engaged Shadow Properties, and that is working well
Unfortunately we found Shadow Properties incur a limit of 255 columns in a table
I could not locate documentation on the limit, but ChatGPT confirmed our findings

How can we increase the limit to something like 512?
Is it possible?
Otherwise, we will have to re architect the search and storage engines of our WebApi

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,571 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,865 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 65,576 Reputation points
    2024-10-01T15:33:17.42+00:00

    as each shadow property requires a database column, does your chosen database server support more than 255 columns per table?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.