Dynamic table creation in .NET Core

Question

So I'm having trouble determining how to add tables dynamically in a .NET Core web application. From my research it doesn't appear entity framework supports this feature. It's my understanding that EF is static, so all new tables would need to be created through migrations.

So I have 2 questions:

Am I missing a way to add a table (say on a button click) using EF in spite of its static nature?
If #1 is not possible, is there any other way to dynamically add a table other than use sql commands like CREATE TABLE..., like using Linq?

galdin · Accepted Answer · 2017-12-21 13:30:09Z

1

There's no way you can perform DDL tasks with EF.

You can however abuse the EntityFrameworkCore.Migrations API if you want to. The docs are here: https://learn.microsoft.com/en-us/ef/core/api/microsoft.entityframeworkcore.migrations

If you intend to do so, be warned that the migrations API is not meant to be used this way. So things like SQL injection, etc. will have to be handled manually as far as I know (unless things changed in the recent past).

answered Dec 21, 2017 at 13:30

galdin

14.2k8 gold badges63 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

Dynamic table creation in .NET Core

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related