How to use Entity Framework to query a table having dynamic columns?

Question

I have a table named Tags in which a new column is added when a user creates a tag (name of the column will be the tag name that the user gave). Also, the column is renamed when a user edits a tag name.

I know there is a design flaw in my application. But just wondering how are we supposed to create a model for such a table? Is there any way I could perform CRUD operation in such table using Entity Framework?

I think there is some design flaw if you are adding column for each entry. — Musab
– Musab, Commented Apr 16, 2019 at 3:42
Why not do a one column table and add a new record for each tag? Then you won’t run into this problem. — chrisbuttacavoli
– chrisbuttacavoli, Commented Apr 16, 2019 at 3:59

Piotr Stapp · Accepted Answer · 2019-04-16 08:54:32Z

1

Except it is a very strange design the solution is quite simple - just execute raw SQL query, and do the manual mapping. Example query:

    string studentName = ctx.Database
           .SqlQuery<string>("Select tag1 from Posts where postId=@id", new SqlParameter("@id", 1))
           .FirstOrDefault();

All CRUD operations you can handle with raw queries.

edited Apr 16, 2019 at 8:54

answered Apr 16, 2019 at 8:35

Piotr Stapp

19.9k11 gold badges72 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

void Over a year ago

I did try this. It's working. I suppose it's the only easy way out.

Collectives™ on Stack Overflow

How to use Entity Framework to query a table having dynamic columns?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related