[ http://issues.apache.org/jira/browse/IBATISNET-20?page=comments#action_57645 ] Henrik Uffe Jensen commented on IBATISNET-20: ---------------------------------------------
I'm using the same database and provider as you. But I can see that you are using a special notation #value:UniqueIdentifier#. I only used #value#, which worked just fine with the 1.0.1 version of the DataMapper. Best regards Henrik Uffe Jensen > Type problems when applying parameters > -------------------------------------- > > Key: IBATISNET-20 > URL: http://issues.apache.org/jira/browse/IBATISNET-20 > Project: iBatis for .NET > Type: Bug > Versions: DataMapper 1.1 > Reporter: Henrik Uffe Jensen > > I don't know if this error applies for both parameterMaps and with inline > parameterMaps. I only used inline parameterMaps. > When using parameterClass="Guid" in my Guid, I got an error saying "Object > must Implement IConvertible" > After a lot of debugging I found that no matter, what then the sql statemants > executed against the database used nvarchar(4000) an no other type. > I found that this is due to the changes made in > IBatisNet.DataMapper.MappedStatements.ApplyParameterMap from version 1.0.1 to > 1.1 > In 1.0.1 'sqlParameter.Value' is set at the top of the method. Setting > 'Value' on sqlParameter changes the sqlParameter.DbType from String (default) > to the correct type of the object value being set. > In 1.1 however you use 'parameterValue =' (line 265) instead, and > 'sqlParameter.Value' is therefore never set, which means that the > 'sqlParmenter.DbType' never changes from the default DbType. Further down the > method 'parameterCopy.DbType = sqlParameter.DbType;' (line 316 or 321) sets > the DbType of the parameterCopy, however this is always String. > I corrected the error by adding a 'sqlParameter.Value = parameterValue;' > below the 'parameterCopy.Value = parameterValue;' (line 301) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
