Migration of data access layer and database from SQL Server to MySQL running on AWS RDS instance. All data access is performed via the DAL objects using inline SQL, ie no stored procedures.
There are 30 classes in the DAL but of those less than half will require any change. The anticipated work will relate to date and datetime columns and two classes which return data rows by page.
For each of the classes add a property UID and amend queries such that data is returned only for the UID passed in, if an invalid UID is passed then throw an exception.
Reference data will be cached locally in a SQLite database. Provide a function which will update the local cache if and when the remote cache version ID changes. There are six reference tables which will be locally cached and these tables are referenced in queries from the remote db hence there will be changes to the affected classes.
Recommend changes to the data access layer in the interest of performance.