I have a table
Customer which is having foreign key constraint of
Now using EntityFramework when I try to insert record in
Customer table I get an error saying
Cannot add or update a child row: a foreign key constraint fails ("Event"."Customer", CONSTRAINT "customer_ibfk_2" FOREIGN KEY ("CustomerTypeId") REFERENCES "CustomerType" ("CustomerTypeId"))
While researching on this error, I found that in MySQL database it is case sensitive and because of that I am getting this error.
Is there any possible solution to ignore case sensitivity in MYSQL ?