I’m using the downloaded sample code for Chapter 9 and I’ve changed the connection strings to point to my instance of SQL Server (Express). When I run the application I get the following error message:

• An exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll but was not handled in user code

It’s pointing at line 15 in Index.cshtml:
The Data Type of the Description field is “nvarchar(MAX)” and Allow Nulls is set to True.

Any suggestions?

Thanks,
Jim

Hello Jim,

I came across this issue as well. If you look up the Substring() method overload, it takes two arguments, you will see that the second argument is an int for length. So referring to the chapter 9 code its looking to grab a substring (so not the full string basically) of a length of 250 characters. So if your "item.Description" isn't that long (length of 250 or more) it throws an exception. Not very robust to put into an example new people are learning from! As a fix you can increase your item descriptions, or shorten the length argument to something much smaller, or even better check if the item.Description length is greater than some amount and if so use the <span>...</span>, and if not write out the full description.

Thanks!! The "even better" solution worked perfectly.

Jim

Glad to help!