Entity Framework executes SQL statements in MySQL on parameter issues

Adding a MySQL model to the Entity Framework requires that the SQL statement be executed directly during code writing.

@currank: = 0 is used in SQL statements to define parameters in an SQL statement, along with incoming parameters: Ai.action_time >= ' @startTime ',

An error will be taken during the execution.

Workaround, add the following in the connection database string: '; Allow User variables=true '

Add the following when finished:

<add name= "" connectionstring= "METADATA=RES://*/CONTEXT.CSDL|RES://*/CONTEXT.SSDL|RES://*/CONTEXT.MSL; Provider=mysql.data.mysqlclient;provider connection String=&quot;server=;user id=;p assword=; persistsecurityinfo=true;database=; Allow User variables=true&quot; "providername=" System.Data.EntityClient "/>

Entity Framework executes SQL statements in MySQL on parameter issues