There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Generated Visualized SQL for NVarchar datattype is Wrong
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.