Data type for SQL Server for DbType.StringFixedLength

[beppler]

On DbTypes x SqlServer is documented that the types generated for DbType.AnsiStringFixedLength are the following:

• nchar(255) if precision is not specified
• nchar(n) if precision is between 1 and 8000
• text if precision is greater than 8000

Based on SQL Server Data Type Mappings the type used for String should be:

• char(255) if precision is not specified (to remain compatible with previous behavior)
• char(n) for precision between 1 and 4000

The mediumtext datatype does not exist on SQL Server text datatype is deprecated and I think that it is not applicable to FixedLength.

So if precision is specified and is not between 1 and 4000 I think that an exception should be raised.

[beppler]

I've created a project fork at https://github.com/mpsinfo/sharpdata that contains this update.

[beppler]

Resolved by #19.