Has anyone had problems with the collation conflicts?
I know that the problem is that a few tables in the DB have text (varchar) fields as primary keys.
Since I cannot change the DB, is there a workaround to make ORM work in this situation?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am not an expert by far in this area but I am guessing that your problem is a conflict between the collation of the TEMPDB (temporary table) database and your DB.
The TEMPDB database is created each time the server is rebooted. TEMPDB has the same default collation sequence as the model DB.
I am not aware on any OR Mappers that do anything special with collation
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Has anyone had problems with the collation conflicts?
I know that the problem is that a few tables in the DB have text (varchar) fields as primary keys.
Since I cannot change the DB, is there a workaround to make ORM work in this situation?
I am not an expert by far in this area but I am guessing that your problem is a conflict between the collation of the TEMPDB (temporary table) database and your DB.
The TEMPDB database is created each time the server is rebooted. TEMPDB has the same default collation sequence as the model DB.
I am not aware on any OR Mappers that do anything special with collation