How can I load a dynamic database by entity framework core? RRS feed

  • Question

  • User1052024640 posted

    The database will record the batch number/name/production date(accurate to minutes) of the food. After the user bought the food, he will visit the website via QRCODE on the package(every QRCODE on the package is different) to get to know its batch number/name/produce date.

    Now I need to design the database with MYSQL.

    In my opinion, the QRCODE on the package not only contains a primary key but also a production month.

    The data will store into different databases by the production month and select by the primary key. I did this for I want to select the data faster.

    So when there is a new month, I have to create a brand new database and the entity framework needs to select data from it also.

    I don't want to change the code of the project every month for this. Is there a way for me to load a dynamic database by entity framework core?

    Or maybe there is a better way to solve this problem? Thank you.

    Wednesday, April 15, 2020 12:55 PM


All replies