The dbType NVarChar is invalid for this constructor

To test some custom made mapping logic, I created a fake IDataRecord item.

	IDataRecord CreateTestRecord()
	{
	SqlDataRecord record = new SqlDataRecord(
	new SqlMetaData("ID", SqlDbType.Int),
	new SqlMetaData("PRODUCTNAME", SqlDbType.NVarChar));
	record.SetValues(1, "DUVEL");
	return record;
	}

view raw IDataRecordWithErrors.cs hosted with ❤ by GitHub

However when I tried to run my test, it failed with the following error message:

The error message is not very explaining. The thing is that when you specify NVarChar as the dbType, you also have to specify the MaxLength. After doing that, the error was gone.

	IDataRecord CreateTestRecord()
	{
	SqlDataRecord record = new SqlDataRecord(
	new SqlMetaData("ID", SqlDbType.Int),
	new SqlMetaData("PRODUCTNAME", SqlDbType.NVarChar, 100));
	record.SetValues(1, "DUVEL");
	return record;
	}

view raw IDataRecordCorrect.cs hosted with ❤ by GitHub