I have a table Customer which is having foreign key constraint of CustomerType(CustomerTypeId).

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 ?

Related posts

Recent Viewed