>>>Thanks again, Rob.
>>
>>
https://www.google.com/#q=entity+framework+top+2>>
>>Is there a reason you care about what the type of the parameter is? Is the difference between a varchar(8000) and char(6) as a parameter type causing issues for you?
>
>Our test database is rather small, so I can not say if it will be causing issues or not on a big database. It is for me just strange to see that declaration of the parameter while the type of the column is correctly specified.
>
>The OP in the StackOverflow question you pointed out said that there was a performance difference in using correct size for the parameter vs. 4000 for nvarchar parameter.
This is probably a case of premature optimization then. If it is causing a performance issue then you may want to look into may want to look into mapping your queries to stored procedures.