Search code examples
postgresqlpostgis

Input string was not in correct formate while inserting data to postgresql through entityframework in .net core using dynamic query

I am getting error while inserting data to pgsql with .net core entity framework error is Input string was not in correct format this is my query executing

INSERT INTO public."MedQuantityVerification"("Id","MedId","ActivityBy","ActivityOn","Quantity","ActivityType","SupposedOn","Note") Values(7773866,248953,8887,'7/14/2018 10:43:43 PM','42.5 qty',5,NULL,'I counted forty two {point} five.')

anyhow when I run that query directly to postgresql browser it works fine looks like issue on c# side it is but not know what? also issue is with {point}

this is how I executing the dynamic query

db.Database.ExecuteSqlRaw(query);

Solution

  • You have to escape the curly brackets:

    {point} should be {{point}}