I'm experiencing an issue when I changed a field type from within the model editor. After changing the type for the field, I assumed I could push the update to the database (MSSQL) and it would update the type, however I received an error. No sweat. I expected as much. So I went into the database and manually updated the field type, to match, still no luck though. Now I have a build error:
cannot be initialized: Type converter initialization failed. The converter with name
does not convert from CLR type
to SQL type
Parameter name: converterName
Actual value was OpenAccessRuntime.Data.VariableLengthAnsiStringConverter. 0 0 Wing Fest Data Model
There are several of these when trying to build.
Next, I tried to create a new database, using the same EntitiesModel rlinq file, but the same issue keeps occurring. The database itself has the correct mappings, matching the model in the designer. I'm guessing the metadata for the rlinq file isn't updatin/matching up.
So, my questions are:
1.) How can I solve this current issue (e.g. update the metadata of the file)
2.) Going forward, is there a 'better' (I know, a loose term) approach to changing the type of a field (e.g. from a string to a boolean)? For a development database.
Running Latest Update of DataAccess, on VS2013 Ultimate. MSSQL Server 2014 backend.