Input string was not in a correct format

Hi,

I'm getting this error when I when I try to run lightspeed to my oracle 10g database thru visual studio 2007.   the provider is Oracle9, so I dont know if this makes a difference. 

Error:

LightSpeedException: Unable to materialize field [OccupationCodeId] on type [WebCms.Model.WageSalary.Wsoccupationque]. Check your table has an Id column and that your mappings are correct. See inner exception for details. ]
   Mindscape.LightSpeed.LightSpeedException.€(Exception , String , Object[] ) +53

As you can see in the picture below, it has a ID field but the field that it is in error, is a foreign key which I created called Occupation_Code.
The generated code:
    [Column("OCCUPATION_CODE")]
    private System.Nullable<int> _occupationCodeId;



thanks for you help,
Will

Could you post the inner exception please?

Also, does this happen only on certain rows, or on all rows?  If it only happens on certain rows, could you post examples of the OCCUPATION_CODE value on a good row and on a bad row?  Thanks!

Hi,

I dont get anything for the innerexeception.  It is null.  Here is what I get

 at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.String.System.IConvertible.ToInt32(IFormatProvider provider)
   at System.Convert.ToInt32(Object value, IFormatProvider provider)
   at Mindscape.LightSpeed.Data.DataProviderAdapter.
(Object[] , Int32 )
   at Mindscape.LightSpeed.Data.DataProviderAdapter.
(Object[] , Int32 )
   at Mindscape.LightSpeed.Model.FieldModel.<>c__DisplayClass9b.<CreateValueSetter>b__66(IDataProviderAdapter , Object , Object[] , Int32 )
   at Mindscape.LightSpeed.Model.FieldModel.Materialize(IDataProviderAdapter , Object , Object[] , Int32& )

It happens when I  try to do a count on the count below.

var rGridData = DB.Wsoccupationques;

if (rgridData.ToList().Count !=0)  <=====

{ RadGridResult.DataSource = rGridData;

}

When it goes to the if statement rgridData.ToList().Count , it goes here:

   [ReverseAssociation("WsoccupationquesByEconomicRegion")]
    private readonly EntityHolder<Wsdevregion> _economicRegion = new EntityHolder<Wsdevregion>();

and then errors when returns to call.  No innerException. just this error:

{"Unable to materialize field [OccupationCodeId] on type [WebCms.Model.WageSalary.Wsoccupationque]. Check your table has an Id column and that your mappings are correct. See inner exception for details. "} 

it has an id column which is int but it seems to die on the foriegn key which is a varchar. 

thanks,

Will