Hi,
We partition our SQL Server tables and I’m interested in how we can use the new code first db migrations and manage the table partitions. Is it possible to create a table against a partition schema using the code first migrations?
It has no concept of table partitioning, you get a configured DB Connection which you’re free to implement as you wish in your Up() and Down() implementations, inc Modify Schema APIs or Custom SQL when needed.
You also have access to the base.DbFactory should you need to open connections to different DBs, but the migrations history are only maintained in the primary DB connection.
1 Like