I must read data from an excel file, save it in a temporary table (the device's temp table), then copy all of the data into this table once it has been read. Previous entries must be deleted because these records are updated in the actual table (userDevices).
In my project, EF6 was used. therefore I mapped entity "Device" to the table "userDevices". How will I use the entity framework to add data to a temporary database and subsequently replace it in the real table?
Is stored proc the only choice available? Or is EF available for the same purpose?
The only method to use temporary tables is to create, modify, insert, and finally remove data from them using stored procedures. Once those are configured,
can contact them and use them.
does not look through
Any temp table, regardless of session, can be created using the schema when the table mappings are created.
) status cannot be utilized because of the way temporary tables work.