LightSwitch with Azure SQL Temporal Tables RRS feed

  • Question

  • I'm using an existing Azure SQL database as my data source and the database implements "temporal tables".  Each temporal table is required to have two fields ValidFrom and ValidTo, which are of data type datetime2(2).  The database itself populates these fields whenever there is an insert or update in a table.  The user is not allowed to enter his own data into these fields.  The issue now is that LightSwitch is showing these fields as required and out of the box won't allow me to enter data into the tables without supplying data for these required fields.  The conflict is that Azure SQL database won't accept user input into these fields.  Any suggestions would be appreciated.
    Monday, March 27, 2017 4:47 PM