1

Closed

Generated Visualized SQL for NVarchar datattype is Wrong

description

When visualizing the generated SQL in the main visualizer window, the generated SQL is different from the the SQL that actually gets executed at debug time.

The visualized SQL declares/defines the variables (e.g. @p__linq__x) for NVarchar datatype WITHOUT a length qualifier.

The SQL that is actually executed at debug time by Entity Framework adds a length of (4000) to the NVarchar datatype.

The consequence of this is that under certain circumstances the arguments values get truncated and the resultset returned by the visualizer is either empty or different from what gets returned by Entity Framework at debug time.
Closed Jun 22, 2013 at 5:39 PM by regateiro

comments

wrote Jun 22, 2013 at 5:29 PM

This bug could mislead the user, by not using all the characters, for example :


DECLARE @p__linq__x NVARCHAR;
SET @p__linq__x = '%filter%';
 
the actual value of @p__linq__x was '%', so no filter was applied.

wrote Jun 22, 2013 at 5:30 PM

wrote Jun 22, 2013 at 5:39 PM

Resolved with changeset 25161.