I am getting lots of errors when working in the app. Below I have provide some of the sample error but there are lot more error like this when doing simple tasks like adding (Requisition) a lap test.
SqlException: Cannot insert the value NULL into column 'LabTypeName', table 'DEV_DanpheEMR.dbo.LAB_TestRequisition';
SqlException: Cannot insert the value NULL into column 'IsFileUploaded', table 'DEV_DanpheEMR.dbo.LAB_TestRequisition'; column does not allow nulls. INSERT fails.
Error converting value {null} to type 'System.DateTime'. Path '[0].OrderDateTime', line 1, position 333.
SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LAB_TestRequisition_BIL_TXN_BillingTransactionItems". The conflict occurred in database "DEV_DanpheEMR", table "dbo.BIL_TXN_BillingTransactionItems", column 'BillingTransactionItemId'.
Here are my questions,
- Is the application/code and the database bak created at the same point in the development?
- Am I missing something? (I am not sure what detail you need to answer this question, pls ask for any details)
One of the reasons I have this question is because there as many mismatches between ORM and database schema. For example, IsFileUploaded
is a nullable bool
in ORM but in the database, it's not a nullable field. I have noticed IsFileUploaded
column in changes from nullable to non nullable in v3.0 (By checking EMR_V3.0_Master Incremental.sql file)
|
public bool? IsFileUploaded { get; set; } |
Details:
Version used: 3.2
Deploying method: Using zip files from git release and followed the setup youtube vide
Hosting method: IIS